Shulou(Shulou.com)06/01 Report--

Adg_redirect_dml of the new features of Oracle 19c ADG

SQL*Plus: Release 19.0.0.0.0-Production on Thu Nov 28 11:35:05 2019Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0-ProductionVersion 19.3.0.0.0SQL > set lines 120SQL > show parameter adg_redirect_dml NAME TYPE VALUE-- adg_ Redirect_dml boolean FALSEADG_REDIRECT_DML enables DML redirection from Oracle Active Data Guard. Configuring automatic redirection DML operations supports both the session level and the system level, which overrides the system level configuration. Enable DML redirection on all slave libraries to set the initialization parameter ADG_REDIRECT_DML to trueALTER SYSTEM SET ADG_REDIRECT_DML=true SCOPE=BOTH; current session enable DML redirection ALTER SESSION ENABLE ADG_REDIRECT_DML

The default value of this parameter is false, which only started in the version of Oracle 19c. The main function is that when we perform DML operations in the slave database, it will be redirected to the master database, and then synchronize to the slave database in the master database. We didn't turn it on by default.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.