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
-------------------- ------ ------------------ --------------------
Control File Copy 1 14-FEB-14 /tmp/controlfile.ctl
Backup Set 1 26-JAN-15
Backup Piece 1 26-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_26/o1_mf_nnndf_TAG20150126T235449_bddrtcn9_.bkp
Backup Set 2 26-JAN-15
Backup Piece 2 26-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_26/o1_mf_s_870047902_bdds103y_.bkp
Backup Set 3 27-JAN-15
Backup Piece 3 27-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T233853_bdhd8fbr_.bkp
Backup Set 4 27-JAN-15
Backup Piece 4 27-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_27/o1_mf_s_870133136_bdhd8lqh_.bkp
Backup Set 5 27-JAN-15
Backup Piece 5 27-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T234242_bdhdhm4f_.bkp
Backup Set 6 27-JAN-15
Backup Piece 6 27-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T234242_bdhdhm7h_.bkp
Backup Set 7 27-JAN-15
Backup Piece 7 27-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_27/o1_mf_s_870133365_bdhdhp9q_.bkp
Backup Set 9 28-JAN-15
Backup Piece 9 28-JAN-15 /home/oracle/disk1
Backup Set 8 28-JAN-15
Backup Piece 8 28-JAN-15 /home/oracle/disk2
Backup Set 10 28-JAN-15
Backup Piece 10 28-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_28/o1_mf_s_870135174_bdhg86lh_.bkp
Backup Set 11 28-JAN-15
Backup Piece 11 28-JAN-15 /u01/oracle/11G/dbs/user_bs_DB01119
Backup Set 12 28-JAN-15
Backup Piece 12 28-JAN-15 /u01/oracle/11G/dbs/user_bs_DB01120
Backup Set 13 28-JAN-15
Backup Piece 13 28-JAN-15 /home/oracle/disk1/user_bs_DB01123.bkp
Backup Set 14 28-JAN-15
Backup Piece 14 28-JAN-15 /home/oracle/disk2/user_bs_DB01124.bkp
Backup Set 15 28-JAN-15
Backup Piece 15 28-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T231801_bdkzf9lp_.bkp
Backup Set 16 28-JAN-15
Backup Piece 16 28-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_28/o1_mf_s_870218284_bdkzff3k_.bkp
Backup Set 17 28-JAN-15
Backup Piece 17 28-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T232638_bdkzxgwt_.bkp
Backup Set 18 28-JAN-15
Backup Piece 18 28-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150128-02
Backup Set 19 28-JAN-15
Backup Piece 19 28-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T232922_bdl02lq5_.bkp
Backup Set 20 28-JAN-15
Backup Piece 20 28-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150128-03
Backup Set 21 28-JAN-15
Backup Piece 21 28-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T233646_bdl0jgck_.bkp
Backup Set 22 28-JAN-15
Backup Piece 22 28-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150128-04
Backup Set 23 28-JAN-15
Backup Piece 23 28-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T235448_bdl1l922_.bkp
Backup Set 24 28-JAN-15
Backup Piece 24 28-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150128-05
Backup Set 25 28-JAN-15
Backup Piece 25 28-JAN-15 /home/oracle/disk1/user_bs_DB01135.bkp
Backup Set 26 28-JAN-15
Backup Piece 26 28-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150128-06
Backup Set 27 28-JAN-15
Backup Piece 27 28-JAN-15 /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T235832_bdl1s8t6_.bkp
Backup Set 28 28-JAN-15
Backup Piece 28 28-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150128-07
Backup Set 29 29-JAN-15
Backup Piece 29 29-JAN-15 /home/oracle/disk/DB01/backupset/2015_01_29/o1_mf_nnndf_TAG20150129T000104_bdl1y10r_.bkp
Backup Set 30 29-JAN-15
Backup Piece 30 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-00
Backup Set 31 29-JAN-15
Backup Piece 31 29-JAN-15 /home/oracle/disk/same__DB01141.bkp
Backup Set 32 29-JAN-15
Backup Piece 32 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-01
Backup Set 33 29-JAN-15
Backup Piece 33 29-JAN-15 /home/oracle/disk/same__DB01143.bkp
Backup Set 34 29-JAN-15
Backup Piece 34 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-02
Backup Set 35 29-JAN-15
Backup Piece 35 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-03
Backup Set 36 29-JAN-15
Backup Piece 36 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-04
Backup Set 37 29-JAN-15
Backup Piece 37 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-05
Backup Set 38 29-JAN-15
Backup Piece 38 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-06
Backup Set 39 29-JAN-15
Backup Piece 39 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-07
Backup Set 40 29-JAN-15
Backup Piece 40 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-08
Backup Set 41 29-JAN-15
Backup Piece 41 29-JAN-15 /home/oracle/disk1/user_bs_DB01151.bkp
Backup Set 42 29-JAN-15
Backup Piece 42 29-JAN-15 /home/oracle/disk2/user_bs_DB01152.bkp
Backup Set 43 29-JAN-15
Backup Piece 43 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-09
Backup Set 44 29-JAN-15
Backup Piece 44 29-JAN-15 /home/oracle/disk1/user_bs_DB01155.bkp
Backup Set 45 29-JAN-15
Backup Piece 45 29-JAN-15 /home/oracle/disk2/user_bs_DB01156.bkp
Backup Set 46 29-JAN-15
Backup Piece 46 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-0a
Backup Set 48 29-JAN-15
Backup Piece 48 29-JAN-15 /home/oracle/disk1/user_bs_DB01159.bkp
Backup Set 47 29-JAN-15
Backup Piece 47 29-JAN-15 /home/oracle/disk2/user_bs_DB01160.bkp
Backup Set 49 29-JAN-15
Backup Piece 49 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-0b
Control File Copy 3 29-JAN-15 /home/oracle/disk1/user_bs_DB01167.bkp
Backup Set 53 29-JAN-15
Backup Piece 53 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-0c
Control File Copy 4 29-JAN-15 /u01/oracle/11G/dbs/cf_D-DB01_id-1467107934_25ptvig1
Backup Set 54 29-JAN-15
Backup Piece 54 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-0d
Backup Set 55 29-JAN-15
Backup Piece 55 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-0e
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_26/o1_mf_nnndf_TAG20150126T235449_bddrtcn9_.bkp recid=1 stamp=870047691
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_26/o1_mf_s_870047902_bdds103y_.bkp recid=2 stamp=870047904
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T233853_bdhd8fbr_.bkp recid=3 stamp=870133133
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_27/o1_mf_s_870133136_bdhd8lqh_.bkp recid=4 stamp=870133138
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T234242_bdhdhm4f_.bkp recid=5 stamp=870133363
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T234242_bdhdhm7h_.bkp recid=6 stamp=870133363
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_27/o1_mf_s_870133365_bdhdhp9q_.bkp recid=7 stamp=870133366
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_28/o1_mf_s_870135174_bdhg86lh_.bkp recid=10 stamp=870135174
deleted backup piece
backup piece handle=/home/oracle/disk1/user_bs_DB01123.bkp recid=13 stamp=870137495
deleted backup piece
backup piece handle=/home/oracle/disk2/user_bs_DB01124.bkp recid=14 stamp=870137495
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T231801_bdkzf9lp_.bkp recid=15 stamp=870218281
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_28/o1_mf_s_870218284_bdkzff3k_.bkp recid=16 stamp=870218285
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T232638_bdkzxgwt_.bkp recid=17 stamp=870218798
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-02 recid=18 stamp=870218802
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T232922_bdl02lq5_.bkp recid=19 stamp=870218962
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-03 recid=20 stamp=870218964
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T233646_bdl0jgck_.bkp recid=21 stamp=870219406
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-04 recid=22 stamp=870219408
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T235448_bdl1l922_.bkp recid=23 stamp=870220489
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-05 recid=24 stamp=870220493
deleted backup piece
backup piece handle=/home/oracle/disk1/user_bs_DB01135.bkp recid=25 stamp=870220524
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-06 recid=26 stamp=870220526
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T235832_bdl1s8t6_.bkp recid=27 stamp=870220712
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-07 recid=28 stamp=870220728
deleted backup piece
backup piece handle=/home/oracle/disk/DB01/backupset/2015_01_29/o1_mf_nnndf_TAG20150129T000104_bdl1y10r_.bkp recid=29 stamp=870220865
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-00 recid=30 stamp=870220869
deleted backup piece
backup piece handle=/home/oracle/disk/same__DB01141.bkp recid=31 stamp=870220935
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-01 recid=32 stamp=870220938
deleted backup piece
backup piece handle=/home/oracle/disk/same__DB01143.bkp recid=33 stamp=870292703
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-02 recid=34 stamp=870292720
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-03 recid=35 stamp=870299417
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-04 recid=36 stamp=870299430
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-05 recid=37 stamp=870299448
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-06 recid=38 stamp=870299463
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-07 recid=39 stamp=870299478
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-08 recid=40 stamp=870299498
deleted backup piece
backup piece handle=/home/oracle/disk1/user_bs_DB01151.bkp recid=41 stamp=870299510
deleted backup piece
backup piece handle=/home/oracle/disk2/user_bs_DB01152.bkp recid=42 stamp=870299513
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-09 recid=43 stamp=870299657
deleted backup piece
backup piece handle=/home/oracle/disk1/user_bs_DB01155.bkp recid=44 stamp=870301670
deleted backup piece
backup piece handle=/home/oracle/disk2/user_bs_DB01156.bkp recid=45 stamp=870301671
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0a recid=46 stamp=870301797
deleted backup piece
backup piece handle=/home/oracle/disk1/user_bs_DB01159.bkp recid=48 stamp=870302055
deleted backup piece
backup piece handle=/home/oracle/disk2/user_bs_DB01160.bkp recid=47 stamp=870302057
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0b recid=49 stamp=870302081
deleted control file copy
control file copy filename=/home/oracle/disk1/user_bs_DB01167.bkp recid=3 stamp=870303931
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0c recid=53 stamp=870302589
deleted control file copy
control file copy filename=/u01/oracle/11G/dbs/cf_D-DB01_id-1467107934_25ptvig1 recid=4 stamp=870304258
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0d recid=54 stamp=870303933
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0e recid=55 stamp=870304260
Deleted 50 objects
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 /tmp/controlfile.ctl
RMAN-06214: Backup Piece /home/oracle/disk1
RMAN-06214: Backup Piece /home/oracle/disk2
RMAN-06214: Backup Piece /u01/oracle/11G/dbs/user_bs_DB01119
RMAN-06214: Backup Piece /u01/oracle/11G/dbs/user_bs_DB01120
RMAN> crosscheck Datafile Copy /tmp/controlfile.ctl;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "datafile": expecting one of: "archivelog, backup, backuppiece, backupset, copy, controlfilecopy, datafilecopy, proxy"
RMAN-01007: at line 1 column 12 file: standard input
RMAN> crosscheck Datafile Copy '/tmp/controlfile.ctl';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "datafile": expecting one of: "archivelog, backup, backuppiece, backupset, copy, controlfilecopy, datafilecopy, proxy"
RMAN-01007: at line 1 column 12 file: standard input
RMAN> crosscheck DatafileCopy '/tmp/controlfile.ctl';
released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=132 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=131 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 01/30/2015 00:17:24
RMAN-20230: datafile copy not found in the recovery catalog
RMAN-06015: error while looking up datafile copy name: /tmp/controlfile.ctl
RMAN> crosscheck controlfilecopy '/tmp/controlfile.ctl';
released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=132 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=131 devtype=DISK
validation failed for control file copy
control file copy filename=/tmp/controlfile.ctl recid=1 stamp=839539056
Crosschecked 1 objects
RMAN> report ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "device, need, obsolete, schema, unrecoverable"
RMAN-01007: at line 1 column 8 file: standard input
RMAN>
![———EMPORIOARMANI———FW23早秋新品[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)