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:
SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE;
On the standby database, query the V$ARCHIVED_LOG view to identify existing files in the archived redo log.
SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
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.
SELECT RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS;
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.
SELECT MESSAGE FROM V$DATAGUARD_STATUS;
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:



48 Responses so far.

  1. Thanks Emre. It is good to recall all the data guard views, particularly the link you provided for views is very useful.

    -Vimal

  2. Anonymous says:

    It is good to copy link info for backup purposes. It is no longer valid. Anyway thank you for the good info.

    Pooh

  3. Anonymous says:

    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

  4. Vivek says:

    Awesome post……. your article is really informative and helpful for me and other bloggers too

    Oracle Fusion SCM Online Training

  5. sushma says:

    Hey Really Thanks for sharing the best information regarding category, hope you will write more great blogs.
    Oracle Fusion Financials Online Training

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

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

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

  9. Tom Cook says:

    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


  10. komalweb says:

    Download System Mechanic Professional for Windows to optimize, repair, and protect your PC against Internet threats. System Mechanic is a quick, simple way to clear unwanted files from your PC .System Mechanic Download enables the users to make your device perform more efficiently and without any issues. Visit system mechanic Download and get the software for your device.

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

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

  13. shilpi says:


    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

  14. shilpi says:

    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

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

  16. Unknown says:

    Amazon Prime Video allows clients to download their top shows and videos to view later. This option is great for clients who want to enjoy Amazon Prime Video in disconnected mode. If you have registered your devices using amazon.com/mytv, you will be able to view the downloaded videos immediately on your device. Follow the below steps to download your top-rated videos from Amazon Prime Video.
    primevideo/mytv
    amazon.com/code
    amazon.com/mytv
    www.amazon.com/mytv

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

  18. shiviwebh says:

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

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

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

  21. shilpiweb says:

    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

  22. shiviweb says:

    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

  23. shiviweb says:

    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

  24. shiviweb says:

    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

  25. Unknown says:

    You will need to sign into your Amazon Prime Account during the activation phase. It is essential to have an Amazon Prime Account created. This account is only activated by a free login.
    www.uktvplay/activate
    ok google set up my device
    locast.org activate
    amazon com code

  26. This comment has been removed by the author.
  27. Hii, Thanks for share the info. Whatever the case might be, these tasks can only be performed if you do Netgear extender login

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

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

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -