Re: many recovery of corruption

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 23 Feb 2001 11:30:33 -0000
Message-ID: <982927633.10850.3.nnrp-10.9e984b29@news.demon.co.uk>

The last time I saw anything like this, there was a (very) intermittent hardware fault throwing the odd bit on transfer from disc, which was why Oracle kept reporting success on re-read.

>> > Reread of rdbað997b2 file`. blocknumb8658. found valid data

Howard is this what rman does when backing up a busy tablespace, or does it have a more subtle way of dealing with fractured blocks.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Howard J. Rogers wrote in message <3a8f0b2f_at_news.iprimus.com.au>...


>How do you do your backups?  Hot?

>

>Regards

>HJR

>

>

>"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

>

>

Received on Fri Feb 23 2001 - 05:30:33 CST