Wednesday, August 21, 2013

Complete DB point in time recovery


     
 cat clone_rman2.cmd
run {
allocate CHANNEL ch1 type disk;
allocate CHANNEL ch2 type disk;
allocate CHANNEL ch3 type disk;
allocate CHANNEL ch4 type disk;
allocate CHANNEL ch5 type disk;
allocate CHANNEL ch6 type disk;
#set newname for tempfile 1 to '+ORAFILES/atgtest/TEMPFILE/temp.dbf';
set until time "to_date('2013 Aug 20 09:50','yyyy mon dd hh24:mi')";
recover database;
}

Followers