Filter
Top Products
Integrating Oracle and Data Protector
Restoring an Oracle Database
Chapter 1104
''C:\oracle\data\oradata\DATA\temp01.dbf'' online";
release channel dev1;
}
• If the database is in a mount state, the script to restore and
recover the datafile should have the following format:
UNIX run{
allocate channel dev1 type 'sbt_tape' parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=<DB_NAME>)';
restore datafile
'/opt/oracle/data/oradata/DATA/temp01.dbf';
recover datafile
'/opt/oracle/data/oradata/DATA/temp01.dbf';
release channel dev1;
}
Windows run{
allocate channel dev1 type 'sbt_tape' parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=<DB_NAME>)';
restore datafile
'<Oracle_home>\data\oradata\DATA\temp01.dbf';
recover datafile
'<Oracle_home>\data\oradata\DATA\temp01.dbf';
release channel dev1;
}
You can also save the script into a file and perform a datafile restore
using the saved files:
1. Create a file restore_dbf the /var/opt/omni/tmp or
<Data_Protector_home>\tmp (Windows systems) directory.
2. Start the datafile restore:
If you use the recovery catalog database, run:
Oracle 9i/10g: