Skip to main content
1 of 3
ARS
  • 13
  • 1
  • 1
  • 3

ORA-01122: database file 5 failed verification check

Oracle version: 11g r2
OS: win server 2008

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01122: database file 5 failed verification check
ORA-01110: data file 5: '[file_path]'
ORA-01210: data file header is media corrupt

SQL> alter database datafile '[file_path]' offline;
alter database datafile '[file_path]' offline
*
ERROR at line 1:
ORA-01145: offline immediate disallowed unless media recovery enabled

SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 8231
Current log sequence 8235

SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 2.7392E+10 bytes
Fixed Size 2188768 bytes
Variable Size 1.5032E+10 bytes
Database Buffers 1.2348E+10 bytes
Redo Buffers 9183232 bytes
Database mounted.

SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 5: '[file_path]'
ORA-01122: database file 5 failed verification check
ORA-01110: data file 5: '[file_path]'
ORA-01210: data file header is media corrupt

ARS
  • 13
  • 1
  • 1
  • 3