RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due

原创 2009年09月23日 12:59:00

今天在运行 delete obsolete报错了

RMAN> delete obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
using channel ORA_DISK_2
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Controlfile Copy     15     23-SEP-09          /opt/oracle/control01.ctl

Do you really want to delete the above objects (enter YES or NO)? yes

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
List of Mismatched objects
==========================
  Object Type   Filename/Handle
--------------- ---------------------------------------------------
Datafile Copy   /opt/oracle/control01.ctl

 

 

RMAN> crosscheck backup;

using channel ORA_DISK_1
using channel ORA_DISK_2
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/opt/rman_bak/ESCALADE/2009-09-23/TTL_ESCALADE_20090923_92 recid=86 stamp=698329633
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/opt/rman_bak/ESCALADE/2009-09-23/TTL_ESCALADE_20090923_93 recid=87 stamp=698329633
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/opt/rman_bak/ESCALADE/2009-09-23/arch_ESCALADE_20090923_97 recid=91 stamp=698329715
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/opt/rman_bak/ESCALADE/2009-09-23/ctl_c-2788940106-20090923-04 recid=92 stamp=698329717
Crosschecked 4 objects

 

发现crosscheck backup 和crosscheck backupset发现不了该文件

 

要用 CROSSCHECK CONTROLFILECOPY 语句

RMAN> CROSSCHECK CONTROLFILECOPY '/opt/oracle/control01.ctl';

released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=32 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=35 devtype=DISK
validation failed for controlfile copy
controlfile copy filename=/opt/oracle/control01.ctl recid=15 stamp=698319446
Crosschecked 1 objects


RMAN> delete obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
using channel ORA_DISK_2
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Controlfile Copy     15     23-SEP-09          /opt/oracle/control01.ctl

Do you really want to delete the above objects (enter YES or NO)? yes
deleted controlfile copy
controlfile copy filename=/opt/oracle/control01.ctl recid=15 stamp=698319446
Deleted 1 objects

 

删除成功

 

 

RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due

RMAN>  delete obsolete; RMAN retention policy will be applied to the command RMAN retention po...
  • changyanmanman
  • changyanmanman
  • 2014年05月08日 14:14
  • 2497

RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due to mismatched status

使用RMAN备份,运行delete noprompt obsolete; 报以上错误   RMAN> show all; RMAN configuration parameters for da...
  • wonder_2012
  • wonder_2012
  • 2012年07月11日 14:43
  • 2001

解决RMAN-06207与RMAN-06208

当我在RMAN下执行delete archivelog until time 'sysdate-7'删除截止到系统时间的前7天的所有archivelog时报如下错误: RMAN-06207: 警告:...
  • zhengcairong520yao
  • zhengcairong520yao
  • 2013年07月30日 17:44
  • 682

[Rman]RMAN-06207 WARNING:2 objects could not be deleted for DISK channel(s) due

MAN> delete obsolete; RMAN retention policy will be applied to the command RMAN retention policy is...
  • u011364306
  • u011364306
  • 2015年12月03日 10:08
  • 353

RMAN 备份报错 RMAN-06207 RMAN-06208 解决方法

新搭建的环境,还没上线,今天在部署脚本,RMAN 备份中有一个警告,内容如下: RMAN-06207: WARNING: 1 objects could not bedeleted for DISK ...
  • tianlesoftware
  • tianlesoftware
  • 2011年10月21日 16:52
  • 5749

【rabbitmq】 com.rabbitmq.client.AlreadyClosedException: channel is already closed due to channel erro

场景: 使用rabbitmq时报错,异常栈如下: Exception in thread "main" com.rabbitmq.client.AlreadyClosedException: ...
  • MichaelJY1991
  • MichaelJY1991
  • 2016年01月22日 11:27
  • 4047

Oracle duplicate数据库

1.在auxiliary 服务器上安装oracle 软件,(不要创建数据库)2.从target 数据库上得到pfile ,拷贝到auxiliary 相对应的位置,(修改想应的参数)3.auxiliar...
  • cong20089
  • cong20089
  • 2013年11月12日 10:57
  • 529

qemu: could not open disk image 错误解决方法

qemu: could not open disk image 。。。sdcard.img  解决方法,删除D:/Documents and Settings/User/.android/avd/AV...
  • lhf0000
  • lhf0000
  • 2011年06月28日 10:39
  • 5675

audio 层次结构

1。audio源码目录的层次结构 2. 播放mp3过程 1 AudioTrack.java 构造函数 其实实现都在cpp中     public AudioTrack(int str...
  • xiayu98020214
  • xiayu98020214
  • 2013年08月04日 19:02
  • 4653

L6305W: Image does not have an entry point. (Not specified or not set due to multiple choices.)

做项目的时候遇到此问题,现在终于解决了,把过程罗列出来供大家参考。1. 简单介绍一下项目。这个项目是为嵌入式平台开发的,不同的功能模块分别编译成独立库文件a.lib, b.lib, c.lib,d.l...
  • carry1314lele
  • carry1314lele
  • 2009年07月28日 15:47
  • 4768
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
举报原因:
原因补充:

(最多只允许输入30个字)