[Oracle] Why Archivelog was not removed immediately
The customer has set up the Archivelog deletion policy is CONFIGURE Archivelog deletion policy to applied on all STANDBY;
So, he thinks that as long as the standby side commits, it should be automatically deleted this Archivelog.
However, the customer still found the FRA full, so questioned.
After investigation, I think,
Deletion does not happen immediately, but only when the system is needed.
Applied, just make sure this archivelog becomes a candidate for deletion (reclaimable)
Argument:
======================================================================
Oracle Database does not
Delete eligible files from the Flash recovery area
Until the space must is reclaimed for some other purpose. 1
......
Oracle Database automatically deletes eligible files to reclaim space on the recovery area as needed. 2
...
-archived redo logs is not eligible for deletion
Until all the consumers of the logs has satisfied their requirements (If archived Redo Log deletion Policy is set). 4
Argument:
======================================================================
Above the ***4 said:
After applied, they just become eligible.
Above the ***1 and ***2 said:
The FRA will be removed when it is needed.
Conclusion:
======================================================================
Applied, it is not immediately deleted. When necessary, it is automatically deleted by the system.
[Oracle] Why Archivelog was not removed immediately