Re: many recovery of corruption

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:982927633.10850.3.nnrp-10.9e984b29_at_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.
>

No, it simply keeps re-reading until it gets a non-fractured version of the block (which always struck me as a less-than-intelligent way of doing things). So the words 'you', 'nail' and 'head' may be appropriate.

Regards
HJR
> --
> 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 - 17:20:16 CST