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 to mismatched status

使用RMAN备份,运行delete noprompt obsolete; 报以上错误   RMAN> show all; RMAN configuration parameters for da...

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...

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

SQL> select * from v$version;BANNER-----------------------------------------------------------------...

Some ashmem based objects can not be created due to file descriptor leak

记录了Android系统上基于ashmem或Fd的一些对象由于进程内文件描述符耗尽不能被创建的Issues。 Example One. 06-22 22:38:05.949 27928 31688...

RMAN-08137: WARNING: archive log not deleted as it is still needed

RMAN-08137: WARNING: archive log not deleted as it is still needed 备份时出现下面这个错误需要考虑:Stream,Dataguard...
  • deanza
  • deanza
  • 2012年07月14日 10:50
  • 844

RMAN-06207: 警告: 由于状态不匹配, 所以不能删除 1 对象 (对于 DISK 通道)。 RMAN-06208: 请用 CROSSCHECK 命令修正状态

1、备份数据文件 backup datafile 3; backup tablespace user; backup constrolfile to 2、列出所有备份集 RMAN> li...

Xcode真机调试中的 "The Developer Disk Image could not be mounted." 问题

Xcode真机调试中的 “The Developer Disk Image could not be mounted.” 问题 问题描述 随着iOS的的技术在不断地进步的同时,开发工具也要不停...

Could not establish trust relationship for the SSL/TLS secure channel

当我在用NET命名空间下获取URL的时候,提示如下错误: The underlying connection was closed: Could not establish trust relati...

<s:doubleselect 的使用-不支持EL表达式,需要使用OGNL来动态赋值-could not be resolved as a collection/array/map/enumerati

1、问题描述: 使用 struts2 设置级联下拉菜单,需要从后台数据库动态搜索下拉列表的选项,使用 class org.apache.jasper.JasperException:tag...
  • bestcxx
  • bestcxx
  • 2016年08月20日 11:18
  • 506

HTTP Status 500 - {msg=SolrCore 'collection1' is not available due to init failure: Could not load}

HTTP Status 500 - {msg=SolrCore 'collection1' is not available due to init failure: Could not load c...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
举报原因:
原因补充:

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