In this Document
Symptoms |
Cause |
Solution |
References |
APPLIES TO:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation 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(); 标签:STATS,EXEC,01652,GATHER,08132,tablespace,2762263.1,RMAN From: https://www.cnblogs.com/muzisanshi/p/16940452.html