ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE ORACLE 报错 故障修复 远程处理

文档解释

ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE

Cause: A statement contained both [NO]LOGGING and [UN]RECOVERABLE clauses which is disallowed.

Action: Remove one of the offending clauses. [UN]RECOVERABLE is being deprecated in V8 and will be obsoleted in V9. To duplicate semantics of UNRECOVERABLE clause, create an object with NOLOGGING option and then ALTER it specifying LOGGING. To duplicate semantics of RECOVERABLE clause, create an object with LOGGING option.

。

ORA-14103：LOGGING / NOLOGGING与RECOVERABLE / UNRECOVERABLE不能结合使用

官方解释

ORA-14103表示在启动数据库时，用户尝试同时使用LOGGING或NOLOGGING选项和RECOVERABLE或UNRECOVERABLE选项，然而这两种操作不能同时使用。

常见案例

一般来说，作为管理员，你可能会遇到这个错误。在启动oracle数据库或进行一些操作时，你可能会尝试启用 Recovery 选项，如 LOGGING和 NOLOGGING，你可能想把RECOVERABLE和UNRECOVARABLE也给加上，但Oracle不允许你同时使用这两者，因此你可能会收到ORA-14103。

正常处理方法及步骤

Oracle不允许同时使用LOGGING / NOLOGGING和RECOVERABLE / UNRECOVERABLE选项。如果你收到这个错误，请确保你只使用一个选项。