ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN备份时提示Fractured block found

RMAN备份时提示Fractured block found

原创 Linux操作系统 作者:is.x 时间:2011-06-07 14:35:01 0 删除 编辑

rman备份期间,AIX系统上oracle 10.2.0.3alertlog出现如下信息:

 

Tue Jun  7 01:41:58 2011

Hex dump of (file 5, block 938791) in trace file /oracle/product/10.2.0/admin/MS/udump/ms_ora_471880.trc

Corrupt block relative dba: 0x014e5327 (file 5, block 938791)

Fractured block found during backing up datafile

Data in bad block:

 type: 6 format: 2 rdba: 0x014e5327

 last change scn: 0x0007.4e6f12b3 seq: 0x1 flg: 0x06

 spare1: 0x0 spare2: 0x0 spare3: 0x0

 consistency value in tail: 0x14cc0601

 check value in block header: 0xd94b

 computed block checksum: 0x67f

Reread of blocknum=938791, file=/dev/vx/rdsk/oradgMS/lv_ms_Profiles1. found valid data

 

从日志中可以看到,提示Corruptblock对应的dba0x014e5327 (file 5, block 938791)data block的类型为66trans data,所有的dataindex blocks都是该类型)。Oracle发现block有可能corrupt后,进行了reread,结果为found valid data,说明数据块未损坏。

 

       我们来看一下块断裂的说明:

A Fractured block means that the block is incomplete. Information from the block header does not match the block tail.

 

原因:

RMAN backups of datafile are being performed while the datafile is involved in heavy I/O.

RMAN reads Oracle blocks from disk. If it finds that the block is fractured,which means it is being actively used, it performs a reread of the block. If that fails again then the block is assumed to be corrupt.

 

Fractured block found,表示rman发现这个数据块正在被使用,这时rman会进行重新读取,如果再次失败,才认为是坏块。如果第二次尝试读取时成功,则表示数据完好,不会产生影响。

此类信息在IO负载较高的情况下进行rman备份时比较容易出现。

 

给出的解决方案:

Run the backups when the tablespace has less I/O activity.

建议在空闲时段进行rman备份,以避免出现这类信息。

 

 

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20750200/viewspace-697292/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-04-27

  • 博文量
    73
  • 访问量
    255649