Re: Rollback segment needs recovery
Date: 1995/08/31
Message-ID: <809902485.4272_at_jbracken.demon.co.uk>#1/1
"David S. Kaufman" <dkaufman_at_popmail.mcs.com> wrote:
>>When I try to start up the database I have to do "media recovery" on the
>>SYSTEM tablespace file. The rocover procedure looks like it works fine,
>>but when the database starts up one of the rollback segments is in a
>>"need recovery" status.
>Is this a private rollback segment? If so do not list it in the
>rollback_segments line of the init.ora.
>>I can not log in from anything other than SQLDBA (sqlplus gives error
>>1578 in rollback segment r01).
>>I can not drop the rollback segment since it's not offline.
>>I can not drop the tablespace since it contains rollback segments.
>>I can not do recover on the tablespace, the system says it ok.
>>I can not bring the rollback segment online, since it needs recovery.
>>I can not use the system without fixing or droping this rollback segment.
>>
>If the database can be opened given the changes noted above, you could
>probably take the segment offline and drop it.
>Let me know if you need additional help.
>David
Get the name of the private rollback segment from the
rollback_segments line of init.ora
and add the line _corrupted_rollback_segments=rbseg name
shutdown, startup
take it offline and delete and re-create it.
alter the init.ora to remove the _corrupted line and start up again.
Hope this helps
John Bracken -- 'Gooden day, big-feller mine host! Trois Liverpool, UK beers pour favour avec us, silver plate' --
- johnb_at_jbracken.demon.co.uk ..or.. jbracken_at_uk.oracle.com ======