Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3145177
  • 博文数量: 206
  • 博客积分: 3409
  • 博客等级: 中校
  • 技术积分: 4066
  • 用 户 组: 普通用户
  • 注册时间: 2010-12-24 10:21
个人简介

● ITPUB名人堂嘉宾 ● ChinaUnix社区博客专家 ● ChinaUnix社区Oracle板块版主 ● 优酷网认证音乐牛人:EricGuitar ● SDOUG 核心成员 ●E-mail:gaoqiangdba@163.com

文章分类

全部博文(206)

文章存档

2021年(11)

2020年(7)

2019年(7)

2016年(5)

2015年(36)

2014年(23)

2013年(15)

2012年(23)

2011年(61)

2010年(18)

分类: Oracle

2014-11-30 10:58:20

  

 NBU在归档不全或者是被删除后,在备份的时候会报错:

Detail Status:
2014-11-7 6:17:35 - requesting resource sddb-nbu-hcart3-robot-tld-0
2014-11-7 6:17:35 - requesting resource sddb-nbu.NBU_CLIENT.MAXJOBS.testdb
2014-11-7 6:17:35 - requesting resource sddb-nbu.NBU_POLICY.MAXJOBS.testa
2014-11-7 6:17:35 - granted resource sddb-nbu.NBU_CLIENT.MAXJOBS.testdb
2014-11-7 6:17:35 - granted resource sddb-nbu.NBU_POLICY.MAXJOBS.testa
2014-11-7 6:17:35 - granted resource sddb-nbu-hcart3-robot-tld-0
2014-11-7 6:17:35 - estimated 0 kbytes needed
2014-11-7 6:17:35 - started process bpbrm (19072)
2014-11-7 6:17:37 - connecting
2014-11-7 6:17:37 - connected; connect time: 00:00:00
2014-11-7 6:25:06 - end writing
the backup failed to back up the requested files(6)

2014-11-7 6:25:06 - end writing
the backup failed to back up the requested files(6)

解决方法:
重新检查归档日志。


操作:
RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=985 devtype=DISK
validation failed for archived log   ------归档被删除验证失败
archive log filename=/yyarchlog/1_3750_842737622.dbf recid=3563 stamp=862839417
validation failed for archived log   ------归档被删除验证失败
archive log filename=/yyarchlog/1_3751_842737622.dbf recid=3564 stamp=862839460
validation failed for archived log   ------归档被删除验证失败
archive log filename=/yyarchlog/1_3752_842737622.dbf recid=3565 stamp=862843017
validation failed for archived log   ------归档被删除验证失败
archive log filename=/yyarchlog/1_3948_842737622.dbf recid=3761 stamp=863014582
validation succeeded for archived log
archive log filename=/yyarchlog/1_3949_842737622.dbf recid=3762 stamp=863014616
Crosschecked 200 objects



检查完成后立即发起备份,看一下是否OK?




阅读(3073) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~