ORA-01652:unable to extend temp segment by 128 in tablespace TEMPTS1

最新推荐文章于 2021-10-22 17:29:47 发布

返璞归真素闲人

最新推荐文章于 2021-10-22 17:29:47 发布

阅读量1k

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/a743044559/article/details/77885332

版权

oracle 专栏收录该内容

103 篇文章 2 订阅

订阅专栏

最近使用rman catalog 备份数据报了一个错误，由于temp临时表空间太小，造成分配segment失败，这里需要重建临时表空间，并设置自动扩展。

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 30 days
released channel: c1
released channel: c2
released channel: c3
released channel: c4
released channel: c5
released channel: c6
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 09/06/2017 05:05:49
RMAN-06004: ORACLE error from recovery catalog database: ORA-01652: unable to extend temp segment by 128 in tablespace TEMPTS1

由于系统默认临时表空间出错，所以需要先创建一个临时表空间，在设置为系统默认临时表空间，在把原来的临时表空间删除。

SQL> select file_name,autoextensible from dba_temp_files;

FILE_NAME                      AUT
------------------------------ ---
/u01/app/oracle/oradata/jhim/t NO
emp01.dbf

可知，临时表文件非自动扩展

创建临时表空间，切换为系统默认临时表空间，阐述旧的临时表空

SQL> create temporary tablespace  TEMPTS2 tempfile '/u01/app/oracle/oradata/jhim/temp02.dbf' size 10m reuse autoextend on;

Tablespace created.

SQL> alter database  default temporary tablespace TEMPTS2;

Database altered.
SQL> select file_name,autoextensible from dba_temp_files;

FILE_NAME                      AUT
------------------------------ ---
/u01/app/oracle/oradata/jhim/t NO
emp01.dbf

/u01/app/oracle/oradata/jhim/t YES
emp02.dbf