RMAN-06571: Datafile 1 Does Not Have Recoverable Copy

Rman-06571: Datafile 1 Does Not Have Recoverable Copy

Version : 10.2.04 and Later

Errors:

During incremental roll forward of standby.

RMAN> SWITCH DATABASE TO COPY;

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

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

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

RMAN-03002: failure of switch to copy command at 03/13/2012 07:51:46

RMAN-06571: datafile 1 does not have recoverable copy

Alertlog message:

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

Setting recovery target incarnation to 2 Tue Mar 13 07:46:35 2012 Setting recovery target incarnation to 2

PRIMARY:

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

RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations

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

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

1       1       Primary 489996286        CURRENT 1          29-MAR-11

STANDBY:

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

RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations

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

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

1       1       STANDBY 489996286        PARENT  1          29-MAR-11

2       2       STANDBY 489996286        CURRENT 1912505686 10-SEP-11

Solution:

If you see above incarnation number if different in primary and standby, we need to swtich incarnation to be same as current incarantion in primary, this will resolve our issue. 

rman target /

reset database to incarnation <incarnation number here>;

recover database noredo;

exit

In this case it would be like this

rman target /

reset database to incarnation 1;

switch database to copy

recover database noredo;

exit