How to perform restoration of Oracle Database.
This document is third part of (Backup/Restore of Oracle Database).In this article I will explain how to restore Oracle server databases.
1- First we have to start the database in nomunt state.
2- We have to restore the control file for Point in Time recovery.
bplist -C test_oradb1.xyz.com -t 4 -R /
note down the control file you want to restore.
3- Connect to RMAN and run the following rman command to restore the control file.
start database in no-mount state
start rman and connect to target database
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
RESTORE CONTROLFILE from 'ctrl_u31mksibs_s97_p1_t760105340';
RELEASE CHANNEL ch00;
4- Mount the oracle database and run the Backup,Archive Restore wizard to restore the database and then select the required databases.
5- Enter the user Credentials.
6- Select Restore and Recover checkboxes.
7- Set the Restore time (i.e. Point in Time)
8- Set the point in time for recovery
9- Mark on checkbox ‘bring database online after restore/recover complete"
10- You can save this script on local folder and run it immediately.
11- Run the restore job and check backup status through activity monitor
12- After restoring database goto Oracle server and check the status of point in time restore.
I hope this article will be helpful and informative for you.
Can you please eleborate bit about : control file, Do we need to restore control file file before restoring the required databse.