首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > 其他数据库 >

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

2013-12-26 
没有执行drop操作，手动删除了无用DBF文件后，导致无法启动ORCL前言：数据库没有执行drop某个表空间，手动删除

没有执行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. 数据库已经打开。 ?

读书人精选
热点排行