企业官网建设流程全解析

问题描述

某客户出现一个问题，OGG源端为Physical Standby，对数据库做switchover后切换为Primary，但是OGG抽取进程无法正常启动，启动报错如下：

ERROR OGG-02803 Oracle GoldenGate Capture for Oracle, egs_stu.prm: Encountered a Data Guard role transition. Alter Extract to SCN 19,674,009,765 and restart Extract, or recreate Extract with the correct number of threads at SCN 19,674,009,765.

解决方法

步骤1：在抽取进程中添加参数TRANLOGOPTIONS USEPREVRESETLOGSID，如:

步骤2：重新启动抽取进程

start egs_stu

此时，查看ggserr.log，OGG会再次报错

ERROR OGG-02803 Oracle GoldenGate Capture for Oracle, egs_stu.prm: Encountered a Data Guard role transition. Alter Extract to SCN 19,674,009,765 and restart Extract, or recreate Extract with the correct number of threads at SCN 19,674,009,765.

步骤3：将进程SCN修改为报错的SCN号

alter egs_stu, scn 19674009765

步骤4：将参数TRANLOGOPTIONS USEPREVRESETLOGSID从抽取进程中拿掉，如：

步骤5：重新启动抽取进程后同步正常

start egs_stu