Oracle 23c New Features for DBA'sStarting 19c, We can run DML operations on Active Data Guard standby databases. This enables you to run read-mostly applications, which occasionally execute DMLs, on the standby database.
Automatic redirection of DML operations to the primary can be configured at the system level or the session level. The session level setting overrides the system level setting.
- To configure automatic redirection of DML operations for all standby sessions in an Active Data Guard environment:
Set the ADG_REDIRECT_DML initialization parameter to TRUE.
- To configure automatic redirection of DML operations for the current session, use the following command:
ALTER SESSION ENABLE ADG_REDIRECT_DML;
Follow Me!!!