Re: RMAN duplicate is asking for wrong backup

From: dave <david.best_at_gmail.com>
Date: Fri, 26 Jun 2009 09:13:19 -0400
Message-ID: <9256898f0906260613x1dabaa8bif513d2d9c0781221_at_mail.gmail.com>

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_at_gcrta.org> 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

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

Received on Fri Jun 26 2009 - 08:13:19 CDT