ORA-00217: control file could not be resized for new record types ORACLE 报错 故障修复 远程处理

文档解释

ORA-00217: control file could not be resized for new record types

Cause: The control file was missing some new record types supported by this release. These record types are automatically added by resizing the contol file during mount. The resize has failed.

Action: Look in the alert log for the reason that the resize has failed. If indicated in the alert log, give the control file more space. Otherwise, use the CREATE CONTROLFILE script dumped to the trace file to create a new control file.

Oracle错误 ORA-00217是一个意外的崩溃错误，它阻止Oracle从使用改变的控制文件。

官方解释

ORA-00217 ↵

controls file string could not be resized for new record types ↵

Cause: An attempt to resize the control file to accommodate new record↵

types failed.↵

Action: Check the accompanying error message. Usually, this means that some↵

error was encountered during a device read or write. The control file should↵

not be used until the problem is resolved and the file is successfully↵

verified.

这个错误通常是在你尝试增加控制文件的大小时而发生的，例如在增加在控制文件中可以容纳更多记录类型时。

常见案例

ORA-00217通常是在你尝试增加控制文件的大小时而发生的，例如在增加在控制文件中可以容纳更多记录类型时。比如，你可能会在添加一个新的表空间时遇到这个错误。

正常处理方法及步骤

1.确认错误消息中出现的任何处理错误，以找出导致ORA-00217出错的原因。

2.确定要增加的记录类型大小。

3.增加控制文件的大小。

4.重新启动数据库。