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?
Joan
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;
}
--
//www.freelists.org/webpage/oracle-l
Other related posts:
