Integrating Oracle and Data Protector

Restoring an Oracle Database

limit of redo logs to restore. Data Protector restores the backup that can be used in recovery to the specified log sequence number.

•Selected SCN number

Use this option to specify the SCN number to which you wish the database to be restored. Data Protector restores the backup that can be used in recovery to the specified SCN number.

Recover until

The options in this drop-down list allow you to specify to which point in time you would like the recovery to be performed.

•Now

Data Protector starts RMAN to recover the database to the most recent time possible by applying all archived redo logs. By default, this option is selected.

•Selected time

Use this option to specify an exact time to which the archive logs are applied.

•Selected logseq/thread number

A logseq number is a redo log sequence number. Use this option to specify a particular redo log sequence and a thread number which will act as an upper limit of redo logs to recover.

•Selected SCN number

Use this option to specify the SCN number to which you perform the recovery.

If you reset the logs, also reset the database, otherwise Oracle will during the next backup try to use the logs that were already reset and the backup will fail. Login to the target and recovery catalog database and run:

Oracle 9i/10g:

rman target <Target_Database_Login> catalog <Recovery_Catalog_Login>

92

Chapter 1