The number of Oracle redo threads (2) is not the same as the number of checkpoint threads (1)

Single-instance database multi-log thread, to build Ogg, start the extraction process when prompted by error:

ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extjms.prm:The number of Oracle Redo Threads (2) was not the SAM e As the number of checkpoint threads (1). EXTRACT groups on RAC systems should is created with the THREADS parameter (e.g., ADD EXT <group name>, Tranlog, THR EADS 2, BEGIN ...).

Because:which GoldenGate thread number corresponds to the Oracle redo threads , use the output from V$log,my Oraclehas a redo threads and goldengate Configue one extract group ;

There are two types of solutions:

One, delete Oracle log thread 2

sql> ALTER DATABASE disable thread 2;
Database altered.

sql> ALTER DATABASE drop logfile Group 3;
Database altered.

sql> ALTER DATABASE drop logfile Group 4;
Database altered.

Second, increase the extraction process of thread 2

Ggsci (host01) > Add Extract extjms2, Tranlog,threads 2, Begin now

Ggsci (host01) > Add exttrail/dirdat/js, Extract extjms, megabytes 50

This article is from "Healthy Happiness is Happiness" blog, please be sure to keep this source http://yiqiuyu.blog.51cto.com/3228402/1580849

The number of Oracle redo threads (2) is not the same as the number of checkpoint threads (1)