Corrupt rollback segments

From: Mr_Lab <t.o.b.y_at_btinternet.com>
Date: 2000/08/02
Message-ID: <8ma8vt$3jn$1@neptunium.btinternet.com>#1/1

Hi,

I have an 8.1.5 instance that has suffered file corruption to my rollback tablespace. I've tried dropping the tablespace but keep getting:

ORA-01548: active rollback segment 'R01' found, terminate dropping tablespace

The current status off the problematic rollback tablespace is 'NEEDS RECOVERY'

SEGMENT_NAME                   OWNER  TABLESPACE_NAME
SEGMENT_ID FILE_ID    BLOCK_ID   INITIAL_EX NEXT_EXTEN MIN_EXTENT MAX_EXTENT
PCT_INCREA STATUS           INSTANCE_NUM

RELATIVE_F
------------------------------ ------ ------------------------------ -------

---------- ---------- ---------- ---------- ---------- ---------- ------
---- ---------------- ---------------------------------------- ----------
SYSTEM SYS SYSTEM 0 1 2 57344 57344 2 505 0 ONLINE 1 SYSTEM02 SYS SYSTEM 1 1 20209 57344 57344 2 505 0 ONLINE 1 R01 SYS RBS 2 3 2 131072 131072 2 2147483645 0 NEEDS RECOVERY 3 R02 SYS RBS 3 3 42 131072 131072 2 2147483645 0 NEEDS RECOVERY 3 R03 SYS RBS 4 3 82 131072 131072 2 2147483645 0 NEEDS RECOVERY 3 R04 SYS RBS 5 3 122 131072 131072 2 2147483645 0 NEEDS RECOVERY 3 R05 SYS RBS 6 3 3826 131072 131072 2 2147483645 0 NEEDS RECOVERY 3 R06 SYS RBS 7 3 3858 131072 131072 2 2147483645 0 NEEDS RECOVERY 3 R07 SYS RBS 8 3 3890 131072 131072 2 2147483645 0 NEEDS RECOVERY 3 R08 SYS RBS 9 3 3922 131072 131072 2 2147483645 0 NEEDS RECOVERY 3

Any help is much appreciated.

--

Mr. Lab
--

http://www.klingklang.co.uk
http://klingklang.dyndns.org
--
Received on Wed Aug 02 2000 - 00:00:00 CDT