Oracle Startup Fails With ORA-1122,ORA-01110 and ORA-01200 Due to Datafile Size been Smaller

This article is intended for a database that is failing with the following error message

while starting up the database:

ORA-01122: database file 9 failed verification check

ORA-01110: data file 9: '/u02/oradata/careware/users01.dbf '

ORA-01200: actual file size of 64000 is smaller than correct size of 65600

The solution is intended for users whose database is in NO ARCHIVE LOG mode and when

user doesnot have any other mean of recovering the database.

For database in ARCHIVE LOG mode the best and supported option is to restore and recover.

Please do not try this on SYSTEM tablespace as data dictionary objects may be incosistent after this procedure is applied.

No Archive log mode :-

> Take an Cold backup of the database.

> Once the Cold backup is taken do the following :-

The error message ORA-01110 and ORA-01122 would indicate the datafile number and name having the problem.

The error message ORA-01200 provides information about the current file size and the correct size

Oracle expects.

Error: ORA 1200

Text: actual file size of <num> is smaller than correct size of <num> blocks

-------------------------------------------------------------------------------

Cause: The size of the file, as returned by the operating system, is smaller

than the size of the file as indicated in the file header and the

control file. Somehow the file has been truncated.