GoldenGate_故障解决案例（中软内部文件）

1前期准备.............................................4  

1.1

操作系统环境变量..................................4

1.2

GoldenGate运行操作系统用户.................4

1.3

操作系统资源使用限制............................4

1.4

源数据库必须启动归档模式并开启附加日志...5

1.4.1

Oracle数据库.......................................5

1.4.2

DB2数据库..........................................5

1.5

AIX XL C版本......................................5

1.6

HP-UX aCC版本...................................6

1.7

Windows C++版本..............................6

1.8

GoldenGate安装目录............................6

1.9

RAC相关设置.......................................6

1.10

端口设置.............................................7

1.11

压缩传输设置.......................................7

1.12

待复制表名设置....................................7

1.13

队列文件保存期限设置............................7

1.14

抽取及复制分组....................................7

1.15

AIX使用裸设备.....................................8

1.16

同步表清单..........................................8

1.17

临时表排除..........................................8

1.18

UNIX GGSCI需要lib包验证......................8

2

常见错误处理......................................10

2.1

AIX GGSCI无法运行............................10

2.2

HP-UX GGSCI无法运行........................10

2.3

OGG-01296......................................11

2.4

OGG-01154......................................11

2.5

OGG-01088......................................12

2.6

OGG-01224......................................12

2.7

OGG-01031......................................12

2.8

OGG-01072......................................13

2.9

OGG-01476......................................13

2.10

OGG-00850......................................13

2.11

OGG-01027（长事务）........................14

2.12

队列文件保存天数.................................15

2.13

复制进程拆分及指定队列文件及RBA..........15

2.14

BOUNDED RECOVERY........................15

2.15

排除不复制的表....................................15

2.16

从指定时间重新抓取..............................15

2.17

进程无法停止.......................................16

2.18

CLOB处理..........................................16

2.19

DB2不能使用checkpoint table...............16

2.20

Datapump进程每次只传一个文件.............16

2.21

Extract进程产生core文件......................17

2.22

中文字节数问题....................................17

3

中文表/中文字段处理.............................18

4

Extract拆分方法..................................19

5

Datapump和replicat拆分方法.................23

6

Logdump使用指引...............................26