删除过期备份报错RMAN-06207 RMAN-06208解决方案
RMAN备份日志中出现了警告
日志文件目录如下:
[root@erpdbs rmanback]# ll
total 88
-rw-r--r-- 1 oraprod dba 81011 Sep 7 22:52 rmanback.log
-rwxr--r-- 1 oraprod dba 2581 Jun 24 2011 rmanback.sh
[root@erpdbs rmanback]# pwd
/data/scripts_db/rmanback
[root@erpdbs rmanback]#
查看日志错误内容如下:
RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Archivelog /data/arch/PROD1/PROD_1_98560_578692516.arc
日志已经提示处理方法了,使用crosscheck命令修复archivelog状态
执行方法如下:
RMAN> crosscheck archivelog /data/arch/PROD1/PROD_1_98560_578692516.arc;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
Archivelog handle /data/arch/PROD1/PROD_1_98560_578692516.arc recid=1612 stamp=662688078
Crosschecked 1 objects
RMAN> delete backupset 1612;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1612 1612 1 1 EXPIRED DISK /data/arch/PROD1/PROD_1_98560_578692516.arc
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/ /data/arch/PROD1/PROD_1_98560_578692516.arc recid=1612 stamp=662688078
Deleted 1 objects
参考资料:
http://space.itpub.net/4227/viewspace-441088
http://blog.csdn.net/tianlesoftware/article/details/6894519
最新文章
- 对于UDS(ISO14229-2006) 汉译的声明(必读)
- 二叉树系列 - 二叉搜索树 - 线性时间内把有序链表转化为BST
- Android 检测网络连接状态
- hdu2078
- hdu 4115 Eliminate the Conflict ( 2-sat )
- jQuery ajax 请求php遍历json数组到table中
- ADODB.Connection 错误 '800a0e7a' 未找到提供程序 该程序可能未正确安装
- java 获取系统变量(环境变量和设置变量)
- [转]Hooked on DTrace
- 基于Prism.Windows的UWP开发备忘
- BZOJ 1069: [SCOI2007]最大土地面积 [旋转卡壳]
- Maven CXF wsdl2Java 给指定名空间设置包名
- linux选择sdb sdb4 fat32 还是sda分区
- SecureCRT自动记录日志
- Oracle数据库迁移的几种方式
- kbengine + cocos2d-js-demo理解
- 37QT程序打包
- Ubuntu系统下在PyCharm里用virtualenv集成TensorFlow
- [转]ViewPager 详解(三)---PagerTabStrip与PagerTitleStrip添加标题栏的异同
- ie7下z-index失效问题解决方法
热门文章
- 如何用js往html页面拼接一个div包括div的各种常用属性
- 轰炸III(codevs 1830)
- 1043 方格取数 2000 noip 提高组
- spring项目启动需要的几个注解
- uva 10716 Evil Straw Warts Live(贪心回文串)
- 京东电商API
- Js跨一级域名同步cookie
- JavaScript Patterns 2.5 (Not) Augmenting Build-in Prototypes
- eclipse和jdk版本对应问题
- [luogu_U15118]萨塔尼亚的期末考试