RMAN duplicate is asking for wrong backup

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Fri, 26 Jun 2009 08:40:34 -0400
Message-Id: <4A448981.3406.000B.0_at_gcrta.org>

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 - 07:40:34 CDT

Original text of this message