Yes, you are right, I was bit confused with something else. On 6/19/07, Mercadante, Thomas F (LABOR) < Thomas.Mercadante@xxxxxxxxxxxxxxxxx> wrote:
Jaffar, Why do you need to mark the backupsets as unavailable? Won't the "set until" clause work correctly? Tom ------------------------------ *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Syed Jaffar Hussain *Sent:* Tuesday, June 19, 2007 7:42 AM *To:* david.cheyne@xxxxxxxxx *Cc:* Oracle Mailing List *Subject:* Re: Can you select a Different RMAN backup for DUPLICATE? Read Metalink Note : 209214.1 *How To Restore From An Old Backupset Using RMAN?* If you dont have access, do the following. From RMAN, run LIST BACKUP Temporarly, make the all recent backupsets to UNAVAILABLE: RMAN> CHANGE BACKUPSET <number> UNAVAILABLE; Now, you need to make sure the required data backupset are AVAILABLE RMAN> CHANGE BACKUPSET <oldbackpsetnumber> AVAILABLE; Use the SET CLAUSE run { SET UNTIL TIME "to_date(' required date') restore database; recover database; } Jaffar On 6/19/07, *David cheyne* <david.cheyne@xxxxxxxxx> wrote: Hi List, I am using RMAN to duplicate our live DB to another identical machine. Full On-line backups are taken 5 days a week (file is 25Gb on disk), each one includes *all* archive logs. I have been asked to see if we can use a different nights backup for the duplication process, other than the last backup taken. I can't find anything on MetaLink and Rob Freemans book only mentions that Duplicate uses the last good backup. Is this possible?? If so how? *Specs:* *Oracle: 9.2.0.4 64-bit* *O/S: Solaris 2.8* Many thanks -- ~~~~~~~~~~~~~~~~~~~~~~~ David Cheyne BA(hons.) Oracle Database Administrator -- Best Regards, Syed Jaffar Hussain Oracle ACE 8i,9i & 10g OCP DBA http://jaffardba.blogspot.com/ http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently."
-- Best Regards, Syed Jaffar Hussain Oracle ACE 8i,9i & 10g OCP DBA http://jaffardba.blogspot.com/ http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently."