ZDLRA: ORA-45199 ORA-00001: unique constraint (RASYS.RCFILE_U1) violated during Reconcile Task
(Doc ID 2802449.1)
Last updated on AUGUST 26, 2021
Zero Data Loss Recovery Appliance Software - Version 18.104.22.168.2 to 22.214.171.124.2 [Release 19] Information in this document applies to any platform.
Reconcile Task is reporting the following incident for many Protected dbs replicating :
ORA-64817: error interacting with downstream Recovery Appliance during task_reconcile; replication server: <REPLICATION_SERVER_NAME>; database: <DATABASE_NAME> ORA-64776: message from downstream replication server during reconcile put: "ORA-00001: unique constraint (.) violated ORA-45199: Error ORA-00001: unique constraint (RASYS.RCFILE_U1) violated encountered when executing declare l_tmp number; begin select count(*) into l_tmp from rcfile where name = :name; if l_tmp = 1 then begin select rcfile _key into l_tmp from rcfile where name=:name for update skip locked; delete rcfile where name = :name; inse rt into rcfile (rcfile_key,creation_time,name,xmldoc) values(rman_seq.nextval, sys_extract_utc(systimestamp), :name, sys.xmltype.createxml(:xmldoc)) ; commit; exception when no_data_found then null; end; else insert into rcfile (rcfile_key, c reation_time, name, xmldoc) values(rman_seq.nextval, sys_extract_utc(systimestamp), :name, sys.xmltype.createxml(:xmldoc)); commit; end if; end;." ORA-29269: HTTP server error
The incident is being reported and fixed immediately. The following query can be used to verify the status of the incident and when the incident was first reported and when this was fixed :
Patch or upgrade to 126.96.36.199.2.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!