HP OpenView Storage B6960-96008 manual Restoring Oracle Using Rman, Open database after recovery

Models: OpenView Storage B6960-96008

1 396
Download 396 pages 29.22 Kb
Page 115
Image 115

Integrating Oracle and Data Protector

Restoring an Oracle Database

RMAN> RESET DATABASE;

RMAN> exit

Oracle 8i:

Use rcvcat instead of catalog in the above syntax.

Open database after recovery

Opens the database after a recovery is performed.

Reset logs

Resets the archive logs after the database is opened.

Always reset the logs:

After an incomplete recovery.

If a backup of a control file is used in recovery or restore and recovery.

Do not reset the logs:

After a complete recovery when the backup of a control file was not used in recovery or restore and recovery.

On the primary database, if the archive logs are used for a standby database. However, if you must reset the archive logs, you will need to recreate the standby database.

If you reset the logs when the Restore until option is set to Now, a warning is displayed, stating that you should reset the logs only if you use a backup of the control file for restore.

NOTE

Oracle recommends that you perform a complete backup immediately

 

after a database was opened with the Reset Logs option.

 

 

Restoring Oracle Using RMAN

Data Protector acts as a media management software for the Oracle system, therefore RMAN can be used for a restore.

Chapter 1

93

Page 115
Image 115
HP OpenView Storage B6960-96008 manual Restoring Oracle Using Rman, Open database after recovery, Reset logs