Flashback Archive "FLASHBACK_ARCH" is Blocking and Tracking on all Tables is Suspended
(Doc ID 2679163.1)
Last updated on APRIL 14, 2021
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and laterInformation in this document applies to any platform.
Symptoms
Flashback Archive has resulted in the below failure:
Inbound message failures - ORA-55617: Flashback Archive "FLASHBACK_ARCH" runs out of space and tracking on "" is suspended returned by program unit CUSTOMER_RESERVE_SQL.PROCESS_CO_RESERVE.
Sales process - ORA-55623: Flashback Archive "FLASHBACK_ARCH" is blocking and tracking on all tables is suspended@2NEW_ITEM_LOC_SQL.PERSIST
Golden Gate - Reference related to table ITEM_LOC_SOH flash back archived in extract file.
Sales process - ORA-55623: Flashback Archive "FLASHBACK_ARCH" is blocking and tracking on all tables is suspended@2NEW_ITEM_LOC_SQL.PERSIST
Golden Gate - Reference related to table ITEM_LOC_SOH flash back archived in extract file.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |