Edit (07,2013) A newer version of this topic is here:
-----------------------------------------------------------------------------
Issue the following query to show information about the protection mode, the protection level, the role of the database, and switchover status:
On the standby database, query the V$ARCHIVED_LOG view to identify existing files in the archived redo log.
Or
SELECT THREAD#, MAX(SEQUENCE#) AS "LAST_APPLIED_LOG" FROM V$LOG_HISTORY GROUP BY THREAD#;
On the standby database, query the V$ARCHIVED_LOG view to verify the archived redo log files were applied.
SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
Query the physical standby database to monitor Redo Apply and redo transport services activity at the standby site.
SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;
To determine if real-time apply is enabled, query the RECOVERY_MODE column of the V$ARCHIVE_DEST_STATUS view.
The V$DATAGUARD_STATUS fixed view displays events that would typically be triggered by any message to the alert log or server process trace files.
Determining Which Log Files Were Not Received by the Standby Site.
SELECT LOCAL.THREAD#, LOCAL.SEQUENCE# FROM (SELECT THREAD#, SEQUENCE# FROM V$ARCHIVED_LOG WHERE DEST_ID=1) LOCAL WHERE LOCAL.SEQUENCE# NOT IN (SELECT SEQUENCE# FROM V$ARCHIVED_LOG WHERE DEST_ID=2 AND THREAD# = LOCAL.THREAD#);
If a delayed apply has been specified or an archive log is missing then switchover may take longer than expected.Check v$managed_standby
select process, status, sequence# from v$managed_standby;
OR alternatively:
select name, applied from v$archived_log;
------------------------------------------------------------------
Here is a useful document about the views related with dataguard:
Thanks Emre. It is good to recall all the data guard views, particularly the link you provided for views is very useful.
-Vimal
It is good to copy link info for backup purposes. It is no longer valid. Anyway thank you for the good info.
Pooh
Hi Emre,
On my environment the query "Which Log Files Were Not Received by the Standby Site" shows multiple records. But actually the select * from v$archive_gap; does not returned record. Also there are no lags reported by select name, value from v$dataguard_stats;
Do you know why is this?
BR,
Pooh
Awesome post……. your article is really informative and helpful for me and other bloggers too
Oracle Fusion SCM Online Training
Hey Really Thanks for sharing the best information regarding category, hope you will write more great blogs.
Oracle Fusion Financials Online Training
Really very helpful article , Thank you for sharing we have learned so much information from your blog
Big Data and Hadoop Online Training
Big Data Hadoop Training
Hyderabad
nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.
Spark and Scala Online Training
Spark Scala Training
Hyderabad
Very good article, very nice information, thanks for sharing.
Regards
Tirupati darshan online booking
Tirupati darshan online booking
Tirupati package from Bangalore
Best Tirupati package from Bangalore
Tirupati darshan package from Bangalore
Tirupati tour package from Bangalore
Very good article, I often read articles on topics like this but never this good. Don't forget to read our article which is certainly no less interesting.
piala eropa 2021
casino indonesia
Rapido y Furioso 9 pelicula completa
Luca pelicula completa
Inuyashiki pelicula completa
El Conjuro 3 pelicula completa
A prueba de fuego pelicula completa
Black Widow pelicula Completa
This applicationis considered for video calling across the globe. Be it with friends or family or with your colleagues, this application makes it possible to connect and do video chat or conferencing, wherever you are. Skype Login canon.com/ijsetup | cannon/ijsetup | Cox webmail Login
Norton Antivirus provides protection from viruses, malware, online threats without harming device performance. It also blocks harmful websites. You can get Norton.com/setup product from retail store and also download and install Norton Antivirus with product key from Norton.com/setup. And to do this, you can visit the website given by us at Norton.com/setup or link. Our entire team is available to help you.
Norton.com/setup
website to setup your printer. Get started withyour new printer by downloading the software.We Support you for 123 hp com Setup Network Printer Connection which can be done by either USB or Wireless Connection.website to setup your printer get started with your new printer by downloading the software.You will be able to connect the printer to a network and print across devices.
123.hp.com/setup
Download and install and office setup from office.com/setup . log in and enter office 25 digit product key to activate your office product. if you are new user then you need to create a office account to get more benefits of office.com/setup subscription. Ms office is a new sensatin office.com/setup in the market that left every body awestruck with its best products.
office.com/setup
office.com/setup
office.com/setup
office.com/setup
office.com/setup
office.com/setup
office.com/setup
Download the McAfee antivirus mcafee.com/activate key to protect your device from being spoiled by the harmful viruses as it starts finding the way to remove them from the device as soon as possible.If you have code, you enter mcafee activation code and if you have any problems redeeming your activation code, you can contact our team through this website mcafee.com/activate and get the information Can.For more information, you can visit our website mcafee.com/activate and enjoy.
mcafee.com/activate
it’s really nice and meanful. it’s really cool blog. Linking is very useful thing.you have really helped lots of people who visit blog and provide them usefull information.
Data Science Training in Hyderabad
I am really happy to say it’s an interesting post to read . I learn new information from your article , you are doing a great job . Keep it up
Devops Training in Hyderabad
Hadoop Training in Hyderabad
Python Training in Hyderabad
Tableau Training in Hyderabad
Selenium Training in Hyderabad
長津湖 Online
一級指控 Online
脫稿玩家 Online
藍色海灣 Online
跑道終點 Online
17歲的天空 Online
克里斯汀貝爾之黑暗時刻 Online
311：東京大震盪 Online
最後的決鬥 Online
undefined
Venom 2 online gratis
La noche de Halloween online gratis
Cato Pelicula completa en Español
Halloween Kills online gratis
Venom pelicula completa
Venom 2 pelicula completa
Kung Fu Panda 3 pelicula completa
NÉZD Gyilkos Halloween Filmek
NÉZD Venom 2 Filmek
NÉZD Egy kivételes barát Filmek
NÉZD Addams Family 2 Filmek
NÉZD 007 Nincs idő meghalni Filmek
NÉZD Végtelen útvesztő 2 Filmek
NÉZD Free Guy Filmek
NÉZD Venom Filmek
Dina Filmovi Online
Nesavršeni robot Ron Filmovi Online
Vječnici Filmovi Online
Posljednji dvoboj Filmovi Online
VENOM 2 Filmovi Online
Svi sveci mafije Filmovi Online
The Addams Family 2 Filmovi Online
ZA SMRT NEMA VREMENA Filmovi Online
Ne diši 2 Filmovi Online
Kolonija Filmovi Online
[Filmovita] Zeleni vitez
[Filmovita] CRNA KUTIJA
[Filmovita] Iza rešetaka
[Filmovita] Mali šef: Obiteljski posao
[Filmovita] Poslije svega: Pad
[Filmovita] Kraljice kupona
[Filmovita] Petar Zecimir: Skok u avanturu
[Filmovita] Shang-Chi: Legenda o deset prstenova
[Filmovita] Avanture obitelji Bigfoot
[Filmovita] AINBO: DOBRI DUH AMAZONE
I want to thank you for this great read!! I definitely love every part of it. I have you bookmarked your site to see what new you post
駕駛我的車 Online HD
老亨利 Online HD
美好的世界 Online HD
營救距離 Online HD
風信子 Online HD
摩加迪沙 Online HD
心猿意馬 Online HD
無主之人 Online HD
人狼遊戲7：地獄 Online HD
我來自北京之瑪尼堆的秋天 Online HD
Full Movie HD
Full Movie HD
Full Movie HD
Full Movie HD
Full Movie HD
Full Movie HD
Full Movie HD
Full Movie HD
Full Movie HD
Full Movie HD
Lật Mặt 5: 48H vietsub
Trò Chơi Con Mực vietsub
Halloween Kills vietsub
Tên Của Tôi vietsub
Halloween Kills phim hay
Halloween Kills phim hay
Bố Già full hd
Lừa Đểu Gặp Lừa Đảo phim hay
Squid Game Full Movie HD
Sprzątaczka Full Movie HD
Sceny z życia małżeńskiego Full Movie HD
Nocna msza Full Movie HD
Kasztanowy ludzik Full Movie HD
Good Girls Full Movie HD
Mała Wielka Stopa 2 Full Movie HD
Free Guy Full Movie HD
Oszustki Full Movie HD
Spencer Full Movie HD
Phim Lừa Đểu Gặp Lừa Đảo
Phim Lật Mặt 5 - 48H
Phim Venom 2
Phim Squid Game
Phim Lật Mặt 5
Phim Free Guy
Phim No Time to Die
Phim Mortal Kombat
Phim Jungle Cruise
Phim Halloween Kills
Tu sam pred tobom Online sa Prevodom
Lovci na natprirodno Online sa Prevodom
Na putu prema dolje film sa prevodom
Grimm ( 2021 )online sa prevodom
Fast and furious 9 ( 2021 )online sa prevodom
Liga pravde Zacka Snydera ( 2021 )online sa prevodom
Emily in Paris ( 2021 )online sa prevodom
After we fell ( 2021 )online sa prevodom
SUMRAK SAGA: PRASKOZORJE 2 ( 2021 )online sa prevodom
Venom 2 ( 2021 )online sa prevodom
Squid Game streaming
Check Out the Best Movies on My Platform
Phim Venom: Đối Mặt Tử Thù
Phim Trò Chơi Con Mực Game
Phim Lật Mặt 5 vietsub
Phim Bond 25
Phim Halloween Kills Vietsub
Phim Detective Conan Movie 24
Phim Bàn tay diệt quỷ
Phim Dune
Phim Shang-Chi
Phim Hometown Cha Cha Cha
Check Out the Best Movies on My Platform
My Name HD Vietsub
Bốn Chúng Ta HD Vietsub
Tình Đầu Chóng Phai HD Vietsub
Tình Yêu Vật Lý TẬP 11 HD Vietsub
Chỉ Là Quan Hệ Hôn Nhân TẬP 14 HD Vietsub
Narcos Vs Zombies HD Vietsub
Thank you for posting such a great article! It contains wonderful and helpful posts. Keep up the good work
月光光新慌慌：萬聖殺 Duckling Online
靈語 Duckling Online
蜜月夜不眠 Duckling Online
怒火 Duckling Online
血客聯盟 Duckling Online
爽賺姐妹 Duckling Online
羊懼 Duckling Online
鬼計 Duckling Online
我的意外男伴 Duckling Online
租屋全都錄 Duckling Online
Thank you for posting such a great article! It contains wonderful and helpful posts.
[Gledaj] Halloween Kills (2021) Online Sa Prevodom
[Gledaj] Dune (2021) Online sa Prevodom
[Gledaj] Nesavršeni robot Ron (2021) Online sa Prevodom
[Gledaj] 100% Wolf (2021) Online sa Prevodom
[Gledaj] VENOM 2 (2021) Online sa Prevodom
[Gledaj] ZA SMRT NEMA VREMENA (2021) Online sa Prevodom
[Gledaj] The Addams Family 2 (2021) Online sa Prevodom
[Gledaj] The Last Duel (2021) Online sa Prevodom
[Gledaj] The Boss Baby: Family Business (2021) Online sa Prevodom
[Gledaj] Love, Rosie (2021) Online sa Prevodom
This is a great post.I am going to write on this topic based on your writing.
Would you please come to my blog and give me some advice? We look forward to your feedback
english stories gk quiz app english stories collection
"Microsoft 365 is the productivity cloud designed to help you pursue your passion and run your business. More than just apps like Word, Excel, PowerPoint, Microsoft 365 brings together best-in-class productivity apps with powerful cloud services, device management, and advanced security in one, connected experience.
office.com/setup"
You can download and install norton setup from Norton.com/setup
. Norton may receive annual renewal billing, cancellations, refunds, subscriptions, credit card updates, purchases by Norton membership. Visit Norton.com/setup
to activate or renew your Norton membership. And a valid Norton membership ensures that your security is always updated. You should activate or renew your subscription before the trial or membership period ends so that all Norton features can continue to be used and your computer is protected. For more information, you can contact our team at Norton.com/setupand get more and more information.
Norton.com/setup
Norton.com/setup
Norton.com/setup
Norton.com/setup
Norton.com/setup
Norton.com/setup
Roku empowers you to watch free and roku.com/link
paid video content on your TV by methods for the Internet. For Activating Roku, go to www.roku.com/associate record enter Roku com association code appeared on Roku TV. Initiate Roku tv, go to rokucom link roku.com/link
record enter Roku com connection code showed on Roku TV.
roku.com/link
roku.com/link
roku.com/link
Kaspersky Anti-Virus features include real-time protection, detection and removal of viruses, trojans, worms, spyware, adware, keyloggers, malicious tools and auto-dialers, as well as detection and removal of rootkits.
Kaspersky.com/activation
Kaspersky.com/activation
Kaspersky.com/activation
Kaspersky.com/activation
Kaspersky.com/activation
Kaspersky.com/activation
Norton Antivirus provides protection from viruses, malware, online threats without harming device performance. It also blocks harmful websites. You can get Norton.com/setup product from retail store and also download and install Norton Antivirus with product key from Norton.com/setup. And to do this, you can visit the website given by us at Norton.com/setup or link. Our entire team is available to help you.
Norton.com/setup
Norton.com/setup
Norton.com/setup
Norton.com/setup
Norton.com/setup
Norton.com/setup
Roku Streaming players are an increasingly advantageous roku.com/link and financially savvy approach to sit in front of the TV. Simply plug it into your TV, associate with the web, set up a Roku record, and start spilling your top choices.Roku gadgets are easy to set-up and simple to-utilize.
roku.com/link They accompany a straightforward remote, and incredible highlights like Roku Search which makes it easy to discover what you need to watch.
roku.com/link
roku.com/link
roku.com/link
Select the office product you want to download and install on the device. Go to the office.com/setup option. To upgrade Office, press on the products of office.com/setup and start downloading and installing Office products on the device.log in and enter office 25 digit product key to activate your office product. if you are new user then you need to create a office account to get more benefits of office.com/setup subscription.
office.com/setup
office.com/setup
good blog. your blog is really informative and helpful for me
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Oracle Integration Cloud Online Training
Oracle Fusion Technical Online Training
Hii, Thanks for share the info. Whatever the case might be, these tasks can only be performed if you do Netgear extender login
If your Canon Printer Offline, don't worry. There are several simple fixes that you can try to resolve the issue. By checking connectivity, restarting devices, updating drivers, and reinstalling software, you should be able to get your printer back online in no time.
The Canon Pixma TR8520 Setup top-notch printing quality with remarkable color depth. In case you want to connect it with WiFi, you can contact our helpline or visit our official website. Our team of expert support staff for Canon printers will provide guidance over the phone or through remote chat assistance. We will take you through the essential steps to achieve a successful Canon printer setup.