关于镜像备份无法删除问题

linloosen

如题，已试过交叉校验还是无法删除，操作过程详见下面步骤。请解答！
---------------------------------------------------------------------
RMAN> delete noprompt copy;（删除镜像备份）

released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
released channel: ORA_DISK_4
released channel: ORA_DISK_5
released channel: ORA_DISK_6
released channel: ORA_DISK_7
released channel: ORA_DISK_8
released channel: ORA_SBT_TAPE_1
released channel: ORA_SBT_TAPE_2
released channel: ORA_SBT_TAPE_3
released channel: ORA_SBT_TAPE_4
released channel: ORA_SBT_TAPE_5
released channel: ORA_SBT_TAPE_6
released channel: ORA_SBT_TAPE_7
released channel: ORA_SBT_TAPE_8
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=34 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=35 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1159 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=1170 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=31 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=1157 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=15 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=1171 device type=DISK
specification does not match any control file copy in the repository
List of Datafile Copies
=======================

Key     File S Completion Time     Ckp SCN    Ckp Time           
------- ---- - ------------------- ---------- -------------------
6       5    A 2015-07-05:22:43:13 1310227    2015-07-05:19:35:06
        Name: +DATA/orcl/datafile/example.257.884288507

List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================

Key     Thrd Seq     S Low Time           
------- ---- ------- - -------------------
47      1    68      A 2015-07-06:08:28:38
        Name: +FRA/orcl/archivelog/2015_07_06/thread_1_seq_68.307.884344363

48      1    69      A 2015-07-06:11:12:42
        Name: +FRA/orcl/archivelog/2015_07_08/thread_1_seq_69.325.884499317

49      1    70      A 2015-07-08:06:15:16
        Name: +FRA/orcl/archivelog/2015_07_08/thread_1_seq_70.320.884502015

50      1    71      A 2015-07-08:07:00:13
        Name: +FRA/orcl/archivelog/2015_07_08/thread_1_seq_71.317.884558843

51      1    72      A 2015-07-08:22:47:22
        Name: +FRA/orcl/archivelog/2015_07_08/thread_1_seq_72.315.884558923

52      1    73      A 2015-07-08:22:48:43
        Name: +FRA/orcl/archivelog/2015_07_09/thread_1_seq_73.310.884563217

53      1    74      A 2015-07-09:00:00:16
        Name: +FRA/orcl/archivelog/2015_07_09/thread_1_seq_74.309.884563227

54      1    75      A 2015-07-09:00:00:26
        Name: +FRA/orcl/archivelog/2015_07_09/thread_1_seq_75.308.884563267

55      1    76      A 2015-07-09:00:01:06
        Name: +FRA/orcl/archivelog/2015_07_09/thread_1_seq_76.306.884582815

56      1    77      A 2015-07-09:05:26:55
        Name: +FRA/orcl/archivelog/2015_07_09/thread_1_seq_77.305.884602253

57      1    78      A 2015-07-09:10:50:51
        Name: +FRA/orcl/archivelog/2015_07_09/thread_1_seq_78.304.884645335

58      1    79      A 2015-07-09:22:48:53
        Name: +FRA/orcl/archivelog/2015_07_09/thread_1_seq_79.303.884645437

59      1    80      A 2015-07-09:22:50:36
        Name: +FRA/orcl/archivelog/2015_07_09/thread_1_seq_80.302.884648931

60      1    81      A 2015-07-09:23:48:49
        Name: +FRA/orcl/archivelog/2015_07_09/thread_1_seq_81.301.884648931

61      1    82      A 2015-07-09:23:48:50
        Name: +FRA/orcl/archivelog/2015_07_09/thread_1_seq_82.300.884648935

62      1    83      A 2015-07-09:23:48:54
        Name: +FRA/orcl/archivelog/2015_07_09/thread_1_seq_83.299.884648937

63      1    84      A 2015-07-09:23:48:55
        Name: +FRA/orcl/archivelog/2015_07_09/thread_1_seq_84.297.884648937

64      1    85      A 2015-07-09:23:48:56
        Name: +FRA/orcl/archivelog/2015_07_09/thread_1_seq_85.296.884648941

66      1    86      A 2015-07-09:23:48:59
        Name: +FRA/orcl/archivelog/2015_07_10/thread_1_seq_86.295.884651483

65      1    87      A 2015-07-10:00:31:22
        Name: +FRA/orcl/archivelog/2015_07_10/thread_1_seq_87.294.884651483

67      1    88      A 2015-07-10:00:31:23
        Name: +FRA/orcl/archivelog/2015_07_10/thread_1_seq_88.284.884651489

68      1    89      A 2015-07-10:00:31:27
        Name: +FRA/orcl/archivelog/2015_07_10/thread_1_seq_89.285.884651489

69      1    90      A 2015-07-10:00:31:29
        Name: +FRA/orcl/archivelog/2015_07_10/thread_1_seq_90.286.884651491

70      1    91      A 2015-07-10:00:31:31
        Name: +FRA/orcl/archivelog/2015_07_10/thread_1_seq_91.287.884651495

deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_06/thread_1_seq_68.307.884344363 RECID=47 STAMP=884344364
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_08/thread_1_seq_69.325.884499317 RECID=48 STAMP=884499318
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_08/thread_1_seq_70.320.884502015 RECID=49 STAMP=884502017
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_08/thread_1_seq_71.317.884558843 RECID=50 STAMP=884558843
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_08/thread_1_seq_72.315.884558923 RECID=51 STAMP=884558925
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_09/thread_1_seq_73.310.884563217 RECID=52 STAMP=884563220
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_09/thread_1_seq_74.309.884563227 RECID=53 STAMP=884563229
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_09/thread_1_seq_75.308.884563267 RECID=54 STAMP=884563268
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_09/thread_1_seq_76.306.884582815 RECID=55 STAMP=884582817
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_09/thread_1_seq_77.305.884602253 RECID=56 STAMP=884602253
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_09/thread_1_seq_78.304.884645335 RECID=57 STAMP=884645336
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_09/thread_1_seq_79.303.884645437 RECID=58 STAMP=884645438
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_09/thread_1_seq_80.302.884648931 RECID=59 STAMP=884648930
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_09/thread_1_seq_81.301.884648931 RECID=60 STAMP=884648930
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_09/thread_1_seq_82.300.884648935 RECID=61 STAMP=884648934
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_09/thread_1_seq_83.299.884648937 RECID=62 STAMP=884648936
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_09/thread_1_seq_84.297.884648937 RECID=63 STAMP=884648937
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_09/thread_1_seq_85.296.884648941 RECID=64 STAMP=884648940
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_10/thread_1_seq_86.295.884651483 RECID=66 STAMP=884651487
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_10/thread_1_seq_87.294.884651483 RECID=65 STAMP=884651483
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_10/thread_1_seq_88.284.884651489 RECID=67 STAMP=884651488
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_10/thread_1_seq_89.285.884651489 RECID=68 STAMP=884651489
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_10/thread_1_seq_90.286.884651491 RECID=69 STAMP=884651491
deleted archived log
archived log file name=+FRA/orcl/archivelog/2015_07_10/thread_1_seq_91.287.884651495 RECID=70 STAMP=884651494
Deleted 24 objects


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   +DATA/orcl/datafile/example.257.884288507


RMAN> crosscheck copy;

released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
released channel: ORA_DISK_4
released channel: ORA_DISK_5
released channel: ORA_DISK_6
released channel: ORA_DISK_7
released channel: ORA_DISK_8
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=34 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=35 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1159 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=1170 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=31 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=1157 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=15 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=1171 device type=DISK
specification does not match any control file copy in the repository
specification does not match any archived log in the repository
validation failed for datafile copy
datafile copy file name=+DATA/orcl/datafile/example.257.884288507 RECID=6 STAMP=884299393
Crosschecked 1 objects

linloosen

上接一楼
RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
no obsolete backups found

RMAN> list copy;

specification does not match any control file copy in the repository
specification does not match any archived log in the repository
List of Datafile Copies
=======================

Key     File S Completion Time     Ckp SCN    Ckp Time           
------- ---- - ------------------- ---------- -------------------
6       5    X 2015-07-05:22:43:13 1310227    2015-07-05:19:35:06
        Name: +DATA/orcl/datafile/example.257.884288507

botang

这个是在线的数据文件，不知是不是set newname 之类的命令出现问题