ORA-25153: 临时表空间为空

Alert日志告警

 Wed Mar 16 00:00:30 EAT 2011
Errors in file /oracle/app/oracle10g/admin/testsdh/bdump/testsdh_j003_9271.trc:
ORA-12012: 自动执行作业 7802 出错
ORA-25153: 临时表空间为空
ORA-06512: 在 "CQ.P_GIS_NM_ABILITY", line 4
ORA-06512: 在 line 1
Wed Mar 16 00:07:07 EAT 2011
Errors in file /oracle/app/oracle10g/admin/testsdh/bdump/testsdh_j000_9265.trc:
ORA-12012: error on auto execute of job 104
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_STATS", line 15188
ORA-06512: at "SYS.DBMS_STATS", line 15530
ORA-06512: at "SYS.DBMS_STATS", line 15608
ORA-06512: at "SYS.DBMS_STATS", line 15567

/oracle/app/oracle10g/admin/testsdh/bdump/testsdh_j003_9271.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /oracle/app/product/10.2.0

System name:    HP-UX

Node name:      cqrm2-2

Release:        B.11.31

Version:        U

Machine:        ia64

Instance name: testsdh

Redo thread mounted by this instance: 1

Oracle process number: 175

Unix process pid: 9271, image: oracle@cqrm2-2 (J003)

 

*** SERVICE NAME:(SYS$USERS) 2011-03-16 00:00:30.754

*** SESSION ID:(2024.81) 2011-03-16 00:00:30.754

*** 2011-03-16 00:00:30.754

ORA-12012: M-WM-TM-6M-/M-VM-4M-PM-PM-WM-wM-RM-5 7802 M-3M-vM-4M-m

ORA-25153: M-AM-YM-JM-1M-1M-mM-?M-UM-

ORA-06512: M-TM-Z "CQ.P_GIS_NM_ABILITY", line 4

ORA-06512: M-TM-Z line 1

这个问题是temp表空间未添加文件造成的，因为这个库是才做了rman恢复的，rman恢复是不会吧temp文件恢复回来的，所以我们做了rman全库恢复后需要增加temp文件。

 

alter tablespace temp add tempfile '/dev/vgora/rlvsdhtemp1' size 2000m;

 

添加成功后系统不再报错

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11088128/viewspace-689565/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11088128/viewspace-689565/