oracle ogg dataguard,请问下 OGG 可否安装在DATAGUARD上面呢?
我把它安装在DG 上主库也安装了OGG主库设置了用户和密码 以及6> dblogin userid ggs,password ggs7> add trandata shark.*备库 就是抽取进程起不来GGSCI (masterdg as ggs@goodg) 31> info allProgram StatusGroupLag at Chkpt...
我把它安装在DG 上
主库也安装了OGG
主库设置了用户和密码 以及
6> dblogin userid ggs,password ggs
7> add trandata shark.*
备库 就是抽取进程起不来
GGSCI (masterdg as ggs@goodg) 31> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EORA 00:00:00 00:08:19
EXTRACT RUNNING PUMP_SO 00:00:00 00:00:07
报错:
2015-04-02 18:05:01 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start eora.
2015-04-02 18:05:01 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [127.0.0.1]:41837 (START EXTRACT EORA ).
2015-04-02 18:05:01 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EORA starting.
2015-04-02 18:05:01 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, eora.prm: EXTRACT EORA starting.
2015-04-02 18:05:01 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, eora.prm: Operating system character set identified as UTF-8.
2015-04-02 18:05:01 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, eora.prm: ANSI SQL parameter syntax is used for parameter parsing.
2015-04-02 18:05:02 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, eora.prm: Setting session time zone to source database time zone 'GMT'.
2015-04-02 18:05:02 INFO OGG-02095 Oracle GoldenGate Capture for Oracle, eora.prm: Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.ZHS16GBK.
2015-04-02 18:05:02 INFO OGG-02095 Oracle GoldenGate Capture for Oracle, eora.prm: Successfully set environment variable ORACLE_SID=goodg.
2015-04-02 18:05:02 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, eora.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.
2015-04-02 18:05:02 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, eora.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/app/software/ogg/BR/EORA.
2015-04-02 18:05:02 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, eora.prm: filecaching started: thread ID: 1248471360.
2015-04-02 18:05:02 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, eora.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/app/software/ogg/dirtmp.
2015-04-02 18:05:02 ERROR OGG-00868 Oracle GoldenGate Capture for Oracle, eora.prm: The number of Oracle redo threads (2) is not the same as the number of checkpoint threads (1). EXTRACT groups on RAC systems should be created with the THREADS parameter (e.g., ADD EXT , TRANLOG, THREADS 2, BEGIN...).
2015-04-02 18:05:02 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, eora.prm: PROCESS ABENDING.
魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。
更多推荐


所有评论(0)