Question for Real Time apply
select SEQUENCE#, STATUS, BYTES, USED from v$standby_log order by 1;
SEQUENCE# STATUS BYTES USED
---------- ---------- ---------- ----------
0 UNASSIGNED 105906176 0
0 UNASSIGNED 104857600 0
0 UNASSIGNED 104857600 0
9265 ACTIVE 105906176 1216512
select CURRENT_SCN from v$database
CURRENT_SCN
---------------
10209405856785
Source
SQL> select DEST_NAME, STATUS,RECOVERY_MODE from v$archive_dest_status
DEST_NAME STATUS RECOVERY_MODE
------------------------------ --------- -----------------------
LOG_ARCHIVE_DEST_1 VALID IDLE
LOG_ARCHIVE_DEST_2 VALID MANAGED REAL TIME APPLY
LOG_ARCHIVE_DEST_3 INACTIVE IDLE