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 deletion operation, we must run crosscheck
and delete expired RMAN
commands as follows:
RMAN> crosscheck archivelog all; RMAN> delete expired archivelog all;
Another option is scheduling an RMAN
job that deletes applied archived logs on the standby...