恢复一例(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>

oracle9i回滚段表空间丢失后的处理方法:

用隐含参数恢复数据库的例子：

具体操作步骤如下：

首先把初init.ora文件里自动管理改为手工管理,然后加入隐含参数:
#undo_management=AUTO
undo_tablespace=UNDOTBS
_corrupted_rollback_segments=(_SYSSMU1$,_SYSSMU2$,_SYSSMU3$,_SYSSMU4$,_SYSSMU5$,_SYSSMU6$,_SYSSMU7$,_SYSSMU8$,_SYSSMU9$,_SYSSMU10$)  

SQL>startupmount （数据库启动到mount状态)
SQL>alterdatabasedatafile'D:/ORACLE/ORADATA/ORCL/UNDOTBS01.DBF'offlinedrop；
Databasealtered.

SQL>alterdatabaseopen;
Databaseopened.
SQL>showparameterundo

NAMETYPEVALUE
--------------------------------------------------------
undo_managementstringMANUAL
undo_retentioninteger900
undo_suppress_errorsbooleanFALSE
undo_tablespacestringUNDOTBS

SQL>droptablespaceundotbsincludingcontents;
Tablespacedropped.

重建undotbs表空间:
SQL>createundotablespaceundotbsdatafile'D:/ORACLE/ORADATA/ORCL/UNDOTBS01.DBF'
size100M;
Tablespacecreated.

SQL>shutdownimmediate (关闭数据库)
Databaseclosed.
Databasedismounted.
ORACLEinstanceshutdown.

编辑init.ora初始化参数文件,去掉隐含参数，设置
undo_management=AUTO
undo_tablespace=UNDOTBS
保存init.ora文件，然后执行
SQL>startupmount
ORACLEinstancemounted.
TotalSystemGlobalArea114061244bytes
FixedSize282556bytes
VariableSize79691776bytes
DatabaseBuffers33554432bytes
RedoBuffers532480bytes
Databasemounted.

SQL>alterdatabasedatafile'D:/ORACLE/ORADATA/ORCL/UNDOTBS01.DBF'online;
Databasealtered.

SQL>alterdatabaseopen;
Databaseopened.
SQL>showparameterundo

NAMETYPEVALUE
-----------------------------------------------------------------------------
undo_managementstringAUTO
undo_retentioninteger900
undo_suppress_errorsbooleanFALSE
undo_tablespacestringUNDOTBS

<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>