Error Code RMAN-20011: target database incarnation is not current in recovery catalog

RMAN-20011

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of configure command at 05/12/2008 18:21:50

RMAN-06004: ORACLE error from recovery catalog database:

RMAN-20011: target database incarnation is not current in recovery catalog

Details:

The above error occurs when the Database target Incarnation is not current in the Recovery Catalog.

The incarnation of a database is a number that is used to identify a version of the database.
A database incarnation is created whenever you open the database with the RESETLOGS.

V$DATABASE_INCARNATION displays information about all database incarnations. Oracle creates
a new incarnation whenever a database is opened with the RESETLOGS option. Records about the
current and immediately previous incarnation are also contained in the V$DATABASE view.

To Reference the corresponding Incarnation information in the recovery catalog review the

RC_DATABASE_INCARNATION and RC_DATABASE views.

RC_DATABASE_INCARNATION lists information about all database incarnations registered in

the recovery catalog.

RC_DATABASE lists information about the databases registered in the recovery catalog.

It corresponds to the V$DATABASE view in your target database.

Solution:

Connect to the RMAN schema as rman user e.g.

$ sqlplus rman/rman@RMANREP

SQL> select DBID, NAME, DBINC_KEY, RESETLOGS_CHANGE#, RESETLOGS_TIME

from rc_database_incarnation where dbid=2131079213;

DBID NAME DBINC_KEY RESETLOGS_CHANGE# RESETLOGS

---------- -------- ---------- ----------------- ---------

2131079213 DATABASE 1274431 80473525 20-JUN-07

2131079213 DATABASE 1274433 80251948 18-JUN-07

Connect to the RMAN catalog from the target databse

$ rman catalog rman/rman@RMANREP target sys/manager@DATABASE

Reset the database to the latest incarnation

RMAN> reset database to incarnation 1274431;

database reset to incarnation 1274431

Resync the catalog

RMAN> resync catalog;

starting full resync of recovery catalog

full resync complete

Verify all changes

RMAN> list incarnation;

starting full resync of recovery catalog

full resync complete

List of Database Incarnations

DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1274430 1274433 DATABASE 2131079213 PARENT 80251948 18-JUN-07

1274430 1274431 DATABASE 2131079213 CURRENT 80473525 20-JUN-07