Oracle: dbfsize Header block magic number is bad

root's picture

Hello,

Firstly, have you know that this error should not give any problems for Oracle itself (even on start) nor to RMAN operations.

So, without blabbing more, we have this error on dbfsize command:

$ dbfsize system01.dbf
system01.dbf: Header block magic number is bad; trying raw file format...
system01.dbf: Header block magic number is bad

To double check it and be sure the file is ok, you can verify it with dbv:

$ dbv FILE=system01.dbf

DBVERIFY: Release 10.2.0.4.0 - Production on Tue Feb 26 16:37:02 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

DBVERIFY - Verification starting : FILE = system01.dbf


DBVERIFY - Verification complete

Total Pages Examined         : 140800
Total Pages Processed (Data) : 79455
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 35549
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 380
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 25416
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Highest block SCN            : 1198910981 (1.1198910981)

Solution:

The correction is simple and can be done with the RESIZE command within Oracle:

ALTER DATABASE DATAFILE '/oracle/DBPROD/system/system01.dbf' RESIZE 1100M;

Now you should have the correct output:
$ dbfsize system01.dbf
Database file: system01.dbf
Database file type: file system
Database file size: 140800 8192 byte blocks

Thou shalt not steal!

If you want to use this information on your own website, please remember: by doing copy/paste entirely it is always stealing and you should be ashamed of yourself! Have at least the decency to create your own text and comments and run the commands on your own servers and provide your output, not what I did!

Or at least link back to this website.

Recent content