代码改变世界

GoldenGate系统三:trouble shooting and log

2013-05-16 10:56  jediael  阅读(195)  评论(0编辑  收藏  举报

1、全局日志

[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、查看所有进程的运行情况

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、查看单个进程的报告

GGSCI (irms155) 4> view report roragd