In the previous article of Automatic deletion of archived redo log, we have seen automatic deletion is enabled by default in the Logical Standby database.

Automatic Deletion of Redo Log Files by SQL Apply

LOG_AUTO_DEL_RETENTION_TARGET parameter is responsible for this. It has default value 1440 minutes. However, we can manage this parameter and set retention for deletion of archive logs as per our requirement.

This parameter is only applicable if ‘LOG_AUTO_DELETE’ of dbms_logstdby.apply_set is set to true.

Oracle Data Guard will keep the remote archived redo log files after apply that to Logical Standby database according to time [minutes] specified in LOG_AUTO_DEL_RETENTION_TARGET  parameter.

To change this parameter’s value :


PL/SQL procedure successfully completed.

Note: This parameter is applicable only when you are not using the fast recovery area.

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.