Rollback segments in "RECOVER" status

Hi all,

I'm running Oracle 7.3 on a Windows NT platform.

Recently I was trying to increase the size of the roll back segments to make room for a large transaction. Using Oracle Storage Manager, I set a datafile offline thinking it would go offline when any transactions that might be using it finished. Instead it went in to "RECOVER" mode.

My users are now getting "ORA-00376 file 15 cannot be read at this time." and "ORA-01110 data file 15: E:\ORANT\DATABASE\RBS2ORCL.ORA."

Rollback segments RB3 through RB16 show a status of "NEEDS RECOVERY".

I was even going to drop the database, re-create it, and re-import the data, but it won't even let me do that!

Anyone have an idea of how I can get out of this problem?

Thanks, Received on Mon Jan 08 2001 - 13:42:13 CST