RMAN> list copy;
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
1 1 1 A 31-AUG-14 /u01/oracle/11G/dbs/arch1_1_857057445.dbf
2 1 2 A 02-SEP-14 /u01/oracle/11G/dbs/arch1_2_857057445.dbf
3 1 3 A 06-SEP-14 /u01/oracle/11G/dbs/arch1_3_857057445.dbf
4 1 4 A 18-NOV-14 /u01/oracle/11G/dbs/arch1_4_857057445.dbf
RMAN> delete copy;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=140 devtype=DISK
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
1 1 1 A 31-AUG-14 /u01/oracle/11G/dbs/arch1_1_857057445.dbf
2 1 2 A 02-SEP-14 /u01/oracle/11G/dbs/arch1_2_857057445.dbf
3 1 3 A 06-SEP-14 /u01/oracle/11G/dbs/arch1_3_857057445.dbf
4 1 4 A 18-NOV-14 /u01/oracle/11G/dbs/arch1_4_857057445.dbf
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archive log
archive log filename=/u01/oracle/11G/dbs/arch1_1_857057445.dbf recid=1 stamp=857217649
deleted archive log
archive log filename=/u01/oracle/11G/dbs/arch1_2_857057445.dbf recid=2 stamp=857520610
deleted archive log
archive log filename=/u01/oracle/11G/dbs/arch1_3_857057445.dbf recid=3 stamp=863992930
deleted archive log
archive log filename=/u01/oracle/11G/dbs/arch1_4_857057445.dbf recid=4 stamp=866222072
Deleted 4 objects
RMAN> list copy;
specification does not match any archive log in the recovery catalog
RMAN>
RMAN> run{
2> allocate channel c5 device type disk;
3> allocate channel c6 device type disk;
4> backup tablespace DTFILETS;
5> }
released channel: ORA_DISK_1
allocated channel: c5
channel c5: sid=140 devtype=DISK
allocated channel: c6
channel c6: sid=132 devtype=DISK
Starting backup at 02-FEB-15
channel c5: starting full datafile backupset
channel c5: specifying datafile(s) in backupset
input datafile fno=00005 name=/u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbf
channel c5: starting piece 1 at 02-FEB-15
channel c5: finished piece 1 at 02-FEB-15
piece handle=/u01/oracle/11G/dbs/01pu9u56_1_1 tag=TAG20150202T213118 comment=NONE
channel c5: backup set complete, elapsed time: 00:00:02
Finished backup at 02-FEB-15
released channel: c5
released channel: c6
RMAN> list copy;
specification does not match any archive log in the recovery catalog
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 1.16M DISK 00:00:01 02-FEB-15
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20150202T213118
Piece Name: /u01/oracle/11G/dbs/01pu9u56_1_1
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 1347509 02-FEB-15 /u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbf
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 1.16M DISK 00:00:01 02-FEB-15
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20150202T213118
Piece Name: /u01/oracle/11G/dbs/01pu9u56_1_1
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 1347509 02-FEB-15 /u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbf
RMAN> delete backup;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=140 devtype=DISK
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1 1 1 1 AVAILABLE DISK /u01/oracle/11G/dbs/01pu9u56_1_1
Do you really want to delete the above objects (enter YES or NO)? yes
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: Backup Piece /u01/oracle/11G/dbs/01pu9u56_1_1
RMAN> crosscheck backuppiece '/u01/oracle/11G/dbs/01pu9u56_1_1';
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/oracle/11G/dbs/01pu9u56_1_1 recid=1 stamp=870643879
Crosschecked 1 objects
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 1.16M DISK 00:00:01 02-FEB-15
BP Key: 1 Status: EXPIRED Compressed: NO Tag: TAG20150202T213118
Piece Name: /u01/oracle/11G/dbs/01pu9u56_1_1
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 1347509 02-FEB-15 /u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbf
RMAN> delete 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 /u01/oracle/11G/dbs/01pu9u56_1_1
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/01pu9u56_1_1 recid=1 stamp=870643879
Deleted 1 objects
RMAN>