Shulou(Shulou.com)06/01 Report--

Single instance database with multiple log threads, set up ogg, and prompt an error when starting the extraction process:

ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extjms.prm: The number of Oracle redo threads (2) is not the same 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...).

BECAUSE:which GoldenGate thread number corresponds to the Oracle redo threads, use the output from voluptuous log.My oracle have two redo threads and goldengate configue one extract group

There are two solutions:

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, add thread 2 extraction process

GGSCI (host01) > Add Extract extjms2, TranLog,threads 2, Begin Now

GGSCI (host01) > Add ExtTrail. / dirdat/js, Extract extjms, Megabytes 50

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.