Hi,

Any help with this? It lists the archivelog, but it will not remove
it. It does not exist on disk either.


RMAN> list backup;

List of Backup Sets
===================

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1777 20.54M DISK 00:00:08 18-SEP-11
BP Key: 1231 Status: EXPIRED Compressed: YES Tag:
TAG20110918T055949
Piece Name: /backup/oracle/OR00/rman/archive/
arc_09182011_OR00_11777

List of Archived Logs in backup set 1777
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6697 31762458745 18-SEP-11 31763483819 18-SEP-11


RMAN> delete expired archivelog '/backup/oracle/OR00/rman/archive/
arc_09182011_OR00_11777';

released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
released channel: ORA_DISK_4
released channel: ORA_DISK_5
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=112 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=127 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=119 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=116 devtype=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: sid=132 devtype=DISK
RMAN-00571:
================================================== =========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
================================================== =========
RMAN-03002: failure of delete command at 10/06/2011 14:12:23
RMAN-20240: archived log not found in the recovery catalog
RMAN-06046: archive log name: /backup/oracle/OR00/rman/archive/
arc_09182011_OR00_11777

On Oct 6, 12:16*pm, ExecMan <artme... (AT) yahoo (DOT) com> wrote:
Have you done a crosscheck archivelog all? Tried to uncatalog it?
List expired? Which version are you on? Are you sure you got the
name right when you checked on disk? Any standby involved?

The fact that it is expired suggests you did a crosscheck, try a
delete force.

delete force noprompt backupset tag TAG20110918T055949

jg
--
@home.com is bogus.
http://media.cdc-software.com/RossER...omers_Oct5.pdf
http://finance.yahoo.com/q?s=CHINA

Try this:

change archivelog all crosscheck;


-- Phil