logical standby archive logs can not be deleted auto
Hi,
I have found that the archive logs can not be deleted auto on logical standby(version 19.10 SunOS 5.11 sparc)
--- There is no gap between primary and logical standby:
SQL> SELECT APPLIED_SEQUENCE#,NEWEST_SEQUENCE# FROM DBA_LOGSTDBY_PROGRESS;
APPLIED_SEQUENCE# NEWEST_SEQUENCE#
----------------- ----------------
1725 1725
SQL> SELECT APPLIED_TIME,MINING_TIME,SYSDATE FROM V$LOGSTDBY_PROGRESS;
APPLIED_TIME MINING_TIME SYSDATE
--------- --------- ---------
05-MAY-21 05-MAY-21 05-MAY-21
--"LOG_AUTO_DELETE" is true:
SQL> select * from dba_logstdby_parameters where name = 'LOG_AUTO_DELETE';
NAME VALUE UNIT SETTING DYNAMIC
------------------------- --------------- --------------- --------------- ---------------
LOG_AUTO_DELETE TRUE SYSTEM YES