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

来源：互联网发布：网络平面设计课程编辑：程序博客网时间：2024/06/06 00:49

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

RMAN retention policy will be applied to the commandRMAN retention policy is set to recovery window of 30 daysreleased channel: c1released channel: c2released channel: c3released channel: c4released channel: c5released channel: c6RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of delete command at 09/06/2017 05:05:49RMAN-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 NOemp01.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 NOemp01.dbf/u01/app/oracle/oradata/jhim/t YESemp02.dbf

阅读全文

0 0