How do I correct the size of an Oracle datafile on a database that mounts but doesn’t open?

Eric T July 25, 2014
Pinterest Stumbleupon Whatsapp

Hi everybody,

I’m getting the following error on starting Oracle database through the enterprise manager console :
ORA-01122 : database file 2 failed verification check
ORA-01110 : datafile 2 ‘D:\oracle\oradata\new1\undotbs01.dbf’
ORA-01200 : actual file size of 72733 is smaller than correct size of 72960 blocks.

The database mounts but is not able to open.  I don’t have any backup of the database nor the datafiles.

Please help.

Ads by Google

  1. Bruce E
    July 25, 2014 at 8:09 pm

    We need more info. What version of Windows is the database running on? What version of Oracle are you using? What is the block size of the database? What is the cluster size of the drive hosting the problematic datafile?