Anyone know RMAN

From: ExecMan <artmerar_at_yahoo.com>
Date: Thu, 6 Oct 2011 12:16:13 -0700 (PDT)
Message-ID: <7e57286d-74be-4ec1-adc4-ff98bd3d69e2_at_n8g2000yqd.googlegroups.com>



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 Received on Thu Oct 06 2011 - 14:16:13 CDT

Original text of this message