oracle数据库意外宕机启动后报错:ORA-25153: Temporary Tablespace is Empty

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:224

oracle数据库出现意外宕机,启动数据库,发现alert日志出现以下报错:
Errors in file /oracle/admin/source/bdump/source_j001_17196.trc:ORA-25153: Temporary Tablespace is EmptySat Aug 18 00:59:59 2012Errors in file /oracle/admin/source/bdump/source_j001_17196.trc:ORA-12012: error on auto execute of job 45ORA-25153: Temporary Tablespace is EmptyORA-06512: at "FMISMAIN.QUEST_PPCM_BOTTLENECK", line 52ORA-06512: at "FMISMAIN.QUEST_PPCM_BOTTLENECK", line 161ORA-06512: at "FMISMAIN.QUEST_PPCM_BOTTLENECK", line 565ORA-06512: at line 1Sat Aug 18 01:00:12 2012Shutting down archive processesSat Aug 18 01:00:17 2012ARCH shutting downARC2: Archival stopped检查临时文件,居然不存在,估计是意外宕机丢失了。SQL> select tablespace_name,file_name from dba_temp_files;no rows selected接下来手工增加数据文件:SQL> alter tablespace temp add tempfile '/oracle/oradata/source/temp.dbf';Tablespace altered.SQL> select tablespace_name,file_name from dba_temp_files;TABLESPACE_NAME------------------------------FILE_NAME--------------------------------------------------------------------------------TEMP/oracle/oradata/source/temp.dbf错误解决。

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】