Oracle restoration through NMO.

Hi Sabarna,

Did you take on-line or off-line backups? In other words, did you use NMO (NetWorker Module for Oracle) or NMDA (NetWorker Module for Databases and Applications)?

Did you modify RMAN script to backup control file?

Set up RMAN backups of the database and related files

Set up an RMAN backup with NMO to back up the following files:

Oracle database (all the datafiles)

Archived redo logs

Control file

Initialization parameter file SPFILE (server-managed parameter file)

Follow the instructions in the preceding chapters of this guide to properly configure and run the RMAN backup with NMO.

For example, to include the control file and SPFILE in the backup, you can add the following commands to the RMAN backup script:

backup current control file

backup spfile

The RMAN documentation provides details on RMAN commands and scripts. If you want to back up PFILE (user-managed parameter file) or other files that Oracle

RMAN does not back up, you can use a postcommand script. Set up a postcommand script for backup of Oracle-related files on page 131 provides details on setting up the postcommand script.

In the NetWorker indexes, the NWORA resource file backup is stored under the "backup" namespace. As a result, the NetWorker recover or nwrecover program can be used to restore the backup. The save set name for the backup is the same as the file pathname.

Note: The file is stored under the "backup" namespace, not the "oracle" namespace.

Please take a look at the documentation for further information in restore procedures:

https://powerlink.emc.com/nsepn/webapps/btg548664833igtcuup4826/km/live1//en_US/Offering_Technical/Technical_Documentation/300-006-993.pdf

Thank you.

Carlos.