Re: DATA BLOCK CORRUPTED

From: Vijay Vardhineni <vardhineni_at_worldnet.att.net>
Date: 1997/01/17
Message-ID: <01bc0426$ad317820$dd6893cf@default>#1/1

If the corrupted block belong to a table, then you need to set the event 10231. Setting the event 10231 lets you select the data from the table by skipping the corrupted block. You can set this event either by using ALTER SESSION command or by including an event in the INIT.ORA.

Alter session set events '10231 trace name context off';

or set the following in the INIT.ORA

event = "10231 trace name context forever, level 10"

It may be a good idea to seek the help of Oracle World Wide Support, before executing above commands.

-- 
Vijaya Kumar Vardhineni
Certified Oracle DBA, EDS
Plano, TX


Allen Kirby <akirby_at_att.com> wrote in article <32D66793.4A65_at_att.com>...


> Wisdom Beauty wrote:

> > 

> > Any experience in fixing data block corruption?

> > 

> > Please e-mail to jytasc_at_m2.dj.net.tw

> 

> Unfortunately, yes.  You have to drop the offending object and recreate

> it.  If it's an index or rollback segment, you haven't lost anything.

> If it's a table, you have lost the data in that block.  If you don't

> have a suitable backup to recover it from, you can export the table,

> drop it and re-import it.  You have to set the option to ignore

> corrupted blocks but I can't remember if this is an export option or

> done with an 'alter' command.  I'm sure someone else out there knows

> the exact syntax.

> 

> -- 

> ---

> Allen Kirby			AT&T ITS Production Services

> akirby_at_att.com			Alpharetta, GA.

>

Received on Fri Jan 17 1997 - 00:00:00 CST