Re: Anyone know RMAN
From: joel garry <joel-garry_at_home.com>
Date: Thu, 6 Oct 2011 13:57:55 -0700 (PDT)
Message-ID: <f5cf10c9-27ff-4866-938b-1314a11a281a_at_q25g2000vbx.googlegroups.com>
On Oct 6, 12:16 pm, ExecMan <artme..._at_yahoo.com> wrote:
> 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
Date: Thu, 6 Oct 2011 13:57:55 -0700 (PDT)
Message-ID: <f5cf10c9-27ff-4866-938b-1314a11a281a_at_q25g2000vbx.googlegroups.com>
On Oct 6, 12:16 pm, ExecMan <artme..._at_yahoo.com> wrote:
> 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
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
-- _at_home.com is bogus. http://media.cdc-software.com/RossERP/Letter_to_Customers_Oct5.pdf http://finance.yahoo.com/q?s=CHINAReceived on Thu Oct 06 2011 - 15:57:55 CDT