Whenever there is a Table row difference in logical due to some Skip rule or transaction skip. Follow the below procedure to Resync the tables.
-- On primary
SQL> grant logstdby_administrator to system;
-- On logical standby
SQL> grant logstdby_administrator to system ;
SQL> Create public database link prod CONNECT TO system IDENTIFIED BY password USING 'TNSNAME'; ( Basically DB Link )
SQL> alter database stop logical standby apply;
SQL> exec dbms_logstdby.instantiate_table(USERNAME','TABLE_NAME','DB_LINK_NAME');
SQL> alter database start logical standby apply;
Note : This above operation does a export and import basically, generally my understanding is the table will be totally truncated and imported back.
Suggestions and Corrections are Welcome....!!!!
Thursday, May 22, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment