In a RAC environment the Capture may be behaving erratically in that the transactions are not captured at times, the flush are sometimes gathered and at other times are not, or the Capture core dumps. Most importantly, the following messages are written in *ocap* log (the Capture log) located in $SP_SYS_VARDIR/log directory:
ocap 2009-09-21 20:27:36.566141 1331378 1 parse_supp_log_info: discarding record 0x030e60.000069dd.00b8: due to missing supplemental data
ocap 2009-09-21 20:27:36.566264 1331378 1 parse_supp_log_info: discarding record 0x030e60.000069e8.00e4: due to missing supplemental data
Though the above messages may be pointing to lack of supplemental logging on the database, the event log mentions that it is enabled:
Info 2009-09-21 12:57:23.036006 1331378 1 Capture now replicating actid 14, for sid o.SID
Notice 2009-09-21 12:57:23.036358 1331378 1 Capture: The database supplemental logging state = Enabled, primary_key = Enabled, unique_key = Enabled (capturing from SID) [module oct]
Notice 2009-09-21 12:57:23.058652 1331378 1 Capture: iot object: 321507 (capturing from SID) [module osp]
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center