Re: rbs error

trying doing a startup mount, then recover datafile '/u02/oradata/orcl/rbs01.dbf'. This should clean it up enough to let you open the database. If not, check your ALERT log to see if you can get any additional information, perhaps exactly which rollback segment is corrupted. You could then comment that rollback segment out of you init.ora file and startup the database. Then drop and recreate the corrupted one.

HTH, and Good Luck.

In article <38FB526A.FC59C08C_at_eyrolles.com>,   Hussein METDAOUI <hm_at_eyrolles.com> wrote:
>
> Hello
>
> I reboot an oracle server and when i would like to restart it i have
 the
> followed error :
>
> Variable Size 4222976 bytes
> Database Buffers 409600 bytes
> Redo Buffers 73728 bytes
> Database mounted.
> 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 ?
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Apr 17 2000 - 00:00:00 CDT