HP (Hewlett-Packard) B6960-96008 Garage Door Opener User Manual


 
Integrating Oracle and Data Protector
Restoring an Oracle Database
Chapter 184
If you are restoring a tablespace enter:
SQL>alter tablespace <tablespace name> online;
Restoring and Recovering an Oracle Database in
Oracle Data Guard Environment
Restoring 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.