Skip to main content
general formatting
Source Link
atokpas
  • 8.7k
  • 1
  • 18
  • 27

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 

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 

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 

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

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 

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

general formatting and added oracle tag
Source Link
atokpas
  • 8.7k
  • 1
  • 18
  • 27

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

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 

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

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 
Source Link
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