欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

REPLICATRORA_1保持ABENDED状态,无法启动问题处理

程序员文章站 2022-05-13 14:01:50
...

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