{"id":14882,"date":"2020-01-30T08:36:47","date_gmt":"2020-01-30T08:36:47","guid":{"rendered":"https:\/\/dbtut.com\/?p=14882"},"modified":"2020-10-07T13:08:17","modified_gmt":"2020-10-07T13:08:17","slug":"how-to-check-data-guard-status","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/","title":{"rendered":"How To Check Data Guard Status"},"content":{"rendered":"

We will check data guard status in SQL Plus in this article in many ways.<\/p>\n

Check 1:<\/h3>\n

Check for LAG from V$DATAGUARD_STATS View.<\/p>\n

[Physical-1] SQL> set linesize 9000\n[Physical-1] SQL> column name format a25\n[Physical-1] SQL> column value format a20\n[Physical-1] SQL> column time_computed format a25\n[Physical-1] SQL> SELECT name, value, time_computed FROM v$dataguard_stats;\n\nNAME                      VALUE                TIME_COMPUTED\n------------------------- -------------------- -------------------------\ntransport lag             +00 00:00:00         01\/16\/2017 14:18:49\napply lag                 +00 00:00:00         01\/16\/2017 14:18:49\napply finish time         +00 00:00:00.000     01\/16\/2017 14:18:49\nestimated startup time    29                   01\/16\/2017 14:18:49\n<\/pre>\n
[Logical-1] SQL> set linesize 9000\n[Logical-1] SQL> column name format a25\n[Logical-1] SQL> column value format a20\n[Logical-1] SQL> column time_computed format a25\n[Logical-1] SQL> SELECT name, value, time_computed FROM v$dataguard_stats;\n\nNAME                      VALUE                TIME_COMPUTED\n------------------------- -------------------- -------------------------\ntransport lag             +00 00:00:00         01\/16\/2017 14:18:24\napply lag                 +00 02:01:50         01\/16\/2017 14:18:24\napply finish time                              01\/16\/2017 14:18:24\nestimated startup time    25                   01\/16\/2017 14:18:24<\/pre>\n\n
Check 2:<\/h3>\n
It is also possible to see whether Redo Logs are sent and applied to Standby correctly or not, by following the Sequence numbers.<\/p>\n
[Primary-1 ]SQL> select max(sequence#),thread# from v$archived_log group by thread#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n         27251          1\n         22326          2\n<\/pre>\n
[Physical-1] SQL> select max(sequence#),thread#, applied from v$archived_log group by thread#, applied;\n\nMAX(SEQUENCE#)    THREAD# APPLIED\n-------------- ---------- ---------\n         27250          1 YES\n         27251          1 IN-MEMORY\n         22326          2 YES<\/pre>\n
Check 3:<\/h3>\n
The query below shows the latest archives on Primary and Standby. It shows the last archive produced in Primary and the last archive applied to Standby.<\/p>\n
SELECT a.resetlogs_id, DECODE (a.thread#, 1, 'node1', 2, 'node2') HOST, b.last_seq prmy_last_file,\n      a.applied_seq stdby_last_file, CASE WHEN b.last_seq - a.applied_seq > 2 THEN '=>' ELSE to_char(b.last_seq - a.applied_seq) END archive_difference, TO_CHAR (a.latest_apply_time, 'dd\/mm\/yyyy hh24:mi:ss') stdby_latest_time\n FROM (SELECT   resetlogs_id, thread#, MAX (sequence#) applied_seq, MAX (next_time) latest_apply_time\n           FROM v$archived_log\n          WHERE applied = 'YES'\n       GROUP BY resetlogs_id, thread#) a,\n      (SELECT   resetlogs_id, thread#, MAX (sequence#) last_seq\n           FROM v$archived_log\n       GROUP BY resetlogs_id, thread#) b\nWHERE a.thread# = b.thread#\nORDER BY a.thread#;<\/pre>\n
Check 4:<\/h3>\n
It can be seen if there is an error in the Alert Log from V$DATAGUARD_STATUS View. An alarm can be created by selecting the “Error” column in the Severity column here.<\/p>\n
[Physical-2] SQL> column message format a66\n[Physical-2] SQL> SELECT timestamp, facility, message FROM v$dataguard_status ORDER by timestamp;\n\nTIMESTAMP FACILITY                 MESSAGE\n--------- ------------------------ ------------------------------------------------------------------\n15-JAN-17 Log Apply Services       Managed Standby Recovery not using Real Time Apply\n16-JAN-17 Remote File Server       RFS[50]: Assigned to RFS process 28009\n16-JAN-17 Remote File Server       Primary database is in MAXIMUM PERFORMANCE mode\n16-JAN-17 Log Transport Services   ARC5: Completed archiving thread 1 sequence 575 (0-0)\n16-JAN-17 Log Transport Services   ARC6: Beginning to archive thread 2 sequence 339 (6091863-6091873)\n16-JAN-17 Log Transport Services   ARC6: Completed archiving thread 2 sequence 339 (0-0)\n<\/pre>\n
Check 5:<\/h3>\n
The status of Redo Apply and Redo Transport services can be seen from V$MANAGED_STANDBY View.<\/p>\n
[Primary-1] SQL> column group# format a10\n[Primary-1] SQL> SELECT process, status, group#, thread#, sequence# FROM v$managed_standby order by process, group#, thread#, sequence#;\n\nPROCESS   STATUS       GROUP#        THREAD#  SEQUENCE#\n--------- ------------ ---------- ---------- ----------\nARCH      CLOSING      1                   1        561\nARCH      CLOSING      1                   1        565\nARCH      CLOSING      1                   1        569\nARCH      CLOSING      1                   1        573\nARCH      CLOSING      1                   1        575\nARCH      CLOSING      N\/A                 1        538\nARCH      CLOSING      N\/A                 1        561\nARCH      CLOSING      N\/A                 1        569\nLGWR      CLOSING      2                   1        568\nLNS       WRITING      2                   1        576\nLNS       WRITING      2                   1        576\n\n11 rows selected.<\/pre>\n
[Physical-1] SQL> column group# format a10\n[Physical-1] SQL> SELECT process, status, group#, thread#, sequence# FROM v$managed_standby order by process, group#, thread#, sequence#;\n\nPROCESS   STATUS       GROUP#        THREAD#  SEQUENCE#\n--------- ------------ ---------- ---------- ----------\nARCH      CLOSING      5                   1        571\nARCH      CONNECTED    N\/A                 0          0\nARCH      CONNECTED    N\/A                 0          0\nARCH      CONNECTED    N\/A                 0          0\nARCH      CONNECTED    N\/A                 0          0\nARCH      CONNECTED    N\/A                 0          0\nARCH      CONNECTED    N\/A                 0          0\nARCH      CONNECTED    N\/A                 0          0\nMRP0      APPLYING_LOG N\/A                 2        340\nRFS       IDLE         N\/A                 0          0\nRFS       IDLE         N\/A                 0          0\n\n11 rows selected.\n<\/pre>\n
[Logical-1] SQL> column group# format a10\n[Logical-1] SQL> SELECT process, status, group#, thread#, sequence# FROM v$managed_standby order by process, group#, thread#, sequence#;\n\nPROCESS   STATUS       GROUP#        THREAD#  SEQUENCE#\n--------- ------------ ---------- ---------- ----------\nARCH      CLOSING      1                   1         95\nARCH      CLOSING      5                   1        574\nARCH      CLOSING      6                   1        573\nARCH      CLOSING      8                   2        332\nARCH      CLOSING      8                   2        334\nARCH      CLOSING      9                   2        333\nARCH      CLOSING      9                   2        335\nARCH      CONNECTED    N\/A                 0          0\nRFS       IDLE         N\/A                 0          0\nRFS       IDLE         N\/A                 0          0\nRFS       IDLE         N\/A                 0          0\n\nPROCESS   STATUS       GROUP#        THREAD#  SEQUENCE#\n--------- ------------ ---------- ---------- ----------\nRFS       IDLE         N\/A                 0          0\nRFS       IDLE         N\/A                 0          0\nRFS       IDLE         N\/A                 0          0\nRFS       IDLE         N\/A                 0          0\nRFS       IDLE         N\/A                 0          0\n\n16 rows selected.\n<\/pre>\n
NOTE:<\/strong> If you notice, there is no LSP process that performs Redo-Apply job in Logical Standby Databases as a result of the query. The reason is that v$managed_standby view is valid for Physical Standby Database.<\/p>\n
Check 6:<\/h3>\n
The information of the transactions currently processed by SQL APPLY can be seen from the V$LOGSTDBY_TRANSACTION View.<\/p>\n
[Logical-1] SQL> SELECT primary_xid, type,mining_status, apply_status FROM v$logstdby_transaction;\n\nno rows selected\n<\/pre>\n\n
Check 7:<\/h3>\n
It can be seen which archives are transmitted to the standby when.<\/p>\n
\t[Physical-1] SQL>select THREAD#,sequence#, round((blocks*block_size)\/1024\/1024), first_time, next_time, completion_time from gv$archived_log where REGISTRAR='RFS' order by 6;\n\t\n\t.\n\t.\n\t.\n\t   THREAD#  SEQUENCE# ROUND((BLOCKS*BLOCK_SIZE)\/1024\/1024) FIRST_TIM NEXT_TIME COMPLETIO\n\t---------- ---------- ------------------------------------ --------- --------- ---------\n\t         1      79450                                  656 15-JAN-19 15-JAN-19 15-JAN-19\n\t         2      96900                                  665 15-JAN-19 15-JAN-19 15-JAN-19\n\t         2      96900                                  665 15-JAN-19 15-JAN-19 15-JAN-19\n\t         1      79451                                  655 15-JAN-19 15-JAN-19 15-JAN-19\n\t         1      79451                                  655 15-JAN-19 15-JAN-19 15-JAN-19\n\t         2      96901                                  667 15-JAN-19 15-JAN-19 15-JAN-19\n\t         2      96901                                  667 15-JAN-19 15-JAN-19 15-JAN-19\n\t\n1866 rows selected.<\/pre>\n
Check 8:<\/h3>\n
You can get information about Standby Redo Logs from V$STANDBY_LOG View by using the following queries.<\/p>\n
[Primary-1] SQL> set linesize 9000\n[Primary-1] SQL> column dbid format a15\n[Primary-1] SQL> SELECT group#, thread#, sequence#, dbid, archived, status FROM v$standby_log;\n\n    GROUP#    THREAD#  SEQUENCE# DBID            ARC STATUS\n---------- ---------- ---------- --------------- --- ----------\n         5          1          0 UNASSIGNED      YES UNASSIGNED\n         6          1          0 UNASSIGNED      YES UNASSIGNED\n         7          1          0 UNASSIGNED      YES UNASSIGNED\n         8          2          0 UNASSIGNED      YES UNASSIGNED\n         9          2          0 UNASSIGNED      YES UNASSIGNED\n        10          2          0 UNASSIGNED      YES UNASSIGNED\n\n6 rows selected.\n<\/pre>\n
[Physical-1] SQL> set linesize 9000\n[Physical-1] SQL> column dbid format a15\n[Physical-1] SQL> SELECT group#, thread#, sequence#, dbid, archived, status FROM v$standby_log;\n\n    GROUP#    THREAD#  SEQUENCE# DBID            ARC STATUS\n---------- ---------- ---------- --------------- --- ----------\n         5          1          0 UNASSIGNED      NO  UNASSIGNED\n         6          1        576 1769705496      YES ACTIVE\n         7          1          0 UNASSIGNED      NO  UNASSIGNED\n         8          2        340 1769705496      YES ACTIVE\n         9          2          0 UNASSIGNED      NO  UNASSIGNED\n        10          2          0 UNASSIGNED      YES UNASSIGNED\n\n6 rows selected.\n<\/pre>\n
[Logical-1] SQL> set linesize 9000\n[Logical-1] SQL> column dbid format a15\n[Logical-1] SQL> SELECT group#, thread#, sequence#, dbid, archived, status FROM v$standby_log;\n\n    GROUP#    THREAD#  SEQUENCE# DBID            ARC STATUS\n---------- ---------- ---------- --------------- --- ----------\n         5          1        576 1769705496      YES ACTIVE\n         6          1          0 UNASSIGNED      NO  UNASSIGNED\n         7          1          0 UNASSIGNED      NO  UNASSIGNED\n         8          2        340 1769705496      YES ACTIVE\n         9          2          0 UNASSIGNED      NO  UNASSIGNED\n        10          2          0 UNASSIGNED      NO  UNASSIGNED\n<\/pre>\n
The combinations of the ARCHIVED and STATUS columns in the above query mean the following;<\/p>\n
ARC\u00a0\u00a0\u00a0 STATUS<\/strong><\/p>\n\n\n\n\n\n\n
NO\u00a0\u00a0\u00a0\u00a0\u00a0 UNASSIGNED<\/td>\nStandby Redo Log has been archived and is suitable for reuse.<\/td>\n<\/tr>\n
YES\u00a0\u00a0\u00a0\u00a0 UNASSIGNED<\/td>\nStandby Redo Log has never been used and is ready for use.<\/td>\n<\/tr>\n
NO\u00a0\u00a0\u00a0\u00a0 ACTIVE<\/td>\nShows that writing to Standby Redo Log is finished and Standby Redo Log is expected to be archived.<\/td>\n<\/tr>\n
YES\u00a0\u00a0\u00a0 ACTIVE<\/td>\nShows that Standby Redo Log is actively used and is not yet archived.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Check 9:<\/h3>\n
In cases where Standby Database does not receive Redos, we should check V$ARCHIVE_DEST.<\/p>\n
Query ARCHIVE DESTINATION.<\/p>\n
[Primary-1] SQL> SELECT dest_id,valid_type,valid_role,valid_now FROM v$archive_dest;\n\n   DEST_ID VALID_TYPE      VALID_ROLE   VALID_NOW\n---------- --------------- ------------ ----------------\n         1 ALL_LOGFILES    ALL_ROLES    YES\n         2 ALL_LOGFILES    PRIMARY_ROLE YES\n         3 ALL_LOGFILES    PRIMARY_ROLE YES\n         4 ALL_LOGFILES    ALL_ROLES    UNKNOWN<\/pre>\n
[Physical-1] SQL> SELECT dest_id,valid_type,valid_role,valid_now FROM v$archive_dest;\n\n   DEST_ID VALID_TYPE      VALID_ROLE   VALID_NOW\n---------- --------------- ------------ ----------------\n         1 ALL_LOGFILES    ALL_ROLES    YES\n         2 ALL_LOGFILES    ALL_ROLES    UNKNOWN<\/pre>\n
[Logical-1] SQL> SELECT dest_id,valid_type,valid_role,valid_now FROM v$archive_dest;\n\n   DEST_ID VALID_TYPE      VALID_ROLE   VALID_NOW\n---------- --------------- ------------ ----------------\n         1 ALL_LOGFILES    ALL_ROLES    YES\n         2 ALL_LOGFILES    ALL_ROLES    UNKNOWN\n<\/pre>\n
Values and meanings of the VALID_NOW column in this View are as follows;<\/p>\n
\n\n\n\n\n\n\n
YES<\/td>\nThis value shows that the Archive log destination has been defined and is valid for the current database role. Usually LOG_ARCHIVE_DEST_1 is defined this way.<\/td>\n<\/tr>\n
WRONG VALID_TYPE<\/td>\nThis value shows that the Archive log destination has been defined, but there are no Standby Logs to use when in Standby Role.<\/td>\n<\/tr>\n
WRONG VALID_ROLE<\/td>\nThis value shows that the Archive log destination is incorrectly defined. Online Logs cannot be read while in Standby Role.<\/td>\n<\/tr>\n
UNKNOWN<\/td>\nThis value shows that the Archive Log destination is not defined.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Check 10:<\/h3>\n
If there are no problems in the destinations, errors are checked.<\/p>\n
\t\t[Primary-1] SQL> column destination format a30\n\t\t[Primary-1] SQL> column error format a20\n\t\t[Primary-1] SQL> set linesize 9000\n\t\t[Primary-1] SQL> SELECT DEST_ID, STATUS, DESTINATION, ERROR FROM V$ARCHIVE_DEST WHERE DEST_ID <=5;\n\t\t\n\t\t   DEST_ID STATUS    DESTINATION                    ERROR\n\t\t---------- --------- ------------------------------ --------------------\n\t\t         1 VALID     USE_DB_RECOVERY_FILE_DEST\n\t\t         2 VALID     standby\n\t\t         3 VALID     logical\n\t\t         4 INACTIVE\n\t\t         5 INACTIVE\n<\/pre>\n
Check 11:<\/h3>\n
If there is no error, the following are checked.<\/p>\n
    \n
  • TNSNAMES.ORA file,<\/li>\n
  • LOG_ARCHIVE_DEST_n parameters,<\/li>\n
  • LOG_ARCHIVE_DEST_STATE_n parameters,<\/li>\n
  • LISTENER.ORA file,<\/li>\n
  • Whether Listener runs on Standby,<\/li>\n
  • Whether instances are running is checked on standby.<\/li>\n<\/ul>\n\n
    Queries to Check Standby<\/h3>\n
    SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;\n\nSEQUENCE# APPLIED\n---------- ---------\n     10033 YES\n     10034 YES\n     10035 YES\n     10036 YES\n     10037 YES\n     10038 YES\n\n\t \nSQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;\n\nMESSAGE\n--------------------------------------------------------------------------------\nARCj: Beginning to archive thread 1 sequence 10037 (12423487630539-1242348971229\n8)\n\nARCj: Completed archiving thread 1 sequence 10037 (0-0)\nMedia Recovery Log +FRA\/mwstdbydb\/archivelog\/2015_12_29\/thread_1_seq_10037.862.8\n99733563\n\nMedia Recovery Waiting for thread 2 sequence 7938 (in transit)\nARC0: Beginning to archive thread 2 sequence 7938 (12423487903683-12423490247632\n)\n\n\nMESSAGE\n--------------------------------------------------------------------------------\nARC0: Completed archiving thread 2 sequence 7938 (0-0)\nMedia Recovery Log +FRA\/mwstdbydb\/archivelog\/2015_12_29\/thread_2_seq_7938.863.89\n9734925\n\nMedia Recovery Waiting for thread 1 sequence 10038 (in transit)\nARC1: Beginning to archive thread 1 sequence 10038 (12423489712298-1242349181804\n2)\n\nARC1: Completed archiving thread 1 sequence 10038 (0-0)\nMedia Recovery Log +FRA\/mwstdbydb\/archivelog\/2015_12_29\/thread_1_seq_10038.864.8\n99738951\n\nMESSAGE\n--------------------------------------------------------------------------------\n\nMedia Recovery Waiting for thread 2 sequence 7939 (in transit)\nARC3: Beginning to archive thread 2 sequence 7939 (12423490247632-12423492561200\n)\n\nARC3: Completed archiving thread 2 sequence 7939 (0-0)\nMedia Recovery Log +FRA\/mwstdbydb\/archivelog\/2015_12_29\/thread_2_seq_7939.865.89\n9740831\n\nMedia Recovery Waiting for thread 1 sequence 10039 (in transit)\n \nSQL> select to_char(current_scn) from v$database;       \n\nTO_CHAR(CURRENT_SCN)\n----------------------------------------\n12423492561199\n \nSQL> select scn_to_timestamp(1681797) from dual;  PROD\n\nSCN_TO_TIMESTAMP(12423492561199)\n---------------------------------------------------------------------------\n29-DEC-15 04.00.31.000000000 PM\n \nSQL> select thread#, sequence#, status from v$log;  PROD\n\nSCN_TO_TIMESTAMP(12423492561199)\n---------------------------------------------------------------------------\n29-DEC-15 04.00.31.000000000 PM\n\nSQL> select thread#, sequence#, status from v$log;\n\n   THREAD#  SEQUENCE# STATUS\n---------- ---------- ----------------\n         1      10038 INACTIVE\n         1      10039 INACTIVE\n         1      10040 CURRENT\n         1      10036 INACTIVE\n         1      10037 INACTIVE\n         2       7938 INACTIVE\n         2       7939 INACTIVE\n         2       7940 CURRENT\n         2       7936 INACTIVE\n         2       7937 INACTIVE\n\t\t \nSQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby;\n\nPROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS\n--------- ------------ ---------- ---------- ---------- ----------\nARCH      CLOSING               2       7938    1613824        582\nARCH      CLOSING               1      10038    1613824        648\nARCH      CONNECTED             0          0          0          0\nARCH      CLOSING               2       7939    1613824        510\nARCH      CLOSING               1      10039    1613824        171\nARCH      CLOSING               1      10030    1613824       1800\nARCH      CLOSING               2       7931    1613824        796\nARCH      CLOSING               2       7932      71680       1080\nARCH      CLOSING               1      10031     829440       1043\nARCH      CLOSING               2       7933    1613824        271\nARCH      CLOSING               1      10032    1613824         38\n\nPROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS\n--------- ------------ ---------- ---------- ---------- ----------\nARCH      CLOSING               2       7934    1695744        239\nARCH      CLOSING               1      10033    1613824         11\nARCH      CLOSING               2       7935    1613824        191\nARCH      CLOSING               1      10034    1613824        332\nARCH      CLOSING               1      10035    1318912        497\nARCH      CLOSING               2       7936    1230848        236\nARCH      CLOSING               1      10036    1611776       1964\nARCH      CLOSING               2       7937    1613824         70\nARCH      CLOSING               1      10037    1613824         90\nRFS       IDLE                  0          0          0          0\nRFS       IDLE                  0          0          0          0\n\nPROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS\n--------- ------------ ---------- ---------- ---------- ----------\nRFS       IDLE                  1      10040     181017          1\nRFS       IDLE                  2       7940    1204818          2\nRFS       IDLE                  0          0          0          0\nRFS       IDLE                  0          0          0          0\nMRP0      WAIT_FOR_LOG          2       7940          0          0\n \nSQL>  select * from V$dataguard_Stats; \n\nNAME                             VALUE                                                            UNIT                           TIME_COMPUTED                  DATUM_TIME\n-------------------------------- ---------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------\ntransport lag                    +00 00:00:00                                                     day(2) to second(0) interval   12\/29\/2015 17:02:32            12\/29\/2015 17:02:31\napply lag                        +00 01:02:00                                                     day(2) to second(0) interval   12\/29\/2015 17:02:32            12\/29\/2015 17:02:31\napply finish time                +00 00:00:04.884                                                 day(2) to second(3) interval   12\/29\/2015 17:02:32\nestimated startup time           45                                                               second                         12\/29\/2015 17:02:32\n\n \nSQL> SELECT FIRST_TIME, TO_CHAR(FIRST_CHANGE#), TO_CHAR(NEXT_CHANGE#), SEQUENCE# FROM V$LOG_HISTORY;\n\nFIRST_TIM TO_CHAR(FIRST_CHANGE#)                   TO_CHAR(NEXT_CHANGE#)                     SEQUENCE#\n--------- ---------------------------------------- ---------------------------------------- ----------\n29-DEC-15 12423479700143                           12423481704223                                10033\n29-DEC-15 12423481518592                           12423483684832                                 7935\n29-DEC-15 12423481704223                           12423483761666                                10034\n29-DEC-15 12423483761666                           12423485543281                                10035\n29-DEC-15 12423483684832                           12423485543694                                 7936\n29-DEC-15 12423485543281                           12423487630539                                10036\n29-DEC-15 12423485543694                           12423487903683                                 7937\n29-DEC-15 12423487630539                           12423489712298                                10037\n29-DEC-15 12423487903683                           12423490247632                                 7938\n29-DEC-15 12423489712298                           12423491818042                                10038\n29-DEC-15 12423490247632                           12423492561200                                 7939<\/pre>\n
    <\/div>\n
    <\/path><\/svg><\/i> \"Loading\"<\/p>\n
    <\/div>\n","protected":false},"excerpt":{"rendered":"
    We will check data guard status in SQL Plus in this article in many ways. Check 1: Check for LAG from V$DATAGUARD_STATS View. [Physical-1] SQL> set linesize 9000 [Physical-1] SQL> column name format a25 [Physical-1] SQL> column value format a20 [Physical-1] SQL> column time_computed format a25 [Physical-1] SQL> SELECT name, value, time_computed FROM v$dataguard_stats; NAME …<\/p>\n
    <\/div>\n
    <\/path><\/svg><\/i> \"Loading\"<\/p>\n
    <\/div>\n","protected":false},"author":484,"featured_media":14888,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[8163,8128,8138,8134,8148,8155,8153,8152,8154,8145,8156,8150,8135,8136,8147,8146,8162,8131,8151,8164,8140,8141,8129,8139,8130,8133,8137,8149,8142,8160,8143,8144,8161,8169,8168,8171,8173,8172,8170,8158,8159,8100,8167,8166,8132,8165,8157],"class_list":["post-14882","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-archive-gap-between-primary-and-standby","tag-check-dataguard-status","tag-check-dataguard-status-11g","tag-check-dataguard-status-from-primary","tag-check-primary-and-standby-databases-are-in-sync-dataguard","tag-data-guard-status","tag-data-guard-status-query","tag-data-guard-status-script","tag-data-guard-status-sql","tag-data-guard-sync-status-query","tag-find-data-guard-status","tag-how-to-check-data-guard-is-in-sync","tag-how-to-check-dataguard-status","tag-how-to-check-dataguard-sync-status","tag-how-to-check-if-standby-database-is-in-sync","tag-how-to-check-whether-physical-standby-is-in-sync","tag-how-to-find-log-gap-between-primary-and-standby","tag-how-to-query-data-guard-status","tag-how-to-query-dataguard-status","tag-monitor-archive-gap-on-dataguard","tag-oracle-11g-data-guard-check-status","tag-oracle-12c-data-guard-check-status","tag-oracle-check-data-guard-status","tag-oracle-data-guard-check-apply-status","tag-oracle-query-data-guard-status","tag-oracle-script-to-check-data-guard-status","tag-oracle-show-data-guard-status","tag-queries-to-check-data-guard-is-in-sync","tag-query-data-guard-status","tag-query-to-check-archive-log-gap-in-standby-database","tag-query-to-check-data-guard-status","tag-query-to-check-data-guard-sync-status","tag-query-to-check-gap-between-primary-and-standby","tag-query-to-check-if-standby-is-in-sync","tag-query-to-check-logical-standby-sync","tag-query-to-check-oracle-standby-status","tag-query-to-check-oracle-standby-sync","tag-query-to-check-physical-standby-status","tag-query-to-check-primary-and-standby-database","tag-query-to-check-standby","tag-query-to-check-standby-gap","tag-query-to-check-standby-redo-log-files","tag-query-to-check-standby-sync-status","tag-query-to-check-standy","tag-script-to-check-data-guard-status","tag-script-to-monitor-primary-and-standby-database","tag-show-data-guard-status"],"aioseo_notices":[],"yoast_head":"\nHow To Check Data Guard Status - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Check Data Guard Status\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Check Data Guard Status - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Check Data Guard Status\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-30T08:36:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-07T13:08:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-24.png\" \/>\n\t<meta property=\"og:image:width\" content=\"554\" \/>\n\t<meta property=\"og:image:height\" content=\"289\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"How To Check Data Guard Status\",\"datePublished\":\"2020-01-30T08:36:47+00:00\",\"dateModified\":\"2020-10-07T13:08:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/\"},\"wordCount\":488,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-24.png\",\"keywords\":[\"archive gap between PRIMARY and STANDBY\",\"check dataguard status\",\"check dataguard status 11g\",\"check dataguard status from primary\",\"Check primary and standby databases are in sync Dataguard\",\"data guard status\",\"data guard status query\",\"data guard status script\",\"data guard status sql\",\"data guard sync status query\",\"find data guard status\",\"how to check data guard is in sync\",\"how to check dataguard status\",\"how to check dataguard sync status\",\"How to check if standby database is in sync\",\"How to Check Whether Physical Standby is in Sync\",\"How to find log gap between primary and standby\",\"how to query data guard status\",\"How To Query Dataguard Status\",\"Monitor Archive Gap on DataGuard\",\"oracle 11g data guard check status\",\"oracle 12c data guard check status\",\"oracle check data guard status\",\"oracle data guard check apply status\",\"oracle query data guard status\",\"oracle script to check data guard status\",\"oracle show data guard status\",\"Queries to check data guard is in sync\",\"query data guard status\",\"query to check archive log gap in standby database\",\"query to check data guard status\",\"query to check data guard sync status\",\"query to check gap between primary and standby\",\"query to check if standby is in sync\",\"query to check logical standby sync\",\"query to check oracle standby status\",\"query to check oracle standby sync\",\"query to check physical standby status\",\"query to check primary and standby database\",\"query to check standby\",\"query to check standby gap\",\"query to check standby redo log files\",\"query to check standby sync status\",\"query to check standy\",\"script to check data guard status\",\"Script to Monitor Primary and Standby database\",\"show data guard status\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/\",\"name\":\"How To Check Data Guard Status - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-24.png\",\"datePublished\":\"2020-01-30T08:36:47+00:00\",\"dateModified\":\"2020-10-07T13:08:17+00:00\",\"description\":\"How To Check Data Guard Status\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-24.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-24.png\",\"width\":554,\"height\":289},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Check Data Guard Status\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Check Data Guard Status - Database Tutorials","description":"How To Check Data Guard Status","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/","og_locale":"en_US","og_type":"article","og_title":"How To Check Data Guard Status - Database Tutorials","og_description":"How To Check Data Guard Status","og_url":"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/","og_site_name":"Database Tutorials","article_published_time":"2020-01-30T08:36:47+00:00","article_modified_time":"2020-10-07T13:08:17+00:00","og_image":[{"width":554,"height":289,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-24.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"How To Check Data Guard Status","datePublished":"2020-01-30T08:36:47+00:00","dateModified":"2020-10-07T13:08:17+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/"},"wordCount":488,"commentCount":6,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-24.png","keywords":["archive gap between PRIMARY and STANDBY","check dataguard status","check dataguard status 11g","check dataguard status from primary","Check primary and standby databases are in sync Dataguard","data guard status","data guard status query","data guard status script","data guard status sql","data guard sync status query","find data guard status","how to check data guard is in sync","how to check dataguard status","how to check dataguard sync status","How to check if standby database is in sync","How to Check Whether Physical Standby is in Sync","How to find log gap between primary and standby","how to query data guard status","How To Query Dataguard Status","Monitor Archive Gap on DataGuard","oracle 11g data guard check status","oracle 12c data guard check status","oracle check data guard status","oracle data guard check apply status","oracle query data guard status","oracle script to check data guard status","oracle show data guard status","Queries to check data guard is in sync","query data guard status","query to check archive log gap in standby database","query to check data guard status","query to check data guard sync status","query to check gap between primary and standby","query to check if standby is in sync","query to check logical standby sync","query to check oracle standby status","query to check oracle standby sync","query to check physical standby status","query to check primary and standby database","query to check standby","query to check standby gap","query to check standby redo log files","query to check standby sync status","query to check standy","script to check data guard status","Script to Monitor Primary and Standby database","show data guard status"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/","url":"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/","name":"How To Check Data Guard Status - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-24.png","datePublished":"2020-01-30T08:36:47+00:00","dateModified":"2020-10-07T13:08:17+00:00","description":"How To Check Data Guard Status","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-24.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-24.png","width":554,"height":289},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/30\/how-to-check-data-guard-status\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Check Data Guard Status"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14882","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14882"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14882\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14888"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14882"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14882"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}