The following is the ORA-16806 error message, you can learn the cause and solution of the Oracle database error.


ORA-16806 Supplemental logging is not turned on

Cause: Supplemental logging is not turned on while there is a logical standby database in the configuration. This could happen either6854// on the primary or on the logical standby that is being switched over to the primary.

Solution: Check Data Guard console log for more details. Issue ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS to add supplemental logging.

Case:

Please wait for the update…