Operating System - HP-UX
1748209 Members
2715 Online
108759 Solutions
New Discussion юеВ

Re: file size is not a multiple of logical block size

 
Sushil Singh_1
Advisor

file size is not a multiple of logical block size

Hi all,
We I try to open the ORACLE 8.1.7.3 database, I get the following error.


ORA-01110: data file 1: '/u03/oradata/asmsdb/system01.dbf'
ORA-27046: file size is not a multiple of logical block size

DB_BLOCK_SIZE is 8192

Please help

Thanks
3 REPLIES 3
A. Clay Stephenson
Acclaimed Contributor

Re: file size is not a multiple of logical block size

Well, the first question is: Is it? Do an ls -l /u03/oradata/asmsdb/system01.dbf; it's possible that the file has been corruptted by someone appending to it or other commands.

If it ain't broke, I can fix that.
A. Clay Stephenson
Acclaimed Contributor

Re: file size is not a multiple of logical block size

By any chance, did you change the db_block_size paramter in init.ora?
If it ain't broke, I can fix that.
Wodisch_1
Honored Contributor

Re: file size is not a multiple of logical block size

Hi Sushil,

verify in your ALERT.LOG, that the DB_BLOCK_SIZE in your "init*ora" is really still the same as it was last time the instance was successfully started. A simple "grep -i db_block_size" onto your ALERT.LOG should be sufficient.
If both are the same, then somebody damaged your datafile - restore from your backup, then.
If they are different, then somebody damaged your "init*ora" file - use the value from the ALERT.LOG, then.

HTH,
Wodisch