问题描述某客户出现一个问题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.logOGG会再次报错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