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
- Log in to post comments
- 19793 views