oracle 归档日志损坏,rman恢复异常,归档日志损坏

最近生产库表被truncate,生产库通过nbu备份到带库,于是决定通过nbu将数据库在异机进行恢复,恢复过程中,控制文件和数据文件都是可以正常restore的,当开始恢复归档日志并且应用时,总是出现异常,

rman恢复的错误日志如下:

starting media recovery

channel D2: starting archive log restore to default destination

channel D1: starting archive log restore to default destination

channel D2: restoring archive log

archive log thread=2 sequence=23136

channel D1: restoring archive log

archive log thread=1 sequence=83213

channel D2: restoring archive log

archive log thread=2 sequence=23137

channel D2: reading from backup piece al_21049_1_823142358

channel D1: restoring archive log

archive log thread=1 sequence=83214

channel D1: restoring archive log

archive log thread=1 sequence=83215

channel D1: reading from backup piece al_21048_1_823142241

channel D2: restored backup piece 1

piece handle=al_21049_1_823142358 tag=NULL

channel D2: restore complete, elapsed time: 00:05:16

channel D1: restored backup piece 1

piece handle=al_21048_1_823142241 tag=NULL

channel D1: restore complete, elapsed time: 00:07:11

unable to find archive log

archive log thread=1 sequence=83213

Oracle Error:

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01110: data file 1: '/hbora1/hotbill/system01.dbf'

released channel: D1

released channel: D2

released channel: D3

released channel: D4

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 08/17/2013 02:15:24

ORA-19587: error occurred reading 512 bytes at block number 1

ORA-27091: unable to queue I/O

ORA-27067: size of I/O buffer is invalid

Additional information: 2

Additional information: 512

在alertlog中也发现错误信息如下:

alter database recover if needed

start until change 13423956452020 using backup controlfile

Media Recovery Start

parallel recovery started with 7 processes

ORA-279 signalled during: alter database recover if needed

start until change 13423956452020 using backup controlfile

...

Sat Aug 17 02:13:23 BEIST 2013

Archivelog restore complete. Elapsed time: 0:00:00

Archivelog restore complete. Elapsed time: 0:00:02

Sat Aug 17 02:14:48 BEIST 2013

Archivelog restore complete. Elapsed time: 0:00:00

Sat Aug 17 02:15:12 BEIST 2013

Archivelog restore complete. Elapsed time: 0:00:24

Archivelog restore complete. Elapsed time: 0:00:25

***

Corrupt block seq: 83213 blocknum=1.

Bad header found during deleting archived log

Data in bad block - flag:1. format:66. bno:1. seq:83213

beg:0 cks:43860

calculated check value: 43860

Sat Aug 17 02:15:24 BEIST 2013

alter database recover cancel

Signalling error 1152 for datafile 1!

但是这些归档日志确实已经恢复到到了/arch/archlog1的归档存放目录,在生产库我尝试对这些归档进行logmnr,也是可以执行的。

求教各位大神,是否有解决方案

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

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值