Database Error Messages

ORA-05069

Missing post commit logical change record (LCR) for transaction %2!s, leader DBID %3!s with commit log index %4!s for replication unit %1!s.
  • transaction_id: ID of the transaction that was not replicated.
  • leader_db_id: ID of the leader instance expected to send the commit LCR.
  • log_index: LCR log index used for further diagnostics.
  • replication_unit_id: ID of the replication unit that detected the missing commit LCR.

Cause

This error occurs on a follower in a Sharding Raft replication unit when the leader delays propagating the commit LCR. Possible causes for this delay:

  • The leader instance cannot archive online redo logs because the fast recovery area is out of space. The alert log records the suspend event until space is freed, after which the commit resumes.

Action

Check the alert log to identify the cause, then:

  • If the instance was suspended while archiving redo logs, adjust the DB_RECOVERY_FILE_DEST_SIZE parameter using: ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=value SCOPE=BOTH;