How Oracle Logical Dataguard database recovers skip table ora-02019\ora-16276\

---------------------------------------------------

Synchronizing tables

---------------------------------------------------

Sql> EXECUTE Dbms_logstdby. Instantiate_table (' USERNAME ', ' TABLENAME ', ' dblinkname ');

BEGIN Dbms_logstdby. Instantiate_table (' USERNAME ', ' TABLENAME ', ' dblinkname '); END;

---------------------------------------------------

Error phenomena

---------------------------------------------------

*

ERROR at line 1:

Ora-16276:specified database link does not correspond to primary database

Ora-06512:at "SYS. Dbms_internal_logstdby ", Line 5394

Ora-02019:connection description for remote database not found

Ora-06512:at "SYS. Dbms_logstdby ", line 636

Ora-06512:at Line 1

---------------------------------------------------

Solve

---------------------------------------------------

DATABASE LINK

CREATE Public DATABASE LINK Dblinknamedblink

CONNECT to USERNAME identified by action

USING ' (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.128.6) (PORT = 1521))) (Connect_data = (SERVICE _name = DBLINKNAME1)) ';

---------------------------------------------------

Execute again

---------------------------------------------------

Sql> EXECUTE Dbms_logstdby. Instantiate_table (' USERNAME ', ' TABLENAME ', ' dblinknamedblink ');

---------------------------------------------------

Log

---------------------------------------------------

Tue 12 21:47:33 2014

The value (in) of Maxtrans parameter ignored.

Kupprdp:master process DM00 started with pid=26, OS id=483392

To Execute-sys. KUPM$MCP. MAIN (' sys_import_table_01 ', ' SYS ', ' kupc$c_1_20140812214733 ', ' kupc$s_1_20140812214733 ', 0);

Kupprdp:worker process DW01 started with worker id=1, pid=27, OS id=507972

To Execute-sys. Kupw$worker. MAIN (' sys_import_table_01 ', ' SYS ');

Tue 12 21:48:03 2014

This article is from the "Wheat Dock" blog, please make sure to keep this source http://yunlongzheng.blog.51cto.com/788996/1539232