ORA-00336: log file size string blocks is less than minimum string blocks ORACLE 报错 故障修复 远程处理

文档解释

ORA-00336: log file size string blocks is less than minimum string blocks

Cause: The log file size as specified in create database is too small.

Action: Increase the log file size.

ORA-00336 错误：LOG FILE SIZE xx BLOCKS IS LESS THAN MINIMUM xx BLOCKS

官方解释

当您为LOG_BUFFER参数指定的块数比最低正文块数（LOGBUFSIZ）要少时，会报出“ORA-00336: log file size xx blocks is less than minimum xx blocks”的状态码。

常见案例

改变了LOG_BUFFER参数比最低正文块数（LOGBUFSIZ）要小

正常处理方法及步骤

在这种情况下，需要增加LOG_BUFFER参数的值，使其不小于最低正文块数（LOGBUFSIZ）。示例如下：

ALTER SYSTEM SET LOG_BUFFER=xx;