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. |
