Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fractured block found during backing up datafile

jdiMar 4 2009 — edited Mar 4 2009

Hi

Version: 10.2.0.3

I take RMAN full backups & export of db every night. The following error is logged in alertlog file while taking rman full backup. Also the backup is very slow and it has been running for 18hrs now(200GB db size). Could some one please explain me what this error about and the action I need to take to resolve this? thanks

Tue Mar 3 20:21:52 2009
Hex dump of (file 16, block 490151) in trace file /opt/oracle/admin/hol/udump/holiday_ora_11507.trc
Corrupt block relative dba: 0x04077aa7 (file 16, block 490151)
Fractured block found during backing up datafile
Data in bad block:
type: 2 format: 2 rdba: 0x04077aa7
last change scn: 0x0013.830b4809 seq: 0x4 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x10340201
check value in block header: 0x7e2e
computed block checksum: 0x361
Reread of blocknum=490151, file=/opt/oracle/oradata/hol/undotbs03.dbf. found valid data

This post has been answered by oradba on Mar 4 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2009

Added on Mar 4 2009

#performance-availability, #recovery-manager-rman

3 comments

3,792 views