ORA-16806: supplemental logging is not turned on ORACLE 报错 故障修复 远程处理

文档解释

ORA-16806: supplemental logging is not turned on

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

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

。

ORA-16806：补充日志没有打开，是由于用户在执行DML常规操作但未将补充日志全局设置为ALTER DATABASE级别的正确选项时可能产生的错误。

官方解释

ORA-16806: Supplemental Logging is not turned on。这是由于使用DML语句（如INSERT）而未将全局补充日志设置为正确的ALTER DATABASE选项导致的错误。

常见案例

一般处理方法及步骤

1. 使用DBA_LOG_GROUPS及V$LOG_HISTORY，查看补充日志是否打开。

2. 如果未打开补充日志，则在数据库实例级别上增加事物补充日志。可以通过使用ALTER DATABASE命令来实现。

3. 确保日志组中的活动日志都已添加到补充日志中。

4. 然后在表和列级别上增加补充日志。可以使用ALTER TABLE 启用补充日志，或在列级别上启用补充日志。