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 databaseSQL> alter database stop logical standby apply; SQL> alter database start logical standby apply; |
|
|
|
|
|
 |
Turning SQL Apply on & offposted 22 Jul 2011 08:06 by Alan Nolan-Davies |