1、删除ogg进程
GGSCI (ogg2) 3> stop ext1
Sending STOP request to EXTRACT EXT1 …
Request processed.
GGSCI (ogg2) 9> dblogin userid ogg,password oracle
Successfully logged into database.
GGSCI (ogg2) 12> delete ext1
2、删除检查点进程
GGSCI (dup1 as ogg@dup1) 6> add checkpointtable ogg.rep_ntt_ckpt
ERROR: Failed creating checkpoint table ogg.rep_ntt_ckpt.
OCI Error ORA-00955: name is already used by an existing object (status = 955), SQL <CREATE TABLE ogg.rep_ntt_ckpt ( group_name VARCHAR2(8) NOT NULL, group_key NUMBER(19) NOT NULL, seqno NUMBER(10), rba NUMBER(19) NOT NULL, audit_ts VARCHAR2(29), create_ts DATE NOT NULL, last_update_ts DATE NOT NULL, current_dir VARCHAR2(255) NOT NULL, log_bsn VARCHAR2(128), log_csn VARCHAR2(128), log_xid VARCHAR2(128), log_cmplt_csn VARCHAR2(128), log_cmplt_xids VARCHAR2(2000), version NUMBER(3), PRIMARY KEY (group_name, group_key)) PCTFREE 60>.
GGSCI (dup1 as ogg@dup1) 7> delete checkpointtable ogg.rep_ntt_ckpt
This checkpoint table may be required for other installations. Are you sure you want to delete this checkpoint table? yes
Successfully deleted checkpoint table ogg.rep_ntt_ckpt.
3、当在源端创建一个新表时候，要使用ogg需要首先在源端给表开启附加日志
GGSCI (duplicate) 9> dblogin userid ogg,password oracle
Successfully logged into database.
GGSCI (duplicate as ogg@dup) 10> add trandata test1.*
2018-11-16 16:25:01 WARNING OGG-06439 No unique key is defined for table T1. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Logging of supplemental redo data enabled for table TEST1.T1.
TRANDATA for scheduling columns has been added on table ‘TEST1.T1’.
GGSCI (duplicate as ogg@dup) 11> info trandata test1.*
Logging of supplemental redo log data is enabled for table TEST1.T1.
Columns supplementally logged for table TEST1.T1: ID.
add trandata ogg_owner.togg_nokey,cols (ID),nokey
本篇文章来源于 Linux公社网站(www.linuxidc.com) 原文链接：https://www.linuxidc.com/Linux/2015-08/122325.htm