'Oracle_home\data\oradata\DATA\temp01.dbf';
release channel dev1;
}
For a ZDB proxy-copy session, allocate one channel for restoring proxy-copy
sessions and one channel for the recovery process. Release the proxy-copy
channel before the recovery:
run{
allocate channel dev1 type 'sbt_tape' parms
'SBT_LIBRARY=Data_Protector_home\bin\orasbt.dll,
ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DB_NAME)';
allocate channel dev2 type 'sbt_tape' parms
'SBT_LIBRARY=Data_Protector_home\bin\orasbt.dll,
ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DB_NAME, OB2PROXYCOPY=1)';
restore datafile
'Oracle_home\data\oradata\DATA\temp01.dbf';
release channel dev2;
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:
• 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
Example of archive log restore
To restore an archive log:
Zero downtime backup integration guide 135
To Next Page
Loading...
Need help?
General