| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback segments in "RECOVER" status
Couldn't you just perform media recovery on that datafile?
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Andersen,
Wayne A
Sent: Monday, January 08, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L
Subject: 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,
Wayne Andersen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andersen, Wayne A
INET: WayneAAndersen_at_Eaton.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jan 08 2001 - 14:00:14 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |