RESTORE USING RMAN TO CREATE ORACLE 12C DATABASE ON SCRATCH SERVER

RESTORE USING RMAN TO CREATE ORACLE 12C DATABASE ON SCRATCH SERVER

Overview

Following is the scenario,

All the hard drives of the production server have been damaged and we have lost all datafiles controlfiles, datafiles and redo log files. As we take regular  backup of the database with RMAN, we can mange this situation by  performing  a disaster recovery to restore and recover the database.

The Following steps has to be followed on scratch server(ie a new vm with linux and oracle home installed on it)

RESTORE THE SPFILE

RESTORE CONTROLFILE

RESTORE DATABASE

RECOVER DATABASE

ALTER DATABASE OPEN RESETLOGS

STEP 1—RESTORE THE SPFILE

STEP 2—STARTUP WITH NEW SPFILE AND RESTORE THE CONTROLFILE

STEP 3— MOUNT AND RESTORE THE DATABASE.

STEP 4—RECOVER THE DATABASE

STEP 5— OPEN THE DATABASE