Integrating Oracle and Data Protector

Restoring an Oracle Database

 

''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:

104

Chapter 1