The archived log deletion policy on the standby database

The continuously transferred redo transaction is archived at the standby database before or after being applied, depending on the configuration. At the end, we're faced with lots of files filling the log destination either on the filesystem or ASM disk group. We need to build an automatic structure on the standby site, where applied archived logs are deleted automatically based on a specific logic.

There are several methods for archived log deletion. It's possible to delete archived logs with the rm command of the operation system or ASM. However, if we use rm, the control file will not be updated about the deletion of archived logfiles. Thus, in order to update the control file with the ...

Get Oracle Data Guard 11gR2 Administration Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.