Logical DG restart replication
Date: Wed, 13 Oct 2010 17:36:35 -0400
For a LOGICAL Data Guard implementation with one primary and one secondary, replication was turned off by issuing 'alter system set log_archive_dest_state_2=defer scope=both;' on the primary and by issuing ' ALTER DATABASE STOP LOGICAL STANDBY APPLY;' on the standby. It's now been some time and there are quite a few logs built up.
Is there a better way to restart replication or would this be it: On the primary 'alter system set log_archive_dest_state_2=defer scope=both;' On the standby 'ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;'Received on Wed Oct 13 2010 - 16:36:35 CDT