HP A.06.11 - Manual (Page 109)

2. When the restore has been completed put the datafiles and tablespaces back
online with the following procedures:
Open a command line window and enter the following commands:
sqlplus /nolog
SQL>connect user/password@service as sysdba
If you are restoring a datafile enter:
SQL>alter database datafile 'datafile_name' online;
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 96.
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 96.
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;
Integration guide for Oracle and SAP 109