REPLICAT RORA_1保持 ABENDED状态,无法启动问题处理
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):块内的位置偏移量
最新文章
- hihoCoder 1196 高斯消元·二
- 写MYSQL存储过程遇到的一个小BUG
- 每天一个linux命令(9):nl命令
- 【Spark学习】使用Maven创建Spark
- LabVIEW系列——拍振现象重现
- python学习(四)五数连珠
- python time模块函数
- Error pulling origin: error: Your local changes to the following files would be overwritten by merge
- struts2.1.6教程十一、注解配置
- [Swift]LeetCode501. 二叉搜索树中的众数 | Find Mode in Binary Search Tree
- 金蝶K/3 同步用核算项目配置
- Mac 远程桌面 ubuntu16.04 unity
- shell脚本介绍 shell脚本结构和执行 date命令用法 shell脚本中的变量
- s3c2410串口笔记
- idea 热部署之JRebel安装-激活-简单使用(修改方法\配置文件均生效)
- Java中的forin语句
- 【Unity】12.3 Off Mesh Link组件
- PopupWindow错误:PopupWindow$1.onScrollChanged 出现 NullPointerException和PopupViewContainer.dispatchKeyEvent 出现 NullPointerException【转载】
- 用MVC5+EF6+WebApi 做一个考试功能(六) 仓储模式 打造EF通用仓储类
- Python 第三方包上传至 PyPI 服务器
热门文章
- poj3414(bfs)
- linux的tr命令
- Codeforces 164 E Compatible Numbers
- Codeforces 61E Enemy is weak 乞讨i&;lt;j&;lt;k &;amp;&;amp; a[i]&;gt;a[j]&;gt;a[k] 对数的 树阵
- SVN的svnlook命令
- Android---App Widget(一)
- ajax基本概念,方法
- java该HashTable,HashMap和HashSet
- codeforces55D数位dp
- 使用ToggleButton和StackPanel+Border实现圆角开关按钮动画效果