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

  • From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
  • To: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • Date: Tue, 19 Jun 2007 15:11:09 +0300

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




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