user manual

Integrating Oracle and Data Protector
Restoring an Oracle Database
Chapter 1 103
Use rcvcat instead of catalog in the above syntax.
If you do not use the recovery catalog database, run:
• 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 datafile restore and recovery:
• If the database is in an open state, the script to restore the datafile
should have the following format:
UNIX run{
allocate channel dev1 type 'sbt_tape' parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=<DB_NAME>)';
sql "alter database datafile
''/opt/oracle/data/oradata/DATA/temp01.dbf'' offline";
restore datafile
'/opt/oracle/data/oradata/DATA/temp01.dbf';
recover datafile
'/opt/oracle/data/oradata/DATA/temp01.dbf';
sql "alter database datafile
'/opt/oracle/data/oradata/DATA/temp01.dbf' online";
release channel dev1;
}
Windows run{
allocate channel dev1 type 'sbt_tape' parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=<DB_NAME>)';
sql "alter database datafile
''C:\oracle\data\oradata\DATA\temp01.dbf'' offline";
restore datafile
'C:\oracle\data\oradata\DATA\temp01.dbf';
recover datafile
'C:\oracle\data\oradata\DATA\temp01.dbf';
sql "alter database datafile