数据文件丢失之后的恢复

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

 SQL>startup
ORACLEinstancestarted.

TotalSystemGlobalArea  73109664bytes
FixedSize              73888bytes
VariableSize          56086528bytes
DatabaseBuffers        16777216bytes
RedoBuffers            172032bytes
Databasemounted.
ORA-03113:end-of-fileoncommunicationchannel



我的环境是linux9oracle8.1.7.4
出现问题的当时是，一台机器连到上面做insertinto操作，数据大概有63万条。
正在执行的过程中因为到了下班的时间，服务器设置的定时自动关机的功能，服务器
在五点半的时候关机，导致insertinto操作中断，等服务器起来之后，提示一个表数据文件有问题，我就执行了
shutdownimmediate
startupmount
recoverdatafile'/datafile.dbf'
提示 恢复成功
startup
就出现上面的错误提示

 终于搞定了，采取的步骤是把，受到影响的表空间何数据文件drop掉
SQL>startup
ORACLEinstancestarted.

TotalSystemGlobalArea  73109664bytes
FixedSize              73888bytes
VariableSize          56086528bytes
DatabaseBuffers        16777216bytes
RedoBuffers            172032bytes
Databasemounted.
ORA-03113:end-of-fileoncommunicationchannel


SQL>connsystem/managerassysdba
Connected.
SQL>selectnamefromdatafiles
  2  ;
selectnamefromdatafiles
            *
ERRORatline1:
ORA-01219:databasenotopen:queriesallowedonfixedtables/viewsonly


SQL>selectnamefromv$datafile
  2  ;

NAME
--------------------------------------------------------------------------------
/u01/oradata/EMCDB/system01.dbf
/u01/oradata/EMCDB/tools01.dbf
/u01/oradata/EMCDB/rbs01.dbf
/u01/oradata/EMCDB/temp01.dbf
/u01/oradata/EMCDB/users01.dbf
/u01/oradata/EMCDB/indx01.dbf
/u01/oradata/EMCDB/drsys01.dbf
/u01/oradata/EMCDB/EMCBASE.dbf
/home/oracle/test.dbf
/home/adonis/dwbx_wmstat.dbf
//home/adonis/iwbx_wmindx.dbf

11rowsselected.

SQL>alterdatabasedatafile'//home/adonis/iwbx_wmindx.dbf'offline
  2  ;
alterdatabasedatafile'//home/adonis/iwbx_wmindx.dbf'offline
*
ERRORatline1:
ORA-01145:offlineimmediatedisallowedunlessmediarecoveryenabled


SQL>alterdatabasedatafile'//home/adonis/iwbx_wmindx.dbf'offlinedrop;

Databasealtered.

SQL>alterdatabasedatafile'/home/adonis/dwbx_wmstat.dbf'offlinedrop;

Databasealtered.

SQL>alterdatabaseopen;
alterdatabaseopen
*
ERRORatline1:
ORA-03113:end-of-fileoncommunicationchannel


SQL>selectnamefromv$tablespace;
selectnamefromv$tablespace
*
ERRORatline1:
ORA-03114:notconnectedtoORACLE


SQL>connectsystem/managerassysdba;
Connected.
SQL>  selectnamefromv$tablespace; 1 <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>