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

  • From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
  • To: knecht.stefan@xxxxxxxxx
  • Date: Tue, 19 Jun 2007 15:04:27 +0300

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@xxxxxxxxx> wrote:

Use the SET UNTIL clause in your run {} block

Stefan

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



--
=========================

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

Other related posts: