REPLICAT RORA_1保持 ABENDED状态，无法启动问题 环境： Item Source System Target System Platform Red Hat Enterprise Linux Server release 5.4 Red Hat Enterprise Linux Server release 5.4 Hostname gc1 gc2 Database Oracle 10.2.0.1 Oracle 11.2.0.1

REPLICAT RORA_1保持 ABENDED状态，无法启动问题

环境：

Item	Source System	Target System
Platform	Red Hat Enterprise Linux Server release 5.4	Red Hat Enterprise Linux Server release 5.4
Hostname	gc1	gc2
Database	Oracle 10.2.0.1	Oracle 11.2.0.1
Character Set	ZHS16GBK	ZHS16GBK
ORACLE_SID	PROD	EMREP
Listener Name/Port	LISTENER/1521	LISTENER/1521
Goldengate User	ogg	ogg

GGSCI (gc1) 12> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EORA_1 00:00:00 00:00:00
EXTRACT RUNNING PORA_1 00:00:00 00:00:02
REPLICAT ABENDED RORA_1 00:00:00 00:00:07

GGSCI (gc1) 13> info RORA_1 --gc1上查询RBA

REPLICAT RORA_1 Last Started 2014-06-23 15:01 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Log Read Checkpoint File ./dirdat/pa000007
2014-06-23 14:48:33.012010 RBA 1120

GGSCI (gc2) 3> info RORA_1 --gc2上查询RBA

REPLICAT RORA_1 Last Started 2014-06-23 14:23 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Log Read Checkpoint File ./dirdat/pa000009
2014-06-23 15:01:15.988450 RBA 1268

GGSCI (gc1) 15> ALTER replicat rora_1,extseqno 0,extrba 1268
--依据gc2的RBA对gc1进行设置

GGSCI (gc2) 16> start RORA_1

GGSCI (gc2) 17> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EORA_1 00:00:00 00:00:09
EXTRACT RUNNING PORA_1 00:00:00 00:00:01
REPLICAT RUNNING RORA_1 00:00:00 00:00:07

补充：关于RBA的组成：
（1）the log file sequence number (4 bytes)：日志文件序号
（2）the log file block number (4 bytes)：该日志文件序号内的块号
（3）the byte offset into the block at which the redo record starts (2bytes)：块内的位置偏移量

下载本文