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

  • From: "Mandal, Ashoke" <ashoke.k.mandal@xxxxxxxxxxxxx>
  • To: <sjaffarhussain@xxxxxxxxx>, "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • Date: Tue, 19 Jun 2007 08:45:02 -0500

I have used set until successfully to duplicate a database from an
older(not the immediate last) backup.

Thanks,
Ashoke

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Syed Jaffar Hussain
Sent: Tuesday, June 19, 2007 7:11 AM
To: Mercadante, Thomas F (LABOR)
Cc: david.cheyne@xxxxxxxxx; Oracle Mailing List
Subject: Re: Can you select a Different RMAN backup for DUPLICATE?


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
<mailto: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 <http://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."


___________________________________________________________________________________________________
CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is 
intended for use only by the individual or entity to which it is addressed, and 
may contain information that is private, privileged, confidential or exempt 
from disclosure under applicable law. If you are not the intended recipient or 
it appears that this mail has been forwarded to you without proper authority, 
you are notified that any use or dissemination of this information in any 
manner is strictly prohibited. In such cases, please delete this mail from your 
records.

To view this notice in other languages you can either select the following link 
or manually copy and paste the link into the address bar of a web browser: 
http://emaildisclaimer.medtronic.com

Other related posts: