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

From: Mandal, Ashoke <ashoke.k.mandal_at_medtronic.com>
Date: Tue, 19 Jun 2007 08:45:02 -0500
Message-ID: <F184F089F3A34E428AA57BB0D43626ED010CF40A@MSPM1BMSGM04.ent.core.medtronic.com>

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

Thanks,
Ashoke

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Syed Jaffar Hussain
Sent: Tuesday, June 19, 2007 7:11 AM
To: Mercadante, Thomas F (LABOR)
Cc: david.cheyne_at_gmail.com; 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_at_labor.state.ny.us> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Syed Jaffar Hussain

	Sent: Tuesday, June 19, 2007 7:42 AM
	To: david.cheyne_at_gmail.com
	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_at_gmail.com <mailto: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 <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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 19 2007 - 08:45:02 CDT