Day: July 2, 2021

File ID for temp data files

When you see the following message in the alert log, ever wonder how the file number for a temp data file could be 2050 as I was? ORA-63999: data file suffered media failure ORA-01114: IO error writing block to file 2050 (block # 322176) ORA-01110: data file 2050: '/dbase/PROD/temp2.dbf' ORA-27072: File I/O error Linux-x86_64 Error: … Continue reading File ID for temp data files