Oracle Technology‎ > ‎DataGuard‎ > ‎

dataguard notes

Subscribe to posts

Turning SQL Apply on & off

posted 22 Jul 2011, 08:06 by Alan Nolan-Davies

The starting and stopping of SQL Apply is easiest achieved through Grid Control

however if Grid Control is not available... then you can achieve the same thing through DGMGRL
DGMGRL> EDIT DATABASE 'DR_Sales' SET STATE='APPLY-ON' WITH APPLY INSTANCE="dr_sales2';
This can also be stopped and started through SQL on the Logical Standby database
SQL> alter database stop logical standby apply;
SQL> alter database start logical standby apply;

1-1 of 1