Sunday, April 21, 2013

ORA-00216 Control File could not be Resized for Migration

Error Code
ORA-00216

Description
Control file could not be resized for migration from 8.0.2

Cause
Possible cause of this error is, the control file created by release 8.0.2 was missing some record types. These record types are automatically added by resizing the control file during mount. The resize has failed.

Action
To fix this issue, 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.

reference

No comments:

Post a Comment