Restoration case where the data file size of Windows oracle is 0

Except for the reprinted content, this article is original site: reposted from lovewifelovelife-Roger's Oracle technology blog link: when the data file size of windows oracle is 0, a netizen's database is deployed in windows, which may be due to storage problems or windows file system problems, causing IO problems.

Except for the reprinted content, this article is original site: reposted from the Oracle technology blog of love wife love life-Roger. Link: when the data file size in windows Oracle is 0, a netizen's database is deployed in windows, which may be due to storage problems or windows file system problems, causing IO problems.

In addition to the reposted content, this site is original:Reposted from the Oracle technology blog of love wife & love life-Roger

Link:Windows Oracle Data File Size 0 recovery case

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 fileOSD-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 \ iney ey. ams], [21], [1], [], [], [], [], [], [], [], [] ORA-48102: encountered the end-of-file when reading the fileOSD-04026: the parameter passed 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 \ iney ey. ams], [22], [1], [], [], [], [], [], [], [], [] ORA-48102: encountered the end-of-file when reading the fileOSD-04026: the parameter passed 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 \ iney ey. ams], [25], [1], [], [], [], [], [], [], [], [] ORA-48102: encountered the end-of-file when reading the fileOSD-04026: the parameter passed 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_i926 44. 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): ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams], [1 9], [1], [], [], [], [], [], [], [], [] ORA-48102: encountered the end-of-file when reading the fileOSD-04026: the parameter passed 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.trcErrors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_6008.trc (incident = 92873): 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 fileOSD-04026: the parameter passed 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.trcSuccessful mount of redo thread 1, with mount id 1391358302 Trace dumping is running Ming id = [cdmp_201411143618] Database mounted in Exclusive ModeLost write protection disabledTrace dumping is running Ming id = [cdmp_20141114143619] Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_6008.trc (inc Ident = 92874): 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 fileOSD-04026: the parameter passed is invalid. O/S-Error: (OS 20) the system cannot find the specified device. The 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 fileOSD-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 \ metadata: alter database MOUNTFri Nov 14 14:36:20 2014 alter database OPENRead of datafile 'd: \ ORACLE \ ORADATA \ ORCL \ ZL9BASEITEM. dbf' (fno 6) header failed with ORA-01200Rereading datafile 6 header failed with ORA-01200Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_ora_2876.trc: ORA-01122: Database Parts 6 Verification Failed ORA-01110: data file 6: 'd: \ ORACLE \ ORADATA \ ORCL \ ZL9BASEITEM. DBF 'ora-01200: 10240 actual file size less than 44800 blocks 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): ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDEN T. ams], [19], [1], [], [], [], [], [], [], [], [] ORA-48102: encountered the end-of-file when reading the fileOSD-04026: the parameter passed 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 fileOSD-04026: the parameter passed is invalid. O/S-Error: (OS 20) the system cannot find the specified device. The 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 fileOSD-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.trcFri 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 fileOSD-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 \ mongodumping is using Ming id = [cdmp_201411143622] Errors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_6008.trc (incident = 92876): ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d: \ oracle \ diag \ rdbms \ orcl \ metadata \ INCIDENT. ams], [19], [1], [], [], [], [], [], [], [], [] ORA-4810 2: encountered the end-of-file when reading the fileOSD-04026: the passed parameter is invalid. O/S-Error: (OS 20) the system cannot find the specified device. The 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 fileOSD-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): 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 fileOSD-04026: the parameter passed 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 \ iney ey. ams], [25], [1], [], [], [], [], [], [], [], [] ORA-48102: encountered the end-of-file when reading the fileOSD-04026: the parameter passed 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 fileOSD-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 failedORA-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): 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 fileOSD-04026: the parameter passed is invalid. O/S-Error: (OS 20) the system cannot find the specified device. Incident details in: d: \ oracle \ diag \ rdbms \ orcl \ incident \ incdir_0000895 \ orcl_m000_3144_i1_895.trcsuccessful mount of redo thread 1, with mount id 1391370839 Database mounted in Exclusive ModeLost write protection disabledCompleted: alter database mount exclusivealter database openErrors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_dbw0_2808.trc: ORA-01157: cannot identify/lock data file 8- See DBWR trace fileORA-01110: data file 8: 'd: \ ORACLE \ ORADATA \ ORCL \ ZL9EXPENSE. DBF 'ora-27047: unable to read the header block of fileOSD-04006: ReadFile () failed to read file O/S-Error: (OS 38) 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 fileORA-01110: data file 13: 'd: \ ORACLE \ ORADATA \ ORCL \ ZL9EPRDAT. DBF 'ora-27047: unable to read the header block of fileOSD-04006: ReadFile () failed to read file O/S-Error: (OS 38) 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 fileORA-01110: data file 15: 'd: \ ORACLE \ ORADATA \ ORCL \ ZL9INDEXHIS. DBF 'ora-27047: unable to read the header block of fileOSD-04006: ReadFile () failed to read file O/S-Error: (OS 38) 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 fileORA-01110: data file 16: 'd: \ ORACLE \ ORADATA \ ORCL \ ZL9INDEXCIS. DBF 'ora-27047: unable to read the header block of fileOSD-04006: ReadFile () failed to read file O/S-Error: (OS 38) reached the end of the file. Read of datafile 'd: \ ORACLE \ ORADATA \ ORCL \ ZL9BASEITEM. dbf' (fno 6) header failed with ORA-01200Rereading datafile 6 header failed with ORA-01200Errors 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 fileOSD-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.trcerrors in file d: \ oracle \ diag \ rdbms \ orcl \ trace \ orcl_m000_3144.trc (incident = 108896): 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 f IleOSD-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 fileORA-01110: data file 8: 'd: \ ORACLE \ ORADATA \ ORCL \ ZL9EXPENSE. DBF 'ora-27047: unable to read the header block of fileOSD-04006: ReadFile () failed to read file O/S-Error: (OS 38) 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.

Related posts:

1. A remote-assisted recovery encounters an abnormal event
2. Several minor problems encountered during recent migration recovery
3. One recover case!
4. Case study of 11gR2 slave uard backup database file corruption
5. Database open error ORA-01555: snapshot too old