Example of restoring Oracle data file size to 0 in windows

A netizen's database is deployed in a windows environment. It may be due to storage problems or windows file system problems. After I/O problems occur, the database cannot be started after it is restarted, when an error is reported, several files cannot be read. The alert log is as follows:

Nov 14 12:33:12 2014
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m0000001704.trc (incident = 60577 ):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INC_METER_INFO.ams], [16], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 17) the system cannot move files to different disk drives.
......
......
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_4676.trc (incident = 92621 ):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ in1_ey. ams], [21], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 22) the device does not recognize this command.
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_4676.trc (incident = 92622 ):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ in1_ey. ams], [22], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 23) data Error (cyclic redundancy check ).
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_4676.trc (incident = 92623 ):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ in1_ey. ams], [25], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 26) the specified disk or floppy disk cannot be accessed.
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_4676.trc (incident = 92624 ):
..........
 
ORA-00600: internal error code, arguments: [17182], [0x00DCD3560], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17147], [0x00DCD3560], [], [], [], [], [], [], [], [], []
Incident details in: d: \ oracle \ diag \ rdbms \ orcl \ incident \ incdir_92644 \ orcl_m000_3176_i92644.trc.
........
Starting up:
Oracle Database 11g Release 11.2.0.1.0-64bit Production.
Using parameter settings in server-side spfile D: \ ORACLE \ PRODUCT \ 11.2.0 \ DBHOME_1 \ DATABASE \ SPFILEORCL. ORA
........
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_6008.trc (incident = 92872 ):
The ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 20) the system cannot find the specified device.
Incident details in: d: \ oracle \ diag \ rdbms \ orcl \ incident \ incdir_92872 \ orcl_m000_6008_i92872.trc
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_6008.trc (incident = 92873 ):
The ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 20) the system cannot find the specified device.
The ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 20) the system cannot find the specified device.
Incident details in: d: \ oracle \ diag \ rdbms \ orcl \ incident \ incdir_92873 \ orcl_m000_6008_i92873.trc
Successful mount of redo thread 1, with mount id 1391358302
Trace dumping is refreshing Ming id = [cdmp_20141114143618]
Database mounted in Exclusive Mode
Lost write protection disabled
Trace dumping is refreshing Ming id = [cdmp_20141114143619]
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_6008.trc (incident = 92874 ):
The ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 20) the system cannot find the specified device.
ORA-48101: error encountered when attempting to read a file [block] [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams] [0]
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 20) the system cannot find the specified device.
Incident details in: d: \ oracle \ diag \ rdbms \ orcl \ incident \ incdir_92874 \ orcl_m000_6008_i92874.trc
Completed: ALTER DATABASE MOUNT
Fri Nov 14 14:36:20 2014
ALTER DATABASE OPEN
Read of datafile 'd: \ ORACLE \ ORADATA \ ORCL \ ZL9BASEITEM. Dbf' (fno 6) header failed with ORA-01200
Rereading datafile 6 header failed with ORA-01200
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_ora_2876.trc:
ORA-01122: database file 6 verification failed
ORA-01110: Data File 6: 'D: \ ORACLE \ ORADATA \ ORCL \ ZL9BASEITEM. DBF'
ORA-01200: 10240 actual file size less than 44800 correct size
ORA-1122 signalled during: alter database open...
Trace dumping is refreshing Ming id = [cdmp_20141114143621]
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_6008.trc (incident = 92875 ):
The ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 20) the system cannot find the specified device.
The ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 20) the system cannot find the specified device.
ORA-48101: error encountered when attempting to read a file [block] [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams] [0]
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 20) the system cannot find the specified device.
Incident details in: d: \ oracle \ diag \ rdbms \ orcl \ incident \ incdir_92875 \ orcl_m000_6008_i92875.trc
Fri Nov 14 14:36:21 2014
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m004255816.trc (incident = 92880 ):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ HM_RUN.ams], [26], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 27) the drive cannot find the requested sector.
Incident details in: d: \ oracle \ diag \ rdbms \ orcl \ incident \ incdir_92880 \ orcl_m004255816_i92880.trc
Trace dumping is refreshing Ming id = [cdmp_20141114143622]
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_6008.trc (incident = 92876 ):
The ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 20) the system cannot find the specified device.
ORA-48101: error encountered when attempting to read a file [block] [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams] [0]
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 20) the system cannot find the specified device.
Fri Nov 14 14:37:18 2014
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_5340.trc (incident = 92877 ):
The ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 20) the system cannot find the specified device.
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_5340.trc (incident = 92878 ):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ in1_ey. ams], [25], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 26) the specified disk or floppy disk cannot be accessed.
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_5340.trc (incident = 92879 ):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INC_METER_INFO.ams], [16], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 17) the system cannot move files to different disk drives.
.......
ORA-00600: internal error code, arguments: [17114], [0x010f000030], [], [], [], [], [], [], [], [], []
ORA-48312: Sweep incident 92687 staging file failed
ORA-00600: internal error code, arguments: [17182], [0x010f000030], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17147], [0x010f000030], [], [], [], [], [], [], [], [], []
Fri Nov 14 14:38:18 2014
..........
..........
Fri Nov 14 14:53:15 2014
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_3144.trc (incident = 108895 ):
The ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 20) the system cannot find the specified device.
Incident details in: d: \ oracle \ diag \ rdbms \ orcl \ incident \ incdir_1_895 \ orcl_m000_3144_i1_895.trc
Successful mount of redo thread 1, with mount id 1391370839
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
Alter database open
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_dbw0_2808.trc:
ORA-01157: cannot identify/lock data file 8-see DBWR trace file
ORA-01110: data file 8: 'D: \ ORACLE \ ORADATA \ ORCL \ ZL9EXPENSE. DBF'
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile () failed to read file
O/S-Error: (OS 38) has reached the end of the file.
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_dbw0_2808.trc:
ORA-01157: cannot identify/lock data file 13-see DBWR trace file
ORA-01110: data file 13: 'D: \ ORACLE \ ORADATA \ ORCL \ ZL9EPRDAT. DBF'
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile () failed to read file
O/S-Error: (OS 38) has reached the end of the file.
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_dbw0_2808.trc:
ORA-01157: cannot identify/lock data file 15-see DBWR trace file
ORA-01110: data file 15: 'D: \ ORACLE \ ORADATA \ ORCL \ ZL9INDEXHIS. DBF'
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile () failed to read file
O/S-Error: (OS 38) has reached the end of the file.
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_dbw0_2808.trc:
ORA-01157: cannot identify/lock data file 16-see DBWR trace file
ORA-01110: data file 16: 'D: \ ORACLE \ ORADATA \ ORCL \ ZL9INDEXCIS. DBF'
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile () failed to read file
O/S-Error: (OS 38) has reached the end of the file.
Read of datafile 'd: \ ORACLE \ ORADATA \ ORCL \ ZL9BASEITEM. Dbf' (fno 6) header failed with ORA-01200
Rereading datafile 6 header failed with ORA-01200
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_ora_3380.trc:
ORA-01122 :????? 6 ????
ORA-01110 :???? 6: 'D: \ ORACLE \ ORADATA \ ORCL \ ZL9BASEITEM. Dbf'
ORA-01200: 10240 ????????? 44800 ??????
ORA-1122 signalled during: alter database open...
Fri Nov 14 14:53:16 2014
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m001_3752.trc (incident = 108903 ):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ HM_RUN.ams], [26], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.
O/S-Error: (OS 27) the drive cannot find the requested sector.
Incident details in: d: \ oracle \ diag \ rdbms \ orcl \ incident \ incdir_0000903 \ orcl_m001_3752_i1_903.trc
Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_3144.trc (incident = 108896 ):
The ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: the passed parameter is invalid.

O/S-Error: (OS 20) the system cannot find the specified device.

We can see that Oracle started reporting ORA-00700, ORA-00600, and ORA-48102 errors before restarting. The error after restart is even more depressing, as shown below:

ORA-01157: cannot identify/lock data file 8-see DBWR trace file
ORA-01110: data file 8: 'D: \ ORACLE \ ORADATA \ ORCL \ ZL9EXPENSE. DBF'
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile () failed to read file
O/S-Error: (OS 38) has reached the end of the file.
Obviously, this is a file exception. From the operating system, we can see that the size of the four files is actually 0. This is obviously abnormal. In fact, I found that there are two other files,
It may be that the file header is damaged and an error is reported directly through dbv verification.
After the processing, the customer successfully helped the user to rescue the data. It is said that a core table lost a little data, but the loss was not big.
Windows is not recommended for Oracle running. It is always difficult to solve some inexplicable problems. Also, the database must be archived and regularly backed up physically. Otherwise
Once a fault occurs, it is disastrous.