Windows 64 Bit Server 2003

The past few days I've run into an interesting error in RMAN.

When making backups, RMAN is running a query that is consuming
all temp space. This causes an ORA-30928 to RMAN, and an
ORA-1652 to appear in the alert.log

ORA-30928: "Connect by filtering phase runs out of temp tablespace"
ORA-1652: "unable to extend temp segment by %s in tablespace %s"

The query in question:

select round(sum(MBYTES_PROCESSED)),round(sum(INPUT_BYTES)),round(sum(OUTPUT_BYTES)) from V$RMAN_STATUS start with (RECID=:b1 and
STAMP=:b2) connect by prior RECID=parent_recid

This query is easy to identify as coming from RMAN: it appears exactly like
this in the RMAN executable.

I doubled the temp space available in the hopes that this query would
be satiated by a double helping of disposable bytes, but alas, it appears
to be much hungrier than that. (that was 4 gig of TEMP)

This query takes about 3 minutes to run manually before consuming the
temp space (1 gig) my account is allocated.
The sort block usage amounts to 788 rows from v$sort_usage.

I have opened an SR on this, and googled as well, so far to no avail.

Has anyone else here run into this particular error with RMAN?

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
grouporacle-l @
postedAug 12, '08 at 9:52p
activeAug 12, '08 at 10:03p

1 user in discussion

Jared Still: 2 posts



site design / logo © 2022 Grokbase