HP OpenView Storage Data Protector B6960-96008 User Manual
![HP](https://files.manualsbrain.com/attachments/29005dca542c93ad59e01e223583dbd51961550d/common/fit/150/50/3931a36faa9f1af0627fe52b73d277ccf98e5d18c55433f253353db13ee5/brand_logo.jpeg)
Integrating Oracle and Data Protector
Restoring an Oracle Database
Chapter 1
101
• On Windows:
<ORACLE_HOME>\bin\rman target
sys/manager@PROD nocatalog
• On UNIX:
<ORACLE_HOME>/bin/rman target sys/manager@PROD
nocatalog
• On OpenVMS:
rman target sys/manager@PROD nocatalog
2. Start the tablespace restore and recovery.
• If the database is in the open state, the script to restore and
recover the tablespace should have the following format:
run{
allocate channel <dev1> type 'sbt_tape' parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=<DB_NAME>)';
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=<DB_NAME>)';
sql 'alter tablespace TEMP offline immediate';
restore tablespace TEMP;
recover tablespace TEMP;
sql 'alter tablespace TEMP online';
release channel dev1;
}
• If the database is in the mount state, the script to restore and
recover the tablespace should have the following format:
run{
allocate channel <dev1> type 'sbt_tape' parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=<DB_NAME>)';
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=<DB_NAME>)';
restore tablespace 'TEMP';
recover tablespace 'TEMP';
release channel <dev1>;
}
You can also save the script into a file and perform a tablespace restore
using the saved files:
using the saved files:
1. Create a file
restore_TAB
in the
/var/opt/omni/tmp
(UNIX
systems) or
<Data_Protector_home>\tmp
(Windows systems)
directory.