Filter
Top Products
Integrating Oracle and Data Protector
Restoring an Oracle Database
Chapter 1 99
•On OpenVMS: rman target sys/manager@PROD
sys/manager@PROD catalog rman/rman@CAT
Oracle 8i:
Use rcvcat instead of catalog in the above syntax.
If you do not use the recovery catalog, 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 point-in-time restore:
run{
allocate channel 'dev1' type 'sbt_tape' parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=<DB_NAME>)';
set until time 'Mar 14 2004 11:40:00';
restore database;
recover database;
sql 'alter database open';
release channel 'dev1';
}
3. After you have performed a point-in-time restore, reset the database
in the Recovery Catalog.
You can also save the script into a file and perform a point-in-time
restore using the saved files:
1. Create a file restore_PIT in the /var/opt/omni/tmp or
<Data_Protector_home>\tmp directory.
2. Start the point-in-time restore:
If you use the recovery catalog database, run:
Oracle 9i/10g: