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

 





8 comments:

  1. 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
  2. Very interesting and thanks for sharing such a good blog. keep sharing.
    best machine learning course in aurangabad

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

    ReplyDelete
  4. 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
  5. Порно видео онлайн бесплатно тут Жену в жопу

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

    ReplyDelete
  6. Best Casino Hotel St. Louis in St. Louis
    Best Casino Hotel St. Louis, MO. 3131 Saint Louis 서귀포 출장샵 Blvd. 양산 출장샵 South Center City, MO 70119. 계룡 출장마사지 The Best Casino Hotel St. Louis is 대구광역 출장샵 located nearby to the airport. 상주 출장마사지

    ReplyDelete
  7. The games and the referral program through Jaa Lifestyle are one simple way of earning money online. Individuals can earn extra bucks by just spending their time on Jaa Lifestyle website and get actually involves in the flow. As well there are few option such as to watch the ads, refer friends and use other options from the website which also does earn money. Jaa Login There are various ways Jaa Lifestyle provides money to individuals by just watching or using the services from it.Individuals to access Jaa Lifestyle website, they need to have got themselves register with the website through the official process. Here are the steps that you can follow to get access to Jaa Lifestyle Login ID.

    ReplyDelete