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错误解决。