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

 

 

 

Recent Posts