ORA-16806: Supplemental logging is not turned on.



ORA-16806: Supplemental logging is not turned on...

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-36268: (XSCGMDLAGG01) 'string' is not a valid dimension value.

1 Answers  


TNS-12203: TNS:unable to connect to destination

1 Answers  


ORA-07642: smprtset: $CMKRNL failure

1 Answers  


TNS-01172: Listener has shut down since all listen addresses have been deallocated

1 Answers  


NZE-29028: Server verification failure when using SSL 2.0

1 Answers  


ORA-32320: REFRESH FAST of "string"."string" unsupported after container table PMOPs

2 Answers  


ORA-30018: Create Rollback Segment failed, USN string is out of range

1 Answers  


QSM-02088: mv omits at least one grouping key from the select list

1 Answers  


ORA-16001: database already open for read-only access by another instance

1 Answers  


ORA-10576: Give up restoring recovered datafiles to consistent state: some error occurred

1 Answers  


ORA-01252: cannot prevent writes - file string in recovery manager backup

1 Answers  


ORA-30431: refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string

1 Answers  


Categories