Help - Search - Members - Calendar
Full Version: Problem starting database
Oracle DBA Forums > Oracle > Oracle Forum
Hello, I am having a problem starting my database. I am getting the following error:

ORA-01122: database file 4 failed verification check
ORA-01110: data file 4: 'F:\oracle\oracle_data|p3ec\pmdb_data1.dbf'
ORA-01200: actual file size of 1569280 is smaller than correct size of 1569920

Can anyone provide any suggestions?

I would like to add that there is no backup and archivelogs
Who or what changed the file? The size difference of 640 bytes doesn't fit into an explainable "off by one" in block size difference. Take a backup of what you do have before going further (so you won't be any worse off). Is this production? File a service request. If it is a bang-around database, you can say goodbye to the tablespace.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2016 Invision Power Services, Inc.