RMAN: CONTROL FILE RECOVERY SCENARIOS

Every Oracle Database has a control file as one of its important file. It is a small binary file that records the physical structure of the database.

Recovery scenario during Loss of system datafile.

LOSS OF SYSTEM DATAFILE (Complete recovery because we have online redo logs and current controlfile)

Assumption:

- All the archive logs are found in local file system for recovery.

- If there are multiple datafiles under system tablespace,try restoring all the system tablespace datafiles and do the recover.

Tablespace point in time recovery

This is new feature for Oracle 11g R2.

I'm going to demonstrate how to recover dropped Tablespace using RMAN Tablespace point in time recovery.

Step 1: Create Tablespace

SQL> conn / as sysdba

Connected.