Integrating Oracle and Data Protector

Restoring an Oracle Database

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

Chapter 1

103