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

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <sjaffarhussain@xxxxxxxxx>, <david.cheyne@xxxxxxxxx>
  • Date: Tue, 19 Jun 2007 08:02:45 -0400

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

Other related posts: