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

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=CHINA
Received on Thu Oct 06 2011 - 15:57:55 CDT

Original text of this message