During replication the user began to encounter Null Hrid in transop errors. The user had activated with supplemental logging causing Oracle to normally enter the Hrid information into the redo logs. The supplemental logging information was however missing thus causing the Null Hrid Error.
The following log entry shows supplemental logging was enabled during activation.
04-10-21 06:58:05.517049 16022 1 FILE: /san01/oradata/rmprod/splex/var/log/rmprod_ocap01.log - LOG#: 1
04-10-21 06:58:05.517620 16022 1 sp_ocap: pid = 16022
04-10-21 06:58:05.677867 16022 1 ocap_conn = 17ddb8
04-10-21 06:58:05.741273 16022 1 initializing instance array
04-10-21 06:58:05.751378 16022 1 active instance_count=1
04-10-21 06:58:05.751487 16022 1 after opslog setup thread, active instance = 1
04-10-21 06:58:05.751560 16022 1 log dest: /san01/oradata/rmprod/splex/var
04-10-21 06:58:05.811903 16022 1 10753 - LMT cache not present for act 13
04-10-21 06:58:08.696654 16022 1 Done with un_checkpoint()
04-10-21 06:58:08.915099 16022 1 Activating with supplemental logging Enabled
04-10-21 06:58:08.955220 16022 1 10753 - LMT cache not present for act 13
04-10-21 06:58:49.273612 16022 1 Activating with supplemental logging Enabled
04-10-21 06:58:49.343349 16022 1 10753 - LMT cache not present for act 14
04-10-21 06:59:09.441031 16022 1 Activating with supplemental logging Enabled
04-10-21 06:59:09.521159 16022 1 10753 - LMT cache not present for act 15
04-10-21 07:04:32.716769 16022 1 *********** WARNING: NULL HRID ***********
04-10-21 07:04:32.716873 16022 1 Records listed in transaction list order:
04-10-21 07:04:32.716940 16022 1 ************************ Log record at 0x350588
04-10-21 07:04:32.717008 16022 1 op 0x5 URP
04-10-21 07:04:32.717100 16022 1 sflg 0x1 OLSF_SOBJ
The next log entry shows where a chained row did not contain supplemental
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center