For a ZDB proxy-copy session, allocate one channel for restoring proxy-copy
sessions and one channel for database recovery. Release the proxy-copy
channel before the recovery:
run{
allocate channel 'dev1' type 'sbt_tape' parms
'SBT_LIBRARY=/opt/omni/lib/libob2oracle8.so,
ENV=(OB2BARTYPE=Oracle8,OB2PROXYCOPY=1, OB2APPNAME=DB_NAME)';
allocate channel 'dev2' type 'sbt_tape' parms
'SBT_LIBRARY=/opt/omni/lib/libob2oracle8.so,
ENV=(OB2BARTYPE=Oracle8, OB2APPNAME=DB_NAME)';
restore tablespace 'TEMP';
release channel 'dev1';
recover tablespace 'TEMP';
release channel 'dev2';
}
You can also save the script into a file and perform a tablespace restore using the
saved files:
1. Create a file restore_TAB in the /var/opt/omni/tmp (UNIX systems) or
Data_Protector_home\tmp (Windows systems) directory.
2. Start the tablespace restore.
• On Windows: ORACLE_HOME\bin\rman target sys/manager@PROD
catalog rman/rman@CATAL
cmdfile=Data_Protector_home\tmp\restore_TAB
• On UNIX: ORACLE_HOME/bin/rman target sys/manager@PROD
catalog rman/rman@CATAL
cmdfile=/var/opt/omni/tmp/restore_TAB
Example of datafile restore and recovery
To restore and recover a datafile, you may take only a part of the database offline.
To restore and recover a datafile:
1. Log in to the Oracle RMAN.
• On Windows: ORACLE_HOME\bin\rman target sys/manager@PROD
catalog rman/rman@CATAL
• On UNIX: ORACLE_HOME/bin/rman target sys/manager@PROD
catalog rman/rman@CATAL
Zero downtime backup integration guide 131
To Next Page
Loading...
Need help?
General