| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Corrupt rollback segments
Hi,
To drop the tablespace you have to put all the active rollback segments in
OFFLINE mode:
ALTER ROLLBACK SEGMENT <ROLLBACK_SEG_NAME> OFFLINE;
You can use OEM to make your life easier.
After that: DROP TABLESPACE <ROLLBACK TABLESPACE NAME> WITH CONTENTS;
That could be dangerous becouse you Oracle will modify the control files and
you have to create
rollback segments tablespace and the corresponding rollback segments before
shutting down the
instance.
Why don't you try to create new rolback segment and get rid of the corrupted
one without droping the
tablespace.
That is trivial with OEM and I tried that - No probs! If you have problems with you previlileges send me an e-mail
Good Luck!
Alex
"Mr_Lab" <t.o.b.y_at_btinternet.com> wrote in message
news:8ma8vt$3jn$1_at_neptunium.btinternet.com...
> 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
 |
 |