RMAN DELETE or DELETE FORCE does not show error but LIST still display backup

(Doc ID 1265090.1)

Last updated on MARCH 19, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Jun-2013***

Symptoms

RMAN DELETE or DELETE FORCE command appears to be completed successfully without error, but LIST command still shows the deleted backups.

Even deleting the backups from OS and then marking them EXPIRED using CROSSCHECK command does not resolve the problem.

For example:


RMAN> list expired copy;

specification does not match any archive log in the recovery catalog

List of Datafile Copies
Key File S Completion Time Ckp SCN Ckp Time Name
------- ---- - --------------- ---------- --------------- ----
10297 17 X 03-AUG-10 36497934249 03-AUG-10 /u01/oradata/PROD/datafile/o1_mf_optier_b_1BNVhb4qf_.dbf
10299 19 X 03-AUG-10 36500718191 03-AUG-10 /u01/oradata/PROD/datafile/o1_mf_optier_l_1BNWbi0uj_.dbf
10301 21 X 03-AUG-10 36502264637 03-AUG-10 /u01/oradata/PROD/datafile/o1_mf_optier_l_1BNX33AWA_.dbf
10303 22 X 03-AUG-10 36503361565 03-AUG-10 /u01/oradata/PROD/datafile/o1_mf_optier_l_1BNXN8js1_.dbf

RMAN> delete force expired copy ;

released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=199 instance=LOPTD1 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=329 instance=LOPTD1 devtype=DISK
specification does not match any archive log in the recovery catalog

List of Datafile Copies
Key File S Completion Time Ckp SCN Ckp Time Name
------- ---- - --------------- ---------- --------------- ----
10297 17 X 03-AUG-10 36497934249 03-AUG-10 /u01/oradata/PROD/datafile/o1_mf_optier_b_1BNVhb4qf_.dbf
10299 19 X 03-AUG-10 36500718191 03-AUG-10 /u01/oradata/PROD/datafile/o1_mf_optier_l_1BNWbi0uj_.dbf
10301 21 X 03-AUG-10 36502264637 03-AUG-10 /u01/oradata/PROD/datafile/o1_mf_optier_l_1BNX33AWA_.dbf
10303 22 X 03-AUG-10 36503361565 03-AUG-10 /u01/oradata/PROD/datafile/o1_mf_optier_l_1BNXN8js1_.dbf

Do you really want to delete the above objects (enter YES or NO)? yes
deleted datafile copy
datafile copy filename=/u01/oradata/PROD/datafile/o1_mf_optier_b_1BNVhb4qf_.dbf recid=10297 stamp=726061430
deleted datafile copy
datafile copy filename=/u01/oradata/PROD/datafile/o1_mf_optier_l_1BNWbi0uj_.dbf recid=10299 stamp=726061909
deleted datafile copy
datafile copy filename=/u01/oradata/PROD/datafile/o1_mf_optier_l_1BNX33AWA_.dbf recid=10301 stamp=726062347
deleted datafile copy
datafile copy filename=/u01/oradata/PROD/datafile/o1_mf_optier_l_1BNXN8js1_.dbf recid=10303 stamp=726062727
Deleted 4 EXPIRED objects

RMAN> list expired copy;

list specification does not match any archive log in the recovery catalog

List of Datafile Copies
Key File S Completion Time Ckp SCN Ckp Time Name
------- ---- - --------------- ---------- --------------- ----
10297 17 X 03-AUG-10 36497934249 03-AUG-10 /u01/oradata/PROD/datafile/o1_mf_optier_b_1BNVhb4qf_.dbf
10299 19 X 03-AUG-10 36500718191 03-AUG-10 /u01/oradata/PROD/datafile/o1_mf_optier_l_1BNWbi0uj_.dbf
10301 21 X 03-AUG-10 36502264637 03-AUG-10 /u01/oradata/PROD/datafile/o1_mf_optier_l_1BNX33AWA_.dbf
10303 22 X 03-AUG-10 36503361565 03-AUG-10 /u01/oradata/PROD/datafile/o1_mf_optier_l_1BNXN8js1_.dbf



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms