on 06-27-2013 03:03 AM
How to perform restoration of Oracle Database.
Environment:
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.
RESTORE ACTIVITY
================
start database in no-mount state
start rman and connect to target database
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_SERV=netbkprod1.xyz.com';
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.
Hi Ashi,
Can you please eleborate bit about : control file, Do we need to restore control file file before restoring the required databse.
Please confirm
thank you
Regards,
Priyeranjan