RMAN duplicate is asking for wrong backup

  • From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
  • To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
  • Date: Fri, 26 Jun 2009 08:40:34 -0400

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: