Re: Can you select a Different RMAN backup for DUPLICATE?

Stefan,

If the old backupset status is 'UNAVAILABLE', it needs to be first made AVAILABLE before using it.

On 6/19/07, Stefan Knecht <knecht.stefan_at_gmail.com> wrote:
>
> Use the SET UNTIL clause in your run {} block
>
> Stefan
>
> 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
> >
> >
> >
>
>
>
> --
> =========================
>
> Stefan P Knecht
> Consultant
> Infrastructure Managed Services
>
> Trivadis AG
> Europa-Strasse 5
> CH-8152 Glattbrugg
>
> Phone +41-44-808 70 20
> Fax +41-808 70 12
> Mobile +41-79-571 36 27
> stefan.knecht_at_trivadis.com
> http://www.trivadis.com
>
> =========================

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