Re: many recovery of corruption

"Igor Andreani" <ighon_at_mailandnews.com> wrote in message news:3A8F08A2.4881604A_at_mailandnews.com...
> What about this log ??
> I'am a Unix administrator and not a DBA, sorry for the short
> description.
>
> The recovery of corruption occurs many times, since many months...
> Thanks for your help
>
>
> > Dump file /u1/app/oracle/admin/ddsp/udump/ora_15397.trc
> > Oracle8i Enterprise Edition Release 8.1.5.0.0, 64 bit - Production
> > With the Partitioning and Java options
> > PL/SQL Release 8.1.5.0.0 - Production
> > ORACLE_HOME = /u1/app/oracle/product/8.1.5
> > System name: HP-UX
> > Node name: XXXXXXXXXXXXXXXXX
> > Release: B.11.00
> > Version: A
> > Machine: 9000/800
> > Instance name: ddsp
> > Redo thread mounted by this instance: 1
> > Oracle process number: 63
> > Unix process pid: 15397, image: oracle_at_XXXXXXX (TNS V1-V3)
> >
> > *** SESSION ID:(8.3494) 2001.02.16.17.55.58.347
> > ***
> > Corrupt block relative dba: 0x0f0997b2 file`. blocknumb8658.
> > Bad header found during buffer read
> > Data in bad block - type:6. format:2. rdba:0x0f021c8b
> > last change scn:0x018b.bc5096b2 seq:0x2 flg:0x00
> > consistancy value in tail 0x96b20602
> > check value in block header: 0x0, check value not calculated
> > spare1:0x0, spare2:0x0, spare2:0x0
> > Reread of rdbað997b2 file`. blocknumb8658. found valid data
> > ***
> > Corrupt block relative dba: 0x0f44ef4f filea. blocknum23407.
> > Bad header found during buffer read
> > Data in bad block - type:6. format:2. rdba:0x0f41b50d
> > last change scn:0x018b.bc5096b5 seq:0x2 flg:0x00
> > consistancy value in tail 0x96b50602
> > check value in block header: 0x0, check value not calculated
> > spare1:0x0, spare2:0x0, spare2:0x0
> > Reread of rdbaô4ef4f filea. blocknum23407. found valid data

Looks like a corrupt block on the disk.
Use any tool you have to verify this on disk level.

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Feb 17 2001 - 17:32:38 CST