ORA-19566: exceeded limit of 0 corrupt blocks

ORA-19566: exceeded limit of 0 corrupt blocks

 

When i try to take backup, it will shows block corrupted errors,

RMAN> backup database;

Starting backup at 25-MAY-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/system01.dbf
input datafile fno=00003 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/sysaux01.dbf
input datafile fno=00005 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/example01.dbf
input datafile fno=00006 name=/home/oracle/oracle/mytest/test01.dbf
input datafile fno=00002 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/undotbs01.dbf
input datafile fno=00004 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 25-MAY-10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/25/2010 13:22:00
ORA-19566: exceeded limit of 0 corrupt blocks for file /home/oracle/oracle/product/10.2.0/oradata/orcl/system01.dbf

In this case, i have checked my alert log file and find out which block corrupted and reocvered using rman.

My alertlog file

Hex dump of (file 1, block 61441) in trace file /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/udump/orcl_ora_17556.trc
Corrupt block relative dba: 0x0040f001 (file 1, block 61441)
Completely zero block found during backing up datafile
Reread of blocknum=61441, file=/home/oracle/oracle/product/10.2.0/oradata/orcl/system01.dbf. found same corrupt data

RMAN> blockrecover datafile 1 block 61441;

Starting blockrecover at 25-MAY-10
using channel ORA_DISK_1

(skipped)

Finished blockrecover at 25-MAY-10.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值