ZDLRA: Reconcile Error : ORA-20001 target database not found in recovery catalog (Doc ID 2777358.1)

Last updated on FEBRUARY 11, 2022

Applies to:

Symptoms

• Upstream is reporting  the following  incident   :

ORA-64771: reconcile error during task_reconcile; replication server: <replication_server_name>; database: <db_unique_name>
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-64776: message from downstream replication server during reconcile put:
"ORA-20001:
ORA-45199: Error ORA-20001: target database not found in recovery catalog
ORA-06512: at "RASYS.DBMS_RCVCAT", line 22509
ORA-06512: at "RASYS.DBMS_RCVCAT", line 2705
ORA-06512: at "RASYS.DBMS_RCVCAT", line 2897
ORA-06512: at "RASYS.DBMS_RCVCAT", line 21958
ORA-06512: at line 1
encountered when executing begin dbms_rcvcat.readFixedSections(:name); end;."
ORA-06512: at "RASYS.DBMS_RCVCAT", line 3502
ORA-06512: at "RASYS.DBMS_RCVCAT", line 20380
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at line 1
ORA-06512: at "RASYS.DBMS_RCVCAT", line 18702
ORA-29269: HTTP server error
ORA-06512: at "RASYS.DBMS_RCVCAT", line 18678
ORA-06512: at "RASYS.DBMS_RCVCAT", line 20342
ORA-06512: at "RASYS.DBMS_RCVCAT", line 3457

• The trace file of reconcile is showing the following messages :
  
  
  ::::::::::::::::::
  encountered when executing begin dbms_rcvcat.readFixedSections(:name);
  end;.", db_key=66967762
  DBGRCVCAT: writeFixedSections: end read-only txn - err2,commitChanges commit,
  release locks
  DBGRCVCAT: doReplicationReconcile: resync (fail):ORA-64776: message from
  downstream replication server during reconcile put:
  "ORA-20001:
  ORA-45199:
  Error ORA-20001: target database not found in recovery catalog
  ORA-06512: at "RASYS.DBMS_RCVCAT", line 22509
  ORA-06512: at "RASYS.DBMS_RCVCAT", line 2705
  ORA-06512: at "RASYS.DBMS_RCVCAT", line 2897
  ORA-06512: at "RASYS.DBMS_RCVCAT", line 21958
  ORA-06512: at line 1
  encountered when executing
  begin dbms_rcvcat.readFixedSections(:name); end;."
  BEGIN dbms_ra_int.replication_reconcile( '<db_unique_name>' , '<replication_server_name'); END;

• The Protected db already exist in Downstream :
  
  
•   

Changes

None

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.