RMAN> crosscheck backup;

using channel ORA_DISK_1

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/bak/rman/backup_01p3d0c2_1_1 recid=1 stamp=842432898

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-00 recid=2 stamp=842433056

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/bak/ecoalchina_03p3d0ut_1_1 recid=3 stamp=842433501

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/bak/ecoalchina_04p3d128_1_1 recid=4 stamp=842433609

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-01 recid=5 stamp=842433610

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/bak/rman/backup_06p3d15m_1_1 recid=6 stamp=842433719

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/bak/rman/backup_07p3d15v_1_1 recid=7 stamp=842433728

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/bak/rman/backup_08p3d161_1_1 recid=8 stamp=842433729

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-02 recid=9 stamp=842433806

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/bak/rman/backup_0ap3d1gv_1_1 recid=10 stamp=842434080

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/bak/rman/backup_0bp3d1h7_1_1 recid=11 stamp=842434087

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/bak/rman/backup_0cp3d1h8_1_1 recid=12 stamp=842434089

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-03 recid=13 stamp=842434090

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/bak/rman/backup_0ep3d1p7_1_1 recid=14 stamp=842434344

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/bak/rman/backup_0fp3d1pb_1_1 recid=15 stamp=842434347

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-04 recid=16 stamp=842434349

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/bak/rman/backup_0hp3d1t0_1_1 recid=17 stamp=842434465

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-05 recid=18 stamp=842434469

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/bak/rman/backup_0jp3d2kb_1_1 recid=19 stamp=842435212

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/bak/rman/backup_0kp3d2kg_1_1 recid=20 stamp=842435216

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-06 recid=21 stamp=842435315

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/rman/backup_0np3d48r_1_1 recid=22 stamp=842436892

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-08 recid=23 stamp=842437771

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/rman/backup_0rp3d5dq_1_1 recid=24 stamp=842438075

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/rman/backup_0sp3d5k6_1_1 recid=25 stamp=842438279

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/rman/backup_0tp3d5km_1_1 recid=26 stamp=842438295

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/rman/backup_0up3d5ko_1_1 recid=27 stamp=842438297

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/rman/backup_0vp3d5kr_1_1 recid=28 stamp=842438299

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/rman/backup_10p3d5op_1_1 recid=29 stamp=842438426

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-09 recid=30 stamp=842438429

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-0a recid=31 stamp=842439151

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-0b recid=32 stamp=842439276

Crosschecked 32 objects

RMAN> delete expired backup;

using channel ORA_DISK_1

List of Backup Pieces

BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name

------- ------- --- --- ----------- ----------- ----------

1       1       1   1   EXPIRED     DISK        /bak/rman/backup_01p3d0c2_1_1

3       3       1   1   EXPIRED     DISK        /bak/ecoalchina_03p3d0ut_1_1

4       4       1   1   EXPIRED     DISK        /bak/ecoalchina_04p3d128_1_1

6       6       1   1   EXPIRED     DISK        /bak/rman/backup_06p3d15m_1_1

7       7       1   1   EXPIRED     DISK        /bak/rman/backup_07p3d15v_1_1

8       8       1   1   EXPIRED     DISK        /bak/rman/backup_08p3d161_1_1

10      10      1   1   EXPIRED     DISK        /bak/rman/backup_0ap3d1gv_1_1

11      11      1   1   EXPIRED     DISK        /bak/rman/backup_0bp3d1h7_1_1

12      12      1   1   EXPIRED     DISK        /bak/rman/backup_0cp3d1h8_1_1

14      14      1   1   EXPIRED     DISK        /bak/rman/backup_0ep3d1p7_1_1

15      15      1   1   EXPIRED     DISK        /bak/rman/backup_0fp3d1pb_1_1

17      17      1   1   EXPIRED     DISK        /bak/rman/backup_0hp3d1t0_1_1

19      19      1   1   EXPIRED     DISK        /bak/rman/backup_0jp3d2kb_1_1

20      20      1   1   EXPIRED     DISK        /bak/rman/backup_0kp3d2kg_1_1

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

deleted backup piece

backup piece handle=/bak/rman/backup_01p3d0c2_1_1 recid=1 stamp=842432898

deleted backup piece

backup piece handle=/bak/ecoalchina_03p3d0ut_1_1 recid=3 stamp=842433501

deleted backup piece

backup piece handle=/bak/ecoalchina_04p3d128_1_1 recid=4 stamp=842433609

deleted backup piece

backup piece handle=/bak/rman/backup_06p3d15m_1_1 recid=6 stamp=842433719

deleted backup piece

backup piece handle=/bak/rman/backup_07p3d15v_1_1 recid=7 stamp=842433728

deleted backup piece

backup piece handle=/bak/rman/backup_08p3d161_1_1 recid=8 stamp=842433729

deleted backup piece

backup piece handle=/bak/rman/backup_0ap3d1gv_1_1 recid=10 stamp=842434080

deleted backup piece

backup piece handle=/bak/rman/backup_0bp3d1h7_1_1 recid=11 stamp=842434087

deleted backup piece

backup piece handle=/bak/rman/backup_0cp3d1h8_1_1 recid=12 stamp=842434089

deleted backup piece

backup piece handle=/bak/rman/backup_0ep3d1p7_1_1 recid=14 stamp=842434344

deleted backup piece

backup piece handle=/bak/rman/backup_0fp3d1pb_1_1 recid=15 stamp=842434347

deleted backup piece

backup piece handle=/bak/rman/backup_0hp3d1t0_1_1 recid=17 stamp=842434465

deleted backup piece

backup piece handle=/bak/rman/backup_0jp3d2kb_1_1 recid=19 stamp=842435212

deleted backup piece

backup piece handle=/bak/rman/backup_0kp3d2kg_1_1 recid=20 stamp=842435216

Deleted 14 EXPIRED 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

-------------------- ------ ------------------ --------------------

Backup Set           2      17-MAR-14        

  Backup Piece       2      17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-00

Backup Set           5      17-MAR-14        

  Backup Piece       5      17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-01

Backup Set           9      17-MAR-14        

  Backup Piece       9      17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-02

Backup Set           13     17-MAR-14        

  Backup Piece       13     17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-03

Backup Set           16     17-MAR-14        

  Backup Piece       16     17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-04

Backup Set           18     17-MAR-14        

  Backup Piece       18     17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-05

Backup Set           21     17-MAR-14        

  Backup Piece       21     17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-06

Archive Log          12     17-MAR-14          /dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_03_10/o1_mf_1_71_9kvbkxjg_.arc

Backup Set           22     17-MAR-14        

  Backup Piece       22     17-MAR-14          /bak/rman/backup_0np3d48r_1_1

Backup Set           23     17-MAR-14        

  Backup Piece       23     17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-08

Backup Set           24     17-MAR-14        

  Backup Piece       24     17-MAR-14          /bak/rman/backup_0rp3d5dq_1_1

Backup Set           25     17-MAR-14        

  Backup Piece       25     17-MAR-14          /bak/rman/backup_0sp3d5k6_1_1

Backup Set           26     17-MAR-14        

  Backup Piece       26     17-MAR-14          /bak/rman/backup_0tp3d5km_1_1

Backup Set           27     17-MAR-14        

  Backup Piece       27     17-MAR-14          /bak/rman/backup_0up3d5ko_1_1

Backup Set           30     17-MAR-14        

  Backup Piece       30     17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-09

Backup Set           31     17-MAR-14        

  Backup Piece       31     17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-0a

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

deleted backup piece

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-00 recid=2 stamp=842433056

deleted backup piece

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-01 recid=5 stamp=842433610

deleted backup piece

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-02 recid=9 stamp=842433806

deleted backup piece

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-03 recid=13 stamp=842434090

deleted backup piece

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-04 recid=16 stamp=842434349

deleted backup piece

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-05 recid=18 stamp=842434469

deleted backup piece

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-06 recid=21 stamp=842435315

deleted archive log

archive log filename=/dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_03_10/o1_mf_1_71_9kvbkxjg_.arc recid=12 stamp=842437624

deleted backup piece

backup piece handle=/bak/rman/backup_0np3d48r_1_1 recid=22 stamp=842436892

deleted backup piece

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-08 recid=23 stamp=842437771

deleted backup piece

backup piece handle=/bak/rman/backup_0rp3d5dq_1_1 recid=24 stamp=842438075

deleted backup piece

backup piece handle=/bak/rman/backup_0sp3d5k6_1_1 recid=25 stamp=842438279

deleted backup piece

backup piece handle=/bak/rman/backup_0tp3d5km_1_1 recid=26 stamp=842438295

deleted backup piece

backup piece handle=/bak/rman/backup_0up3d5ko_1_1 recid=27 stamp=842438297

deleted backup piece

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-09 recid=30 stamp=842438429

deleted backup piece

backup piece handle=/bak/contf/ecoalchina_c-364029283-20140317-0a recid=31 stamp=842439151

Deleted 16 objects