flashback空间爆满IMAGECOPY 占的比率最大，通过RMAN释放空间

1.查看当前datafilecopy目录已经为空

$ pwd

/u01/app/oracle/flash_recovery_area/AIKI/datafile
$ ls
$

2.显示结果是imagecopy使用量仍然存在

SQL> select * from  v$flash_recovery_area_usage

  2  /

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE                   0                         0               0
ONLINELOG                     0                         0               0
ARCHIVELOG                    0                         0               0
BACKUPPIECE                   0                         0               0
IMAGECOPY                 61.17                         0               5

FLASHBACKLOG                  0                         0               0

3.进入rman

RMAN> delete datafilecopy all;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=131 devtype=DISK

List of Datafile Copies
Key     File S Completion Time Ckp SCN    Ckp Time        Name
------- ---- - --------------- ---------- --------------- ----
3       1    A 12-MAY-12       941737     12-MAY-12       /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_system_7tvmfno3_.dbf
5       2    A 12-MAY-12       942514     12-MAY-12       /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_undotbs1_7tvmk2vs_.dbf
2       6    A 12-MAY-12       941653     12-MAY-12       /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_aiki2_7tvmfgpr_.dbf
6       7    A 12-MAY-12       942723     12-MAY-12       /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_small_7tvmkxrd_.dbf
4       8    A 12-MAY-12       942708     12-MAY-12       /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_aiki3_7tvmko0y_.dbf

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

RMAN-06207: WARNING: 5 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   /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_system_7tvmfno3_.dbf
RMAN-06214: Datafile Copy   /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_undotbs1_7tvmk2vs_.dbf
RMAN-06214: Datafile Copy   /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_aiki2_7tvmfgpr_.dbf
RMAN-06214: Datafile Copy   /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_small_7tvmkxrd_.dbf
RMAN-06214: Datafile Copy   /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_aiki3_7tvmko0y_.dbf

4.报错，MS认不到，对文件逐个做crosscheck

RMAN>  crosscheck datafilecopy '/u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_system_7tvmfno3_.dbf';

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=131 devtype=DISK
validation failed for datafile copy
datafile copy filename=/u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_system_7tvmfno3_.dbf recid=3 stamp=783081765
Crosschecked 1 objects

......

5.成功删除

RMAN> delete datafilecopy all;

using channel ORA_DISK_1

List of Datafile Copies
Key     File S Completion Time Ckp SCN    Ckp Time        Name
------- ---- - --------------- ---------- --------------- ----
3       1    X 12-MAY-12       941737     12-MAY-12       /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_system_7tvmfno3_.dbf
5       2    X 12-MAY-12       942514     12-MAY-12       /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_undotbs1_7tvmk2vs_.dbf
2       6    X 12-MAY-12       941653     12-MAY-12       /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_aiki2_7tvmfgpr_.dbf
6       7    X 12-MAY-12       942723     12-MAY-12       /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_small_7tvmkxrd_.dbf
4       8    X 12-MAY-12       942708     12-MAY-12       /u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_aiki3_7tvmko0y_.dbf

Do you really want to delete the above objects (enter YES or NO)? yes
deleted datafile copy
datafile copy filename=/u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_system_7tvmfno3_.dbf recid=3 stamp=783081765
deleted datafile copy
datafile copy filename=/u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_undotbs1_7tvmk2vs_.dbf recid=5 stamp=783081792
deleted datafile copy
datafile copy filename=/u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_aiki2_7tvmfgpr_.dbf recid=2 stamp=783081736
deleted datafile copy
datafile copy filename=/u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_small_7tvmkxrd_.dbf recid=6 stamp=783081793
deleted datafile copy
datafile copy filename=/u01/app/oracle/flash_recovery_area/AIKI/datafile/o1_mf_aiki3_7tvmko0y_.dbf recid=4 stamp=783081785
Deleted 5 objects


RMAN>

SQL> select * from  v$flash_recovery_area_usage
  2  /

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE                   0                         0               0
ONLINELOG                     0                         0               0
ARCHIVELOG                    0                         0               0
BACKUPPIECE                   0                         0               0
IMAGECOPY                     0                         0               0
FLASHBACKLOG                  0                         0               0

6 rows selected.