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

oracle数据库出现意外宕机，启动数据库，发现alert日志出现以下报错：

Errors in file /oracle/admin/source/bdump/source_j001_17196.trc:

ORA-25153: Temporary Tablespace is Empty

Sat Aug 18 00:59:59 2012

Errors in file /oracle/admin/source/bdump/source_j001_17196.trc:

ORA-12012: error on auto execute of job 45

ORA-25153: Temporary Tablespace is Empty

ORA-06512: at "FMISMAIN.QUEST_PPCM_BOTTLENECK", line 52

ORA-06512: at "FMISMAIN.QUEST_PPCM_BOTTLENECK", line 161

ORA-06512: at "FMISMAIN.QUEST_PPCM_BOTTLENECK", line 565

ORA-06512: at line 1

Sat Aug 18 01:00:12 2012

Shutting down archive processes

Sat Aug 18 01:00:17 2012

ARCH shutting down

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

错误解决。

temp file 掉了还是比较容易恢复的，毕竟tempfile里没有重要的事物信息。