DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Saturday, July 15, 2017

RMAN-20079: full resync from primary database is not done

Problem:

RMAN> crosscheck archivelog all;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 07/23/2012 09:52:53
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at 07/23/2012 09:52:53
RMAN-20079: full resync from primary database is not done

Cause:

There are duplicate records in tf table or df table has missing records.


Solution:

1)

Connect catalog DB

SQL> truncate table <catalog_user>.tf;

Crosscheck again.

If it does not work:

2)
Export records of df table that resides in primary database’s catalog schema and import them into standby database’s catalog schema.

Crosscheck again.