file /oracle/admin/test1/diag/rdbms/test/test1/trace/test1_dbw0_5435.trc:
ORA-01157: cannot identify/lock data file 190 - see DBWR trace file
ORA-01110: data file 190: '/dev/mapper/oratest_data_001_8600Mp7'
ORA-27048: skgfifi: file header information is invalid
Additional information: 19
Errors in
Above oracle error found due to below possible reasons.
- Multipath issue or storage issues , to fix involve system admin to debug more. also try to check if any errors exists in /var/log/messages
- dmesg /var/log/messages.
- select FILE# , status , error from v$datafile_header where ERROR IS NOT NULL
FILE# STATUS ERROR
---------- ------- ----------------------------------------
1 ONLINE WRONG DATABASE
57 ONLINE WRONG DATABASE
190 ONLINE FILE NOT FOUND
216 ONLINE FILE NOT FOUND
324 ONLINE WRONG DATABASE
464 ONLINE FILE NOT FOUND - most of the times after fixings issues from SA , DBA team face above error. follow below steps to fix. startup mount
- alter system check datafiles;
- alter database open.
- still issue exists we can check SA might have formatted the LUNS mistakenly.
