Breaking the Read-Only Barrier: How to Run DML on Oracle Active Data Guard
ADG_REDIRECT_DML Introduction Historically, Active Data Guard (ADG) was strictly read-only. If an application needed to perform even a tiny "Insert into Audit_Log," it had to connect to the Primary. The DML Redirection feature marks a significant shift in ADG capabilities. ADG_REDIRECT_DML allows the standby to accept DML, transparently redirect it to the Primary, and wait for the apply service to bring the change back. This functionality effectively eliminates the 'look-but-don't-touch' limitation, providing a seamless experience for read-mostly applications that require occasional data persistence. Prerequisites & Environment Oracle Database Version: 19c or higher. License: Active Data Guard option. Mode: Standby must be in READ ONLY WITH APPLY (Active Data Guard). Primary Databa...