Oracle tries to read RBS in Automatic Undo Mode?

From: Thorsten Jens <thojens_at_gmx.de>
Date: 27 Apr 2005 23:11:45 -0700
Message-ID: <1114668705.825651.188040@z14g2000cwz.googlegroups.com>

Hi,

Oracle: 9.2.0.6.0/64-bit on Solaris 8 (Sparc).

I set our database to use AUM two days ago:

###########################################

# Automatic Undo Management Mode

###########################################

undo_management = auto
# Retention period: 2 hours

undo_retention = 7200
# Suppress error messages when trying to use manual undo management
statements
undo_suppress_errors = true
undo_tablespace = undotbs1

After restarting, I set the tablespace with the old rollback segments offline. Worked well so far.

At night, we load a lot of data using SQL*Loader + some SQL scripts. It ran into this:

ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 32 cannot be read at this time
ORA-01110: data file 32: '/oracle/ts3/rollback/rbs02.dbf'

rbs02.dbf is a file containing the old rolllback segments! Why did Oracle try to access those? The files in UNDOTBS1 are far from their seize limit, so it could not have been a size problem.

This really bugs me, as I have to do a huge TSPITR now :-(

Thorsten Received on Thu Apr 28 2005 - 01:11:45 CDT