Database Administration (MOSC)

MOSC Banner

logical standby archive logs can not be deleted auto

edited May 5, 2021 6:42AM in Database Administration (MOSC) 3 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center