In this post, you will learn how to recover a database using RMAN. To recover database, an RMAN backup is required. In last article, it was explained that how we can take backup using RMAN. (more…)
Following section explains how we can take full database backup using RMAN command line interface on windows.
Before tacking backup, decide which type of backup you want to take. You can take online or offline backup using RMAN. (more…)
Recovery Manager (RMAN) is client/server utility provided by oracle to perform backup and recovery operations on oracle database. RMAN is available in command-line interface as well as in Enterprise manager GUI. RMAN is part of oracle database and does not require separate installation or configuration. (more…)
We take complete physical backup of database by copying physical database files including datafiles, control files, password file and parameter file. Backup can be online backup or offline backup. In online backup, our database is in open stage and datafiles have different SCN. (more…)
Oracle has provided powerful mechanism to protect database in situation of data loss. This mechanism includes a range of methods to Backup and Recover your data. First step is to backup you data and second step is to recover required data. Broadly speaking, oracle supports two types of backups, Logical Backup and Physical database backups.