Oraclelearner
Jun 26 2008, 06:17 PM
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
SteveC
Jun 26 2008, 06:33 PM
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.