Re: rbs error

From: Evgueni Gavrilov <gev_at_treasury.ru>
Date: 2000/04/18
Message-ID: <38FBB5F9.17744D21@treasury.ru>#1/1

Hussein METDAOUI wrote:

> Hello
>
> I reboot an oracle server and when i would like to restart it i have the
> followed error :
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01578: ORACLE data block corrupted (file # 2, block # 62)
> ORA-01110: data file 2: '/u02/oradata/orcl/rbs01.dbf'
> SVRMGR> Server Manager complete.
>
> How can i do to restart correctly this server and how can i recover all
> the data ?

If recovery procedures fails you can add to your configuration file line: _corrupted_rollback_segments=(rollback_segment_name1, rollback_segment_name2 etc)
so that you could drop corrupted locked rollback segment.

Then feel free to create new rollback segments. *8-)

--
Yours truly, Evgueni
Oracle DBA
http://www.treasury.ru/~gev

Received on Tue Apr 18 2000 - 00:00:00 CDT