Wednesday, November 25, 2020

DML operations on Active Data Guard standby in Oracle 19c

The DML operations is an Active Data Guard only feature enables DML operations on the standby database to be redirected to the primary to accommodate infrequent writes by reporting applications running against Active Data Guard standby database.

This DML feature introduced in Oracle 19c, this includes DML statements that are part of PL/SQL blocks.

The DML on the standby database will have below steps
  • The user executes DML against open standby database.
  • DML will be automatically redirects to the primary database.
  • The DML will be applied on the primary Datable
  • The redo info related change is streamed back to the standby database.
  • The application change based redo info completes the DML and data is available for the client.
There are two methods to configure DML Redirection with the help of ADG_REDIRECT_DML parameter.

1. The DML Redirect can be configured at system level, this will apply to all sessions connection to the standby database

Run below command for SYSTEM LEVEL DML Redirection
SQL> ALTER SYSTEM SET ADG_REDIRECT_DML=TRUE SCOPE=BOTH;

2. You can overwrite the system level parameter with alert session command to enable the DML redirect for the current session only.

Run below command to enable SESSION LEVEL DML Redirection 
SQL>ALTER SESSION ENABLE ADG_REDIRECT_DML;

Thanks & Regards
http://oracleracexpert.com

 





20 comments:

  1. Packers and Movers Bangalore - Reliable and Verified Household Shifting Service Providers Give Reasonable ###Packers and Movers Charges. Cheap and Best Office Relocation Compare Quotation for Assurance for Local and Domestic House Shifting and Get estimates today to save upto 20%, ***Read Customer Reviews - @ Packers And Movers Bangalore

    ReplyDelete
  2. Get Packers and Movers Jaipur List of Top Reliable, 100% Affordable, Verified and Secured Service Provider. Get Free ###Packers and Movers Jaipur Price Quotation instantly and Save Cost and Time. Packers and Movers Jaipur ✔✔✔Reviews and Compare Charges for household Shifting, Home/Office Relocation, ***Car Transportation, Pet Relocation, Bike SHifting @ Packers And Movers Jaipur

    ReplyDelete
  3. Get Shifting/Relocation Quotation from ###Packers and Movers Delhi. Packers and Movers Delhi 100% Affordable and Reliable ***Household Shifting Services. Compare Transportation Charges and Save Time, Verified and Trusted Packers and Movers in Delhi, Cheap and Safe Local, Domestic House Shifting @ Packers And Movers Delhi

    ReplyDelete
  4. Packers and Movers Gurgaon Provide Reliable, Safe and Certified Service Provider list, Get Free ***Best Price Quotaition and Compare Charges. ???Hassle free Household Shifting Services, High Quality packing Material, Office Relocation, Car Transportaion, ###Local and Domestic Shifting Service @ Packers And Movers Gurgaon

    ReplyDelete
  5. Hey!Amazing work. With full of knowledge. Our Team resolve any glitches occurring while utilizing the software. Looking for Quickbooks Error Support Contact us (877) 606-0004.Our experts will assist you to fulfil your accounting needs. The solutions are accurate and time-saving.

    ReplyDelete
  6. Packers and Movers Chennai Give Safe and Reliable ***Household Shifting Services in Chennai with Reasonable ###Packers and Movers Price Quotation. We Provide Household Shifting, Office Relocation, ✔✔✔ Local and Domestic Transportation Services, Affordable and Reliable Shifting Service Charges @ Packers And Movers Chennai

    ReplyDelete
  7. Packers and Movers Hyderabad Give Certified and Verified Service Providers, Cheap and Best ###Office Relocation Charges, ***Home Shifting, ✔✔✔Goods Insurance worth Rs. 10,000, Assurance for Local and Domestic House Shifting. Safe and Reliable Household Shifting Services in Hyderabad with Reasonable Packers and Movers Price Quotation @ Packers And Movers Hyderabad

    ReplyDelete
  8. We are the best Provider Escorts Service in Nashik. Our call girls are the best in terms of sexual satisfaction with full pleasure, they are well qualified and professional working. Nashik Escorts |
    Nashik Call Girls

    ´´´´´████████´´´´
    ´´`´███▒▒▒▒███´´´´´
    ´´´███▒●▒▒●▒██´´´
    ´´´███▒▒▒▒▒▒██´´´´´
    ´´´███▒▒💋▒▒██´
    ´´██████▒▒███´´´´´
    ´██████▒▒▒▒███´´
    ██████▒▒▒▒▒▒███´´´´
    ´´▓▓▓▓▓▓▓▓▓▓▓▓▓▒´´
    ´´▒▒▒▒▓▓▓▓▓▓▓▓▓▒´´´´´
    ´.▒▒▒´´▓▓▓▓▓▓▓▓▒´´´´´
    ´.▒▒´´´´▓▓▓▓▓▓▓▒
    ..▒▒.´´´´▓▓▓▓▓▓▓▒
    ´▒▒▒▒▒▒▒▒▒▒▒▒
    ´´´´´´´´´███████´´´´
    ´´´´´´´´████████´´´´´´
    ´´´´´´´█████████´´´´´
    ´´´´´´██████████´´´
    ´´´´´´██████████´´
    ´´´´´´´█████████´
    ´´´´´´´█████████´
    ´´´´´´´´████████´´´
    ________▒▒▒▒▒
    _________▒▒▒▒
    _________▒▒▒▒
    ________▒▒_▒▒
    _______▒▒__▒▒
    _____ ▒▒___▒▒
    _____▒▒___▒▒
    ____▒▒____▒▒
    ___▒▒_____▒▒
    _███______▒▒
    █_███____███
    █__███_ _█_███
    █ ███

    ReplyDelete
  9. This is a brilliant article, Given such a great amount of data in it, These kind of articles keeps the clients enthusiasm for the site, and continue sharing more
    360DigiTMG data analytics course

    ReplyDelete
  10. Very interesting and thanks for sharing such a good blog. keep sharing.
    best machine learning course in aurangabad

    ReplyDelete
  11. Really Nice Information It's Very Helpful All courses Checkout Here.
    data science courses

    ReplyDelete
  12. This is also a very good post which I really enjoyed reading. It is not every day that I have the possibility to see something like this..
    data science certification

    ReplyDelete
  13. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.I want to share about
    machine learning training in aurangabad

    ReplyDelete
  14. Порно видео онлайн бесплатно тут Жену в жопу

    Смотрите каждый день Русское порно онлайн бесплатно

    ReplyDelete