ORA-01652 And RMAN-08132 During Backup (Doc ID 2762263.1)

In this Document

Symptoms

Cause

Solution

References

---

 

APPLIES TO:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

SYMPTOMS

A recurring archiver error if found and backup takes a long time to archive the archive log.
The folowing error observed in the rman backup log:

Starting Control File and SPFILE Autobackup at 24-JAN-21
piece handle=c-4xxxxxxx5-2xxxxxxxx-xx comment=API Version 2.0,MMS Version 18.2.0.0
Finished Control File and SPFILE Autobackup at 24-JAN-21
starting full resync of recovery catalog
full resync complete
ORA-00604: error occurred at recursive SQL level 1
ORA-01652: unable to extend temp segment by 64 in tablespace TEMP

RMAN-08132: warning: cannot update recovery area reclaimable file list

 While there is a lot of free space available on the TEMP tablespace, but still application jobs or RMAN backup jobs or any other queries failing can be due to state stats.

CAUSE

Stale stats can cause 'ORA-01652: unable to extend temp segment by XX in tablespace TEMP' 
 

SOLUTION

Execute the failing jobs after collecting dictionary, system and Fixed objects stats on this database:

EXEC DBMS_STATS.GATHER_DICTIONARY_STATS();
EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS();
EXEC DBMS_STATS.GATHER_SYSTEM_STATS();