HP A.06.11 - Manual (Page 108)

2. If you performed an Oracle database restore and recovery until point in time,
and the session has finished successfully, reset the database to register the new
incarnation of database in the recovery catalog.
Connect to the target and recovery catalog database using RMAN and reset
the database:
rman target Target_Database_Login catalog
Recovery_Catalog_Login
RMAN> RESET DATABASE;
RMAN> exit
3. If you did not choose to use Data Protector to recover the database objects and
if you have all archived redo logs on disk, perform the following after the
database is restored:
Open a command line window and enter the following commands:
sqlplus /nolog
SQL>recover database;
SQL>connect user/password@service as sysdba;
SQL>alter database open;
4. Oracle Data Guard: If you restored a standby database and if you have all
archived redo logs on disk, restart the managed recovery process (log apply
services):
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
DISCONNECT;
Restoring tablespaces and datafiles
To restore tablespaces and datafiles:
1. Open a command line window and enter the following commands if you have
the database in the Open state:
sqlplus /nolog
SQL>connect user/password@service as sysdba ;
SQL>alter database datafile 'datafile name' offline;
If you are restoring a tablespace enter:
SQL>alter tablespace tablespace_name offline;
Integrating Oracle and Data Protector 108