ͨdelete noprompt copyɾݾ
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    A 2015-07-05:22:43:13 1310227    2015-07-05:19:35:06
        Name: +DATA/orcl/datafile/example.257.884288507


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
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=26 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1165 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=28 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=1166 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=29 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=1167 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=30 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=1168 device type=DISK
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    A 2015-07-05:22:43:13 1310227    2015-07-05:19:35:06
        Name: +DATA/orcl/datafile/example.257.884288507


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> 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    A 2015-07-05:22:43:13 1310227    2015-07-05:19:35:06
        Name: +DATA/orcl/datafile/example.257.884288507
	------------------------------------------------------------------------------------------
	֤ͨҲɾ
	
RMAN> crosscheck  backup of datafile 5; 

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=31 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=32 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: SID=33 device type=SBT_TAPE
channel ORA_SBT_TAPE_3: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: SID=34 device type=SBT_TAPE
channel ORA_SBT_TAPE_4: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_5
channel ORA_SBT_TAPE_5: SID=35 device type=SBT_TAPE
channel ORA_SBT_TAPE_5: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_6
channel ORA_SBT_TAPE_6: SID=36 device type=SBT_TAPE
channel ORA_SBT_TAPE_6: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_7
channel ORA_SBT_TAPE_7: SID=37 device type=SBT_TAPE
channel ORA_SBT_TAPE_7: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_8
channel ORA_SBT_TAPE_8: SID=38 device type=SBT_TAPE
channel ORA_SBT_TAPE_8: Oracle Secure Backup
specification does not match any backup in the repository

RMAN> crosscheck copy of tablespace system;

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=26 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1165 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=28 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=1166 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=29 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=1167 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=30 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=1168 device type=DISK
specification does not match any datafile copy in the repository

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> delete noprompt expired 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=26 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1165 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=28 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=1166 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=29 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=1167 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=30 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=1168 device type=DISK
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
specification does not match any archived log in the repository