HP A.06.11 User Manual

Page 128

Advertising
background image

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
'SBT_LIBRARY=Data_Protector_home\bin\orasbt.dll,
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:

• On Windows: ORACLE_HOME/bin/rman target sys/manager@PROD

catalog rman/rman@CATAL

cmdfile=/var/opt/omni/tmp/restore_dbf

• On UNIX: ORACLE_HOME\bin\rman target sys/manager@PROD

catalog rman/rman@CATAL

cmdfile=Data_Protector_home\tmp\restore_dbf

If you do not use the recovery catalog database, run:

• On Windows: ORACLE_HOME\bin\rman target sys/manager@PROD

nocatalog cmdfile=Data_Protector_home\tmp\restore_dbf

• On UNIX: ORACLE_HOME/bin/rman target sys/manager@PROD

nocatalog cmdfile=/var/opt/omni/tmp/restore_dbf

Integrating Oracle and Data Protector

128

Advertising