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

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