Hi all, Thanks in first for your valuable responses. When I try to run the below script, I am getting the following error, connect catalog **** connect target **** connect auxiliary / run { allocate auxiliary channel ch1 type disk; set until time "to_date('Oct 12 2008 09:00:00','Mon DD YYYY HH24:MI:SS')"; recover clone database until time "to_date('OCT 17 2008 16:00:00','Mon DD YYYY HH24:MI:SS')"; duplicate target database to <TEST_DB_NAME>; } allocated channel: ch1 channel ch1: sid=500 devtype=DISK Starting recover at 27-10-2008 06:09:15 released channel: ch1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 10/27/2008 06:09:16 RMAN-06555: datafile 1 must be restored from backup created before 17-10-2008 16:00:00 Recovery Manager complete. Please correct if I am wrong, I am new to RMAN and needs your input if anything is wrong. For your information, i could restore and recover the database only for 12th as I have LEVEL 0 12th backup directory. Is it correct that unless we have incremental LEVEL 1 backup associated to 12 Level 0 backup, the above command wont work? Thanks, Ann On Mon, Oct 27, 2008 at 6:45 PM, Bort, Guillermo <guillermo.bort@xxxxxxx>wrote: > I am not certain as to the exact name of the env variable, however an > alternative that works well is > > > > Run { > > Sql 'alter session set nls_date_formate '''dd-mm-yyyy hh24:mi:ss''''; > > … > > } > > > > regards > > *Guillermo Alan Bort* > > DBA / DBA Main Team > > > > *EDS*, an HP company > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Jan-Hendrik.Boll@xxxxxxxxxxx > *Sent:* Monday, October 27, 2008 11:11 AM > *To:* oracle-l@xxxxxxxxxxxxx > *Subject:* WG: How to restore only archives from RMAN catalog > > > > There is no need to use the to_date() function as the date-format has been > exported. > > > ------------------------------ > > *Von:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > *Im Auftrag von *Syed Jaffar Hussain > *Gesendet:* Montag, 27. Oktober 2008 13:36 > *An:* guillermo.bort@xxxxxxx > *Cc:* usn@xxxxxxxxx; shastry17@xxxxxxxxx; oracle-l > *Betreff:* Re: How to restore only archives from RMAN catalog > > >>Set until time '17-10-2008 00:00:00';" > > *I doubt it will work correctly. * > > *If I am not wrong, you should use "**to_date*('17-10-2008 00:00:00', > 'DD-MM-YYYY HH:MI:SS')" > > > > > > On Mon, Oct 27, 2008 at 3:30 PM, Bort, Guillermo <guillermo.bort@xxxxxxx> > wrote: > > Something like > > Export NLS_DATE='dd-mm-yyyy hh24:mi:ss' > Rman target / > Run { > Set until time '17-10-2008 00:00:00'; > Restore database; > Recover database; > Alter database open resetlogs; > } > > *Should* work > > Guillermo Alan Bort > DBA / DBA Main Team > > EDS, an HP company > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Martin Klier > Sent: Monday, October 27, 2008 10:22 AM > To: shastry17@xxxxxxxxx > Cc: oracle-l > Subject: Re: How to restore only archives from RMAN catalog > > Hi, > > you can give RMAN a regular date/time point-in-time for recovery, or a > SCN, or a log sequence number, just look up the RMAN documentation. > > Example: > RMAN> recover database until time 'sysdate -3'; > > Regards > Martin Klier > > Shastry(DBA) schrieb: > > 2PM(in my case) in test environment. Please advice if there is a > chance > > to restore only archives to the test server on some mount and then > apply > > archives manually till the requested time, if suppose it is possible > can > > we mention the specific location to restore the required archives ( i > > believe we need to mention the SCN number to restore). > -- > Usn's IT Blog for Linux, Oracle, Asterisk > http://www.usn-it.de > > -- > //www.freelists.org/webpage/oracle-l > > > -- > //www.freelists.org/webpage/oracle-l > > > > > -- > Best Regards, > > Syed Jaffar Hussain > Oracle Certified Master (10g) > http://www.oracle.com/technology/ocm/shussain.html > Oracle ACE > http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:126 > OCP 8i,9i & 10g DBA > RAC Certified Expert > Official Oracle RAC SIG Representative for Saudi Arabian region ( > http://www.oracleracsig.org/) > I blog at > http://jaffardba.blogspot.com/ > -------------------- > "Winners don't do different things. They do things differently." >