Re: Can you select a Different RMAN backup for DUPLICATE?
- From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
- To: david.cheyne@xxxxxxxxx
- Date: Tue, 19 Jun 2007 14:42:17 +0300
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."
Other related posts:
