Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Backup/Restore of Oracle Database Part 3 of 3- Restoration of Oracle Database

Created: 27 Jun 2013 • Updated: 08 Jul 2013 | 1 comment
ashi's picture
+11 13 Votes
Login to vote

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 1 CommentJump to latest comment

Priyeranjan's picture

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

Thanks & Regards,

Priyeranjan K

Support Services Engineer

0
Login to vote