Re: rman duplicate set until time

From: Joan Hsieh <joan.hsieh_at_tufts.edu>
Date: Wed, 14 Oct 2009 16:07:18 -0400
Message-ID: <4AD62F76.70308_at_tufts.edu>

Thanks, I got the fixed date format right. Just can't make it dynamic date working. Since we have to schedule thid job, first I thought to create a variable to pass the backup time. Anyway, we used to use cold rman backup to duplicate. We will change it to hot backup.

Thanks again. --joan

Blanchard, William wrote:

> # SET UNTIL TIME 'Nov 15 2004 09:00:00';
>
> http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192.pdf
>
>
> WGB
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joan Hsieh
> Sent: Wednesday, October 14, 2009 1:40 PM
> To: oracle_l
> Subject: rman duplicate set until time
>
> 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;
> }
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 14 2009 - 15:07:18 CDT