Due to ORA-63999, Disk Failure
Normally, files that store in disk array are pretty safe, but not 100% safe. For example, 2 disks out of a RAID 5 group will make you lose files. Let's see what happen when we lost only one data file.
Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ckpt_1757.trc:
ORA-63999: data file suffered media failure
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/u01/app/oracle/oradata/ORCL/example01.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ckpt_1757.trc (incident=20161):
ORA-63999 [] [] [] [] [] [] [] [] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/ORCL/incident/incdir_20161/ORCL_ckpt_1757_i20161.trc
Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_mz00_2331.trc:
ORA-01110: data file 5: '/u01/app/oracle/oradata/ORCL/example01.dbf'
ORA-01565: error in identifying file '/u01/app/oracle/oradata/ORCL/example01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
USER (ospid: ): terminating the instance due to ORA errorAs we can see, some processes tried to write or verify a data file but they failed to do that. So the instance decided to shutdown itself immediately.