TEMP表空间报ORA-1652的处理
一个库收到这个报错，检查文件系统100%了，清除后仍然报这个错，原来在文件系统满后oracle把临时表空间文件offline，以下是处理日志：
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Fri Apr 12 16:01:21 2013
alter database tempfile '/opt/oracle/oradata/oracle/temp01.dbf' online
Fri Apr 12 16:01:21 2013
Completed: alter database tempfile '/opt/oracle/oradata/oracl
Fri Apr 12 16:06:32 2013
Thread 1 advanced to log sequence 13096
Current log# 3 seq# 13096 mem# 0: /opt/oracle/oradata/oracle/redo03.log
Fri Apr 12 16:06:46 2013
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Fri Apr 12 16:01:21 2013
alter database tempfile '/opt/oracle/oradata/oracle/temp01.dbf' online
Fri Apr 12 16:01:21 2013
Completed: alter database tempfile '/opt/oracle/oradata/oracl
Fri Apr 12 16:06:32 2013
Thread 1 advanced to log sequence 13096
Current log# 3 seq# 13096 mem# 0: /opt/oracle/oradata/oracle/redo03.log
Fri Apr 12 16:06:46 2013
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26870952/viewspace-758478/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
