Archive logs getting applied on standby & not getting updated on Primary- No Lag
I am facing a situation that I see no documentation about.
Archive logs are getting applied on remote physical standby but are not getting updated on primary Database.
I have attempted to reset the process with the following commands but not seeing much improvement.
alter system set log_archive_dest_state_2 =’defer’;
alter system set log_archive_dest_state_2 =’enable’;
I am still looking into this however I was just wondering if you have any suggestion/solution
SQL> select * from v$archive_gap;
no rows selected
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.