For a non-ZDB or ZDB backup set session:
run{
allocate channel dev1 type 'sbt_tape' parms
'SBT_LIBRARY=Data_Protector_home\bin\orasbt.dll,
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
''C:\oracle\data\oradata\DATA\temp01.dbf'' online";
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)';
sql "alter database datafile
''Oracle_home\data\oradata\DATA\temp01.dbf'' offline";
restore datafile
'Oracle_home\data\oradata\DATA\temp01.dbf';
release channel dev2;
recover datafile
'Oracle_home\data\oradata\DATA\temp01.dbf';
sql "alter database datafile
''Oracle_home\data\oradata\DATA\temp01.dbf'' online";
release channel dev1;
}
Zero downtime backup integration guide 133