Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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

Created: 27 Jun 2013 • Updated: 08 Jul 2013 | 1 comment
Language Translations
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