Unrecoverable transactions in 11G R2

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 28 Aug 2012 08:40:45 -0400
Message-Id: <503C840E0200000B004F0B08_at_groupwise.gcrta.org>

Yesterday, we upgraded one of our Oracle EBS DEV databases to Oracle 11G R2. This morning we received an email alert that around 10:30 p.m. last night, about a dozen and a half tablespaces had an unrecoverable transaction. Is there some new Oracle scheduled job that rebuilds objects automatically? Our system was STILL DOWN for the upgrade so all EBS processes were down and users locked out. The only thing left has to be an Oracle supplied process that caused it.    

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113

Received on Tue Aug 28 2012 - 07:40:45 CDT

Original text of this message