ORA-01251: Unknown File Header Version read for file number 7

           今天在公司幫開發部門開啟一個測試庫，到open狀態時，報以下錯誤：

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01122: database file 6failed verification check
ORA-01110: data file 6: '/u02/oradata/crmdb/test01.dbf'
ORA-01251: Unknown File Header Version read for file number 6

提示資料檔案6的檔案頭資訊已經損壞，不能正確讀取

分三種情況恢復：

第一.非歸檔模式 則會丟失這個表空間下的所有資料

fix:

Drop the datafile and the associated tablespace.
1. Connect to the database as a user with SYSDBA privileges.
SVRMGRL>connect sys/ as SYSDBA;
2. Mount the database.
SVRMGRL>startup mount;
3. Drop the datafile specified in the error message.
SVRGMRL>alter database datafile '' offline drop;
4. Open the database.
SVRMGRL>alter database open;
5. Drop the tablespace associated with the datafile.
SVRMGRL>drop tablespace '' including contents;

第二.歸檔模式，並且建立這個資料檔案以來的歸檔日誌都在

1. The database needs to be in Archive log mode.
2. You need to have all the Archive log file from the time the datafile was created .
3. The control file should have datafile created information.If the controlfile was re-created
    after the datafile was created then the below solution will not work and step 2 will
    error with ORA-01178

Steps to be followed
====================

Step1 :-

Take the problematic datafile offline.

SQL> Alter database datafile  '/oracle/test_lob12.dbf' offline;

Copy the file to an alternate backup location.

Step 2:-

Issue the following command to re-create the file :

SQL> Alter database create datafile   '/oracle/test_lob12.dbf';

Step 3:-

Start applying the archive log file to recreate datafile.

SQL> Recover  datafile  '/oracle/test_lob12.dbf';

Step 4:-

 

When the recovery is finished, bring the datafile online.

SQL> Alter database datafile '/oracle/test_lob12.dbf' online;

3.用dul工具直接提取資料檔案中的資料

    這個提取資料難度就有點高。