RMAN 备份报错 RMAN-06207 RMAN-06208 解决方法
来源:互联网 发布:excel数据转换到word中 编辑:程序博客网 时间:2024/04/25 14:29
新搭建的环境,还没上线,今天在部署脚本,RMAN 备份中有一个警告,内容如下:
RMAN-06207: WARNING: 1 objects could not bedeleted 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: Datafile Copy /u01/control01.ctl
这个文件是DG的一个控制文件,环境弄好之后,就把这个文件在OS 级别rm 掉了。结果备份就报这个错误。
RMAN> report obsolete;
RMAN retention policy will be applied tothe command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------------------------ --------------------
Control File Copy 1 20-OCT-11 /u01/control01.ctl
RMAN> delete noprompt obsolete;
RMAN retention policy will be applied tothe command
RMAN retention policy is set to redundancy1
using channel ORA_DISK_1
Deleting the following obsolete backups andcopies:
Type Key Completion Time Filename/Handle
-------------------- ------------------------ --------------------
Control File Copy 1 20-OCT-11 /u01/control01.ctl
RMAN-06207: WARNING: 1 objects could not bedeleted 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: Datafile Copy /u01/control01.ctl
解决方法:
RMAN> crosscheck copy;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1070 devtype=DISK
validation failed for control file copy
control file copyfilename=/u01/control01.ctl recid=1 stamp=765039758
validation succeeded for archived log
archive logfilename=/u01/archive/1_23_765024159.arc recid=44 stamp=765127875
validation succeeded for archived log
archive logfilename=/u01/archive/1_24_765024159.arc recid=45 stamp=765127875
Crosschecked 3 objects
RMAN> delete obsolete;
RMAN retention policy will be applied tothe command
RMAN retention policy is set to redundancy1
using channel ORA_DISK_1
Deleting the following obsolete backups andcopies:
Type Key Completion Time Filename/Handle
-------------------- ------------------------ --------------------
Control File Copy 1 20-OCT-11 /u01/control01.ctl
Do you really want to delete the aboveobjects (enter YES or NO)? y
deleted control file copy
control file copyfilename=/u01/control01.ctl recid=1 stamp=765039758
Deleted 1 objects
RMAN> report obsolete;
RMAN retention policy will be applied tothe command
RMAN retention policy is set to redundancy1
no obsolete backups found
在备份就ok了.
-------------------------------------------------------------------------------------------------------
版权所有. 文章允许转载, 但必须以链接方式注明源地址,否则追究法律责任.
Blog: http://blog.csdn.net/tianlesoftware
Weibo: http://weibo.com/tianlesoftware
Email: tianlesoftware@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群:83829929(满) DBA5群: 142216823(满)
DBA6 群:158654907(满) DBA7 群:69087192(满) DBA8 群:172855474
DBA 超级群2:151508914 DBA9群:102954821 聊天 群:40132017(满)
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
- RMAN 备份报错 RMAN-06207 RMAN-06208 解决方法
- RMAN备份报错
- RMAN备份报错
- rman备份报RMAN-00571、RMAN-00569、RMAN-03009
- RMAN-06207,RMAN-06208
- RMAN备份
- RMAN备份
- RMAN 备份
- rman 备份
- RMAN备份
- rman备份
- rman备份
- RMAN 备份
- RMAN 备份
- RMAN备份
- RMAN备份
- rman备份
- rman备份
- Linux驱动程序开发快速参考
- 构建不依赖于cookie的手机端用户登录机制
- VC++编程技巧83例
- 开始学习andEngine(3)
- Linux-mmap函数介绍
- RMAN 备份报错 RMAN-06207 RMAN-06208 解决方法
- c++空类实例大小不是0原因收藏
- ORACLE 数据库导入与导出
- [C++]指针知识点小结
- DB2如何删除用户的所有表
- 周末季
- windows xp 下 批量重命名文件
- android 代码创建快捷方式
- ubuntu看youku