GoldenGate系统三:trouble shooting and log
GoldenGate系统三:trouble shooting and log
1、全局日志
[sql]
[oracle@irms155 ogg]$ tail ggserr.log
2013-05-15 11:20:10 WARNING OGG-03504 Oracle GoldenGate Delivery for Oracle,rorajs.prm: NLS_LANG character setAL32UTF8 on the target is different from the source database character setZHS16GBK. Replication may not be valid if the source data has an incompatiblecharacter for the target NLS_LANG character set.
2013-05-15 11:20:45 WARNING OGG-03504 Oracle GoldenGate Delivery for Oracle,roragd.prm: NLS_LANG character setAL32UTF8 on the target is different from the source database character setZHS16GBK. Replication may not be valid if the source data has an incompatiblecharacter for the target NLS_LANG character set.
2、查看所有进程的运行情况
[sql]
GGSCI (irms155) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING RORAGD 00:00:00 00:00:05
REPLICAT RUNNING RORAJS 00:00:00 00:00:00
3、查看单个进程的报告
[plain]
GGSCI (irms155) 4> view report roragd