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

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