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):块内的位置偏移量