在OGG中EXCLUDE THREAD n日志
DB: 11.2.0.1
OGG: 11.2.0.1
大概情况是这样的,生产数据库为单机,通过OGG做异地灾备
因为生产要升级RAC,准备通过ADG的SwitchOver将数据库迁移到RAC环境,所以在搭建single instance primary - RAC standby的过程中,在single instance primary 上执行了:
ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 11.........
ALTER DATABASE ENABLE PUBLIC THREAD 2;
所以这时single instance primary虽然是单实例,但是存在2个thread
而且导致OGG EXTRACT进程宕了,报错信息:
OGG-00446 The number of Oracle redo threads (2) is not the sa
me 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...).
这个应该怎么去处理呢?需要把所有的EXTRACT REPLICAT进程删掉重新配置吗? 删掉,重新添加ext的时候使用threads 2,应该是这样
页:
[1]