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."