- 最后登录
- 2019-3-15
- 在线时间
- 4 小时
- 威望
- 0
- 金钱
- 37
- 注册时间
- 2014-6-17
- 阅读权限
- 10
- 帖子
- 7
- 精华
- 0
- 积分
- 0
- UID
- 1874
|
1#
发表于 2015-2-9 10:52:58
|
查看: 5962 |
回复: 6
GoldenGate 做数据轨迹用的,运行有半年左右,
extract 参数如下:
extract extiom
setenv(NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)
dynamicresolution
userid ogg,password ogg
TRANLOGOPTIONS ASMUSER XXXX@ASM,ASMPASSWORD XXXXX
exttrail /arch_1/ogg/dirdat/pf
DBOPTIONS ALLOWUNUSEDCOLUMN
nocompressupdates
table IOM.WO_WORK_ORDER_DETAIL;
table IOM.OM_ORDER;
.......
最近突然挂了,看日志发现
2015-02-09 09:36:56 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extiom.prm: error 13 (Permission denied) opening redo log /arch_1/1_7485_842108495.dbf for sequence 7485Not able to establish initial position for begin time 2015-02-09 09:36:10.
2015-02-09 09:36:56 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extiom.prm: PROCESS ABENDING.
ASM的权限是够的,已经用sys试过,数据库是Oracle11G,
请刘大帮忙看看如何解决 |
|