RMAN-06214: Datafile Copy
来源:互联网 发布:虚拟gps定位软件 ios 编辑:程序博客网 时间:2024/06/05 05:19
在使用rman备份的时候最后出现一个这样的错误:
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: Datafile Copy /home1/oracle/backup/sh/control2.ctl
然后去该目录下查看该文件发现已经被删除了,那肯定是在os上删除的而不是使用rman来删除的。
RMAN> crosscheck backupset;
使用该命令没有发现该文件,对于datafile copy方式不应该使用backupset方式来检查,而应该使用copy方式来检查;
RMAN> report obsolete;
using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 788 25-MAY-12 /home1/oracle/backup/sh/control2.ctl
RMAN> crosscheck copy;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=294 devtype=DISK
validation failed for control file copy
control file copy filename=/home1/oracle/backup/sh/control2.ctl recid=788 stamp=784174651
validation succeeded for archived log
archive log filename=/home1/oracle/oradata/newadm/arch/1_5697_619181136.dbf recid=5697 stamp=784469138
Crosschecked 2 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
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 788 25-MAY-12 /home1/oracle/backup/sh/control2.ctl
Do you really want to delete the above objects (enter YES or NO)? yes
deleted control file copy
control file copy filename=/home1/oracle/backup/sh/control2.ctl recid=788 stamp=784174651
Deleted 1 objects
RMAN>
- RMAN-06214: Datafile Copy
- RMAN-06214: Datafile Copy
- RMAN-06214: Datafile Copy .
- Oracle 使用RMAN COPY 移动 Datafile 位置
- RMAN-06183: datafile or datafile copy larger than maxsetsize
- RMAN-06585: no copy of datafile 7 found 问题解决
- RMAN-06183: datafile or datafile copy +DATA_ERP/ap_media35 (file number 27) larger than MAXSETSIZE
- How to copy a datafile from ASM to a file system not using RMAN
- RMAN-06023 : no backup or copy of datafile found to restore 说明
- RMAN-06023 : no backup or copy of datafile found to restore 说明
- RMAN-06023: no backup or copy of datafile 6 found to restore
- RMAN-06023: no backup or copy of datafile 1 found to restore
- RMAN-06100: no channel to restore a backup or copy of datafile 681
- RMAN-06023 no backup or copy of datafile 1 found to restore
- How to copy a datafile from ASM to a file system not using RMAN (Doc ID 428893.1)
- RMAN-06094: datafile 209 must be restored
- 利用datafile copy将数据文件重命名
- Rman switch to copy
- html操作
- C语言中#include "stdafx.h"详解
- C++中typedef struct与struct的区别
- 项目开发和管理需要弄清楚的6个问题
- 关于typedef的用法总结
- RMAN-06214: Datafile Copy
- amcharts js版破解
- 守卫南沙的艰苦岁月
- 蚊子爱叮什么人
- C程序设计语言练习2-5
- Linux音频设备驱动-1
- C语言运算符一览表
- ORACLE 分析函数ratio_to_report的使用
- Remove repetitive records