v$archive_dest_status SRL=NO, however RECOVERY_MODE="MANAGED REAL TIME APPLY"
Hi
Oracle 19.3, 2-node RAC, same thing with 12.1
Oracle Linux 7.6
I have standby redo logs present on both nodes (SRL count=ORL_count_on_both_threads +1).
Primary: tallinn
Standby: kuressaare
-- On primaryNAME TYPE VALUE---------------------------------------- --------------- ------------------------------------------------------------------------------------------------------------------------log_archive_dest_2 string SERVICE=kuressaare ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=kuressaare-- On StandbyNAME TYPE VALUE---------------------------------------- --------------- ------------------------------------------------------------------------------------------------------------------------log_archive_dest_2 string SERVICE=tallinn ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=tallinn-- Online redo and standby redo logs GROUP# STAT TYPE MEMBER IS_ THREAD# SEQUENCE# MB BLOCKSIZE MEMBERS USED_MB GRP# ARC STATUS---------- ------- --------------- ------------------------------------------------------- --- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --- ------------ 1 ONLINE +DATA/KURESSAARE/ONLINELOG/group_1.266.1015854147 NO 1 50 200 512 1 1 YES INACTIVE 3 ONLINE +DATA/KURESSAARE/ONLINELOG/group_3.267.1015854309 NO 1 51 200 512 1 3 YES CURRENT 5 ONLINE +DATA/KURESSAARE/ONLINELOG/group_5.276.1015854235 NO 1 0 200 512 1 5 YES UNUSED 2 ONLINE +DATA/KURESSAARE/ONLINELOG/group_2.275.1015854243 NO 2 50
1