REPLICAT RORA_1保持 ABENDED状态,无法启动问题处理
来源:互联网 发布:阿里云备案邮寄资料 编辑:程序博客网 时间:2024/04/29 08:09
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):块内的位置偏移量
3 1
- REPLICAT RORA_1保持 ABENDED状态,无法启动问题处理
- OGG故障排除1例:因B机被修改数据导致replicat服务ABENDED修复
- OGG_模拟abended状态,并修复。
- ogg replicat 进程 abend 处理
- ogg replicat 进程 abend 处理
- ogg replicat 进程 abend 处理
- linux网络设备无法启动问题处理
- Citrix Receiver 无法启动的问题处理
- 联网状态下,ARCGIS 10无法启动的问题
- GoldenGate 配置extract,replicat进程自启动
- GoldenGate 配置extract,replicat进程自启动
- 无法向会话状态服务器发出会话状态请求。请确保已启动 ASP.NET State service,并且客户端和服务器端口保持相同。
- 无法向会话状态服务器发出会话状态请求。请确保已启动 ASP.NET State service,并且客户端和服务器端口保持相同。
- 保持状态!
- 状态保持
- 状态保持
- 数据库异常关闭后无法启动问题处理(ORA-01102)
- vcenter postgresql 空间满,导致无法启动问题的处理。
- boost asio 串口操作中修改字节超时间隔参数
- ubuntu配置nginx常见错误
- Oracle中的select for update
- linux sed 批量替换多个文件中的字符串
- UI笔记_UIButton
- REPLICAT RORA_1保持 ABENDED状态,无法启动问题处理
- GridView绑定DataKeyName以及如何取这些值
- SQL Server 2005 中做全文检索的方法分享
- [Android] [UI Design 1] A ScrollView above a Button
- 今天开始LINUX学习之旅
- VS2013如何设置显示代码行号
- eclipse设置运行参数
- 字符串和NSDate的转换
- lucene_indexWriter说明、索引库优化