Re: RMAN duplicate is asking for wrong backup

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Fri, 26 Jun 2009 09:29:31 -0400
Message-Id: <4A4494FA.3406.000B.0_at_gcrta.org>

I tried it again and time created the directory for the restore files - had failed to do that. Now looks like it is working.  

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

>>> dave <david.best_at_gmail.com> 6/26/09 9:13 AM >>> 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:29:31 CDT