首页 > 代码库 > REPLICAT RORA_1保持 ABENDED状态，无法启动问题处理
REPLICAT RORA_1保持 ABENDED状态，无法启动问题处理
REPLICAT RORA_1保持 ABENDED状态，无法启动问题
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)：块内的位置偏移量
环境：
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)：块内的位置偏移量
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。