rman duplicate set until time

  • From: Joan Hsieh <joan.hsieh@xxxxxxxxx>
  • To: oracle_l <ORACLE-L@xxxxxxxxxxxxx>
  • Date: Wed, 14 Oct 2009 14:40:11 -0400

Hi List,

I am using rman hot backup to clone a test database. I'd like to make clone the database at sysdate -1 at 5 pm. I am not sure how to format the set until time statement to make it dynamic. SET UNTIL TIME "to_date('Oct 13 2009 17:00:00','Mon DD YYYY HH:MI:SS')"; is working, but how to make it "sysdate -1 17:00:00" in the script?


run {
   allocate auxiliary channel aux1 type disk;
   allocate auxiliary channel aux2 type disk;
   allocate auxiliary channel aux3 type disk;
   set until time 'SYSDATE -1';
   duplicate target database to $A_ORACLE_SID;
   release channel aux1;
   release channel aux2;
   release channel aux3;


Other related posts: