Re: rbs oracle data block corrupted

Hi,

Normally, you should not have seen an rbs corruption message in startup since Oracle7.3+ doesn't rollback in startup. It's postponed. But, there are some cases that Oracle touches rbs in startup:

• Active transactions in the SYSTEM rbs are immediately rolled back. They are not postponed.
• Rbs headers are always touched.

In other words, your SYSTEM rbs, or an rbs header is corrupted.

Identify which object corrupted. Let's know which object is corrupted. If you can recover, do it. If not, As Tim Gorman said in his excellent answer, dump rbs. Then email it to the list and let's interpret it.

regards....

Atul Kumar Srivastav wrote:

> version : 8.1.6
>
> -----Original Message-----
> From: Danisment Gazi Unal (ubTools)
> [mailto:dunal_at_ubTools.com]
> Sent: Sunday, June 30, 2002 12:13 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: rbs oracle data block corrupted
>
> Hi,
>
> which version of Oracle are you using ? what are the all
> error messages ?
>
> regards...
>
> Atul Kumar Srivastav wrote:
>
> > Hi All !
> >
> > We have one problem.
> >
> > We can mount the database but not able to open it.
> >
> > It gives following error while opening:
> >
> > One Oracle Data Block Corrupted. RBS01.dbf (datafile for
> > rollback segment)
> >
> > How can i repair this corruption?
> >
> > Atul
>
> --
> Danisment Gazi Unal
> http://www.ubTools.com
>
>

--
Danisment Gazi Unal
http://www.ubTools.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (ubTools)
  INET: dunal_at_ubTools.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).