cancel
Showing results for 
Search instead for 
Did you mean: 

Protection

How to perform restoration of Oracle Database.

Environment:

  •     Netbackup Server 7.1 on Windows Server 2003
  •     Oracle  on Windows Server 2003

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.

ScreenShot001_1.jpg

2- We have to restore the control file for Point in Time recovery.

  • List the control file by running the following command

          bplist -C test_oradb1.xyz.com -t 4 -R /

note down the control file you want to restore.

t002.jpg

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;

}

003.jpg

4- Mount the oracle database and run the Backup,Archive Restore wizard to restore the database and then select the required databases.

ScreenShot005_0.jpg

5- Enter the user Credentials.

ScreenShot006_0.jpg

6- Select Restore and Recover checkboxes.

ScreenShot007_0.jpg

7- Set the Restore time (i.e. Point in Time)

ScreenShot008_0.jpg

8- Set the point in time for recovery

ScreenShot009_0.jpg

 

9- Mark on checkbox ‘bring database online after restore/recover complete"

ScreenShot010_0.jpg

10- You can save this script on local folder and run it immediately.

ScreenShot011_0.jpg

11- Run the restore job and check backup status through activity monitor

ScreenShot014_0.jpg

12- After restoring database goto Oracle server and check the status of point in time restore.

ScreenShot015_0.jpg

I hope this article will be helpful and informative for you.

 

 

 

Comments

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