Several methods are available to determine which archive logs are safe to be deleted. When Connect CDC is installed, two views are created to help determine which logs have been processed:
-
The <rpuser>_v_processed_logs view, where <rpuser> is the metabase name, joins v$archived_log with internal Connect CDC tables to determine which logs have been processed and are no longer required for replication. The <rpuser>_v_processed_logs view lists all archive logs for the first active destination id.
-
If multiple archive destinations are used, the <rpuser>_v_all_processed_logs view lists information for all archive logs for all active destinations.
The rows returned from these views are in ascending order by log sequence number. The views are derived from v$archived_log. Therefore, all of the columns from v$archived_log are available to be queried from the Connect CDC views.