Integrating Oracle and Data Protector

Restoring an Oracle Database

If you are restoring a tablespace enter:

SQL>alter tablespace <tablespace name> online;

Restoring and Recovering an Oracle Database in Oracle Data Guard EnvironmentRestoring and Recovering a Primary Database

You can restore and recover a primary database from backups done on either a primary or standby database. The restore and recover is almost the same as restore and recover of a database in a standalone configuration. For information, see “Restoring Oracle Using the Data Protector GUI” on page 72.

Restoring and Recovering a Standby Database

You can restore and recover a standby database from backups of either a primary or standby database. The restore and recover is almost the same as restore and recover of a database in a standalone configuration. For information, see “Restoring Oracle Using the Data Protector GUI” on page 72.

If the archived redo log files required for recovery are not accessible on disk, but only on tape, use RMAN to recover the restored datafiles to an SCN/log sequence greater than the last log applied to the standby database.

Obtain UNTIL_SCN:

SQL> SELECT MAX(NEXT_CHANGE#)+1 UNTIL_SCN FROM V$LOG_HISTORY LH, V$DATABASE DB WHERE LH.RESETLOGS_CHANGE#=DB.RESETLOGS_CHANGE# AND LH.RESETLOGS_TIME = DB.RESETLOGS_TIME;

If the archived redo logs required for recovery are accessible on disk, restore only damaged datafiles and restart redo apply process.

If you have lost the entire standby database, it is better to perform duplication of the database (unless only a few damaged datafiles or tablespaces need to be restored).

Perform duplication of the database also when:

•Primary database control file was restored or recreated.

•Point-in-time recovery was performed on the primary database.

84

Chapter 1