Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> many recovery of corruption

many recovery of corruption

From: Igor Andreani <ighon_at_mailandnews.com>
Date: Sat, 17 Feb 2001 23:26:30 GMT
Message-ID: <3A8F08A2.4881604A@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
Received on Sat Feb 17 2001 - 17:26:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US