Logical DG restart replication

From: L. Vitt <cemail_219_at_hotmail.com>
Date: Wed, 13 Oct 2010 17:36:35 -0400
Message-ID: <SNT142-w5527EE42FE6E31D7739460A5550_at_phx.gbl>


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;'                                                                 

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 13 2010 - 16:36:35 CDT

Original text of this message