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.
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 :
SQL> EXECUTE DBMS_LOGSTDBY.APPLY_SET('LOG_AUTO_DEL_RETENTION_TARGET','2800');
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: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
