Re: RMAN duplicate is asking for wrong backup

I always restore to the latest SCN.  Login to your catalog via rman and
execute list backup,
take the Ckp SCN add 1 to it and use that in your restore.  ie:

 List of Datafiles in backup set 64482
 File LV Type Ckp SCN    Ckp Time  Name
 ---- -- ---- ---------- --------- ----
 15   1  Incr 5965314506755 26-JUN-09
/u02/oracle/db/apps_st/data/a_txn_ind06.dbf


So I would use:

run {
set until scn 5965314506756;
allocate auxiliary channel ch2 type disk;
duplicate target database to 'TEST';}
}


On Fri, Jun 26, 2009 at 8:40 AM, Jeffrey Beckstrom<JBECKSTROM@xxxxxxxxx>
wrote:
> We are experimenting with RMAN.  Now testing the "duplicate" command.  I
> tried running the duplicate command and it is asking for a backup from
April
> 20 instead of the current backup.  I notice that a new incarnation of the
> database was created on April 20 probably when we tested a restore of the
> database.  How do I get rman to use the correct backup?
>
> RMAN> list incarnation of database;
>
> List of Database Incarnations
> DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
> ------- ------- -------- ---------------- --- ---------- ----------
> 685     701     DBATEST  472074346        PARENT  4377808045 14-JAN-08
> 685     702     DBATEST  472074346        PARENT  4594551687 20-APR-09
> 685     686     DBATEST  472074346        CURRENT 4595318436 24-APR-09
>
> RMAN>
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113

Other related posts: