If you use Oracle Data Guard, you have to check timeliness status every time. The below query will give to timeliness status. The differences between results have to be 1-2 when you use real time apply Data Guard. Otherwise, your Data Guard is not real time and has a problem. <\/p>\n
Timeliness Status Query<\/strong><\/p>\n \nSQL> SELECT a.resetlogs_id, DECODE (a.thread#, 1, ‘node1’, ‘node2’) HOST, b.last_seq last_occured, You can add to schedule architecture for check.<\/p>\n","protected":false},"excerpt":{"rendered":" If you use Oracle Data Guard, you have to check timeliness status every time. The below query will give to timeliness status. The differences between results have to be 1-2 when you use real time apply Data Guard. Otherwise, your Data Guard is not real time and has a problem. Timeliness Status Query SQL> SELECT…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9,20],"tags":[14,90,32],"class_list":["post-634","post","type-post","status-publish","format-standard","hentry","category-administration","category-oracle-backup-and-recovery","tag-database-administration","tag-oracle","tag-oracle-administration"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-ae","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=634"}],"version-history":[{"count":5,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/634\/revisions"}],"predecessor-version":[{"id":639,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/634\/revisions\/639"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=634"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n a.applied_seq last_applied, TO_CHAR (a.last_applied_time, ‘dd\/mm\/yyyy hh24:mi:ss’) last_applied_time
\n FROM (SELECT resetlogs_id, thread#, MAX (sequence#) applied_seq, MAX (next_time) last_applied_time
\n FROM gv$archived_log
\n WHERE applied = ‘YES’ and resetlogs_id=(select max(resetlogs_id) from gv$archived_log)
\n GROUP BY resetlogs_id, thread# ) a,
\n (SELECT resetlogs_id, thread#, MAX (sequence#) last_seq
\n FROM gv$archived_log where resetlogs_id=(select max(resetlogs_id) from gv$archived_log)
\n GROUP BY resetlogs_id, thread# ) b
\nWHERE a.thread# = b.thread#;\n<\/p><\/blockquote>\n