SMON: found rollback segment # 11 at address 67fd103c to take offline.

From: Ed Laugel 08-Sep-04 16:05
Subject: UNDO and trace files with SMON: found rollback segment

RDBMS Version: 9.2.0.4.0
Operating System and Version: HP-Ux 11.0
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): RDBMS
Product Version:

UNDO and trace files with SMON: found rollback segment

I have many trace files generated with this error "SMON: found rollback segment # ## at address ### to take offline." I understand they are generated when a redo segment is taken off line while it still contains active transactions.

But I only use UNDO with Automatic Undo Management (AUM). I don't have redo segments.

The alert log entry for about this time frame shows: SMON offlining US=11

I'm running this version of oracle on about 20 other systems with no problems. It's just thest 4 databases for this application that have this problem.

My issues are: Why is it generating trc files? How do I stop it from generating the trc files? And, is my database O.K.

---

From: Seshagiri Gangupantulu 08-Sep-04 16:35
Subject: Re : UNDO and trace files with SMON: found rollback segment

I have seen this messages even though we are using Oracle 9i and Automatic UNDO tablespaces.

Oracle didn't update this kind of error messages in trace files with undo segments but refer rollback segments only as Oracle 9i supports both manual as well as automatic undo management.

Your database is fine.

Thanks,

Sesha.