Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
This article contains scripts about checking Standby redo logs. You can use the below queries to check standby redo logs in Oracle.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | SQL> SELECT group#, type, member FROM v$logfile WHERE type = 'STANDBY' order by group#; GROUP# TYPE MEMBER ---------- ------- -------------------------------------------------- 5 STANDBY +DATA/standby/onlinelog/group_5.267.932283683 5 STANDBY +FRA/standby/onlinelog/group_5.260.932283683 6 STANDBY +DATA/standby/onlinelog/group_6.268.932283683 6 STANDBY +FRA/standby/onlinelog/group_6.261.932283683 7 STANDBY +FRA/standby/onlinelog/group_7.262.932283683 7 STANDBY +DATA/standby/onlinelog/group_7.269.932283683 8 STANDBY +DATA/standby/onlinelog/group_8.270.932283685 8 STANDBY +FRA/standby/onlinelog/group_8.263.932283685 9 STANDBY +FRA/standby/onlinelog/group_9.264.932283685 9 STANDBY +DATA/standby/onlinelog/group_9.271.932283685 10 STANDBY +FRA/standby/onlinelog/group_10.265.932283685 GROUP# TYPE MEMBER ---------- ------- -------------------------------------------------- 10 STANDBY +DATA/standby/onlinelog/group_10.272.932283685 12 rows selected. |
or
1 2 3 4 5 6 7 8 9 10 11 12 13 | SQL> column DBID format a20 SQL> SELECT group#, dbid, thread#, sequence#, status FROM v$standby_log; GROUP# DBID THREAD# SEQUENCE# STATUS ---------- -------------------- ---------- ---------- ---------- 5 UNASSIGNED 1 0 UNASSIGNED 6 1769705496 1 66 ACTIVE 7 UNASSIGNED 1 0 UNASSIGNED 8 UNASSIGNED 2 0 UNASSIGNED 9 1769705496 2 33 ACTIVE 10 UNASSIGNED 2 0 UNASSIGNED 6 rows selected. |
