| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Can you select a Different RMAN backup for DUPLICATE?
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> 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
--
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 19 2007 - 07:02:45 CDT
 |
 |