RMAN> report schema;
starting full resync of recovery catalog
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ======
RMAN-03002: failure of report command at 05/31/2008 10:39:03
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 05/31/2008 10:39:03
ORA-01652: unable to extend temp segment by in tablespace
I also get the same error when executing SHOW ALL.
The error does not specify the tablespace_name in "error". I also checked the RMAN Catalog db for any space related issues. I did not find one.
alter system set events '1652 trace name errorstack level 1';
When the ORA-1652 error is raised again, Oracle will create a trace file in the USER_DUMP_DEST directory. This trace file should show you which tablespace is short on space. To turn off this trace, issue:
alter system set events '1652 trace name context off';
While querying DBA_FREE_SPACE to see if your tablespace has enough free space, keep in mind that with Dictionary Managed Tablespaces, that free space may be fragmented too much, so as to be virtually unusable.
For more solutions to common Oracle errors, check out our Solving common Oracle errors guide.