Re: RMAN duplicate is asking for wrong backup
- From: dave <david.best@xxxxxxxxx>
- To: JBECKSTROM@xxxxxxxxx
- Date: Fri, 26 Jun 2009 09:13:19 -0400
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:
