Re: Corrupt rollback segments

From: Tom Best <tabest_at_bellatlantic.dontspamme.net>
Date: 2000/08/03
Message-ID: <zK3i5.2285$R87.46216@typhoon2.ba-dsg.net>#1/1

Mr. Lab:

One of Loney's books refers to an undocumented init.ora variable "_CORRUPTED_ROLLBACK_SEGMENTS" that lets you bring up the database anyway, and then you can drop and recreate the problem rollback segments.

I guess you set it to true, but I'm not sure.

HTH,
Tom Best

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

>
>
> Any help is much appreciated.
>
> --
> Mr. Lab
> --
> http://www.klingklang.co.uk
> http://klingklang.dyndns.org
> --
>
>
>
>
Received on Thu Aug 03 2000 - 00:00:00 CDT