Restore database step by step procedure
Posted by Mir Sayeed Hassan on October 2nd, 2017
Restore the Oracle database Procedure
-
Copy the datafiles, archivelog files and controlfile to restore backup location
-
Set the SID of the restore database in .bash_profile and run the bash profile — $. .bash_profile
-
Crosscheck the existing backup restore, if any expired, delete those backup – RMAN> delete expired backup;
RMAN> crosscheck backup;
RMAN> delete expired backup;
-
Set to restore the database
RMAN > restore controlfile from ‘/backup/ctlfile.ctl’; <Mention the controlfile name in backup location>
-
After successful restore of the controlfile – mount the database
RMAN> alter database mount;
-
Now catalog the backup files from the backup location
RMAN> catalog start with '/backup';
-
List backup of archivelog all;
-
Now find the highest SCN No & Copy it, then start the restore of thee database
RMAN> run {
set newname for database to '/oradata/datafiles/%b'; --- Here all the datafile will be places in given location
set until scn 1091462; --- This is highest SCN Available
restore database;
switch datafile all; - To switch all the datafile to new location
recover database;
}
-
After successfully restore & recover of the database, now open the database with resetlogs
RMAN> alter database open reset logs;