没有执行drop操作，手动删除了无用DBF文件后，导致无法启动ORCL

前言：数据库没有执行drop某个表空间，手动删除dmp文件，导致无法正常启动orcl

?

解决思路，删除文件了里相关的dmp关联。

解决过程如下

1. Microsoft?Windows?[版本?6.1.7600]??
2. 版权所有?(c)?2009?Microsoft?Corporation。保留所有权利。??
3. ??
4. C:\Users\守望幸福>?set??oracle_sid=orcl??
5. ??
6. C:\Users\守望幸福>sqlplus??"/as?sysdba"???
7. SQL*Plus:?Release?10.2.0.1.0?-?Production??on??星期三?12月?19?09:55:54?2012 ?
8. Copyright?(c)?1982,?2005,?Oracle.???All??rights?reserved. ?
9. ??
10. 连接到:??
11. Oracle??Database??10g?Enterprise?Edition?Release?10.2.0.1.0?-?Production??
12. With??the?Partitioning,?OLAP??and??Data?Mining?options??
13. ??
14. SQL>?shutdown?immediate??
15. ORA-01109:?数据库未打开 ?
16. 已经卸载数据库。??
17. ORACLE?例程已经关闭。??
18. SQL>?startup??
19. ORACLE?例程已经启动。??
20. ??
21. Total?System??Global??Area??612368384?bytes??
22. Fixed??Size???????????????????1250428?bytes??
23. Variable??Size??????????????243272580?bytes??
24. Database??Buffers??????????360710144?bytes??
25. Redo?Buffers????????????????7135232?bytes??
26. 数据库装载完毕。??
27. ORA-01157:?无法标识/锁定数据文件?8?-?请参阅?DBWR?跟踪文件??
28. ORA-01110:?数据文件?8:??'D:\TBS01.DBF'???
29. SQL>?startup??
30. ORA-01081:?无法启动已在运行的?ORACLE?-?请首先关闭它??
31. SQL>?shutdown?immediate??
32. ORA-01109:?数据库未打开 ?
33. ??
34. 已经卸载数据库。??
35. ORACLE?例程已经关闭。??
36. SQL>?startup??
37. ORACLE?例程已经启动。??
38. ??
39. Total?System??Global??Area??612368384?bytes??
40. Fixed??Size???????????????????1250428?bytes??
41. Variable??Size??????????????243272580?bytes??
42. Database??Buffers??????????360710144?bytes??
43. Redo?Buffers????????????????7135232?bytes??
44. 数据库装载完毕。??
45. ORA-01157:?无法标识/锁定数据文件?8?-?请参阅?DBWR?跟踪文件??
46. ORA-01110:?数据文件?8:??'D:\TBS01.DBF'???
47. ??
48. SQL>?SHUTDOWN?IMMEDIATE??
49. ORA-01109:?数据库未打开??
50. ?
51. 已经卸载数据库。??
52. ORACLE?例程已经关闭。??
53. SQL>?startup??
54. ORACLE?例程已经启动。??
55. ??
56. Total?System??Global??Area??612368384?bytes??
57. Fixed??Size???????????????????1250428?bytes??
58. Variable??Size??????????????243272580?bytes??
59. Database??Buffers??????????360710144?bytes??
60. Redo?Buffers????????????????7135232?bytes??
61. 数据库装载完毕。??
62. ORA-01157:?无法标识/锁定数据文件?8?-?请参阅?DBWR?跟踪文件??
63. ORA-01110:?数据文件?8:??'D:\TBS01.DBF'???
64. ?
65. SQL>?recover?datafile??'d:\TBS01.DBF'???
66. ORA-00283:?恢复会话因错误而取消??
67. ORA-01110:?数据文件?8:??'D:\TBS01.DBF'???
68. ORA-01157:?无法标识/锁定数据文件?8?-?请参阅?DBWR?跟踪文件??
69. ORA-01110:?数据文件?8:??'D:\TBS01.DBF'???
70. ?
71. SQL>??select???name???from??v$datafile;??
72. ??
73. NAME???
74. -------------------------------------------------------------------------------???
75. ??
76. D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF??
77. D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF??
78. D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF??
79. D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF??
80. D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\MYSPACE.DBF??
81. D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DZYX.DBF??
82. D:\ORACLE\PRODUCT\10.2.0\ORADATA\JYLSXT.DBF??
83. D:\TBS01.DBF??
84. D:\TBS02.DBF??
85. D:\TBS03.DBF??
86. D:\TBS04.DBF??
87. ??
88. 已选择11行。??
89. ??
90. SQL>??alter???database??datafile?6?offline;??
91. alter???database??datafile?6?offline??
92. *??
93. 第?1?行出现错误:??
94. ORA-01145:?除非启用了介质恢复,?否则不允许立即脱机 ?
95. ??
96. SQL>??ALTER???DATABASE??DATAFILE??'D:\GH_01.DBF'??OFFLINE??DROP?;??
97. ALTER???DATABASE??DATAFILE??'D:\GH_01.DBF'??OFFLINE??DROP???
98. *??
99. 第?1?行出现错误:??
100. ORA-01516:?不存在的日志文件,?数据文件或临时文件??"D:\GH_01.DBF"???
101. ?
102. SQL>??alter???database??datafile??'D:\TBS01.DBF'?OFFLINE??DROP?; ?
103. 数据库已更改。??
104. ??
105. SQL>?shutdown?immediate;??
106. ORA-01109:?数据库未打开??
107. ??
108. ??
109. 已经卸载数据库。??
110. ORACLE?例程已经关闭。??
111. SQL>?startup??
112. ORACLE?例程已经启动。??
113. ??
114. Total?System??Global??Area??612368384?bytes??
115. Fixed??Size???????????????????1250428?bytes??
116. Variable??Size??????????????243272580?bytes??
117. Database??Buffers??????????360710144?bytes??
118. Redo?Buffers????????????????7135232?bytes??
119. 数据库装载完毕。??
120. ORA-01157:?无法标识/锁定数据文件?9?-?请参阅?DBWR?跟踪文件??
121. ORA-01110:?数据文件?9:??'D:\TBS02.DBF'???
122. ?
123. SQL>???alter???database??datafile??'D:\TBS02.DBF'?OFFLINE??DROP?;??
124. ??
125. 数据库已更改。??
126. ??
127. SQL>???alter???database??datafile??'D:\TBS03.DBF'?OFFLINE??DROP?;??
128. ??
129. 数据库已更改。??
130. ??
131. SQL>???alter???database??datafile??'D:\TBS04.DBF'?OFFLINE??DROP?;??
132. ??
133. 数据库已更改。??
134. ??
135. SQL>?shutdown?immediate;??
136. ORA-01109:?数据库未打开??
137. ?
138. 已经卸载数据库。??
139. ORACLE?例程已经关闭。??
140. SQL>?startup??
141. ORACLE?例程已经启动。??
142. ??
143. Total?System??Global??Area??612368384?bytes??
144. Fixed??Size???????????????????1250428?bytes??
145. Variable??Size??????????????243272580?bytes??
146. Database??Buffers??????????360710144?bytes??
147. Redo?Buffers????????????????7135232?bytes??
148. 数据库装载完毕。??
149. 数据库已经打开。 ?