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

set until specifies the timestamp at which you want the recovery to end, not the timestamp for the restore surely?

There isn't a FROM TAG specifier to say what backup to use for the duplicate database command, so I'd say you would be using the manual process of.

restore from tag
recover until
using nid at the os level to set the new dbid.

regards

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

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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