Use the following query to check whether supplemental logging is enabled for each instance in RAC: SELECT inst_id, SUPPLEMENTAL_LOG_DATA_MIN FROM gv$database.
If it is not enabled on one of the nodes, do the following on each node: alter database add supplemental log data alter system switch log file. Then run ora_cleansp and reactivate the config file. Make sure ALL nodes in a RAC are up when performing the activation. You will need to re-sync any rows that went out of sync due to one of the nodes having supplemental logging turned off.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center