数据文件丢失之后的恢复

<script type="text/javascript"><!-- google_ad_client = "pub-2947489232296736"; /* 728x15, 创建于 08-4-23MSDN */ google_ad_slot = "3624277373"; google_ad_width = 728; google_ad_height = 15; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript"><!-- google_ad_client = "pub-2947489232296736"; /* 160x600, 创建于 08-4-23MSDN */ google_ad_slot = "4367022601"; google_ad_width = 160; google_ad_height = 600; //--> </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"><!-- google_ad_client = "pub-2947489232296736"; /* 728x15, 创建于 08-4-23MSDN */ google_ad_slot = "3624277373"; google_ad_width = 728; google_ad_height = 15; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript"><!-- google_ad_client = "pub-2947489232296736"; /* 160x600, 创建于 08-4-23MSDN */ google_ad_slot = "4367022601"; google_ad_width = 160; google_ad_height = 600; //--> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
阅读更多
文章标签: 服务器 oracle linux
个人分类: 数据库
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭