Video Screencast Help

delete expired backup of database; fails

Created: 27 May 2010 | 3 comments


I have a Problem with netbackup 6.5.3 and Oracle Agent. The agent ins running with HP-UX 11.23. The Backup is running very well. But the RMAN command "delete expired backup of database;" fails. 

RMAN> delete expired backup of database;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=958 devtype=DISK
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=364 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Veritas NetBackup for Oracle - Release 6.5 (2008052301)

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
358796  358795  1   1   EXPIRED     SBT_TAPE    data_full_KHV_20100518_mmle108q_P1_C1
359580  359579  1   1   EXPIRED     SBT_TAPE    data_full_KHV_20100519_mtle3kkr_P1_C1

Do you really want to delete the above objects (enter YES or NO)? yes
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_SBT_TAPE_1 channel at 05/27/2010 14:06:38
ORA-19509: failed to delete sequential file, handle="data_full_KHV_20100518_mmle108q_P1_C1", parms=""
ORA-27027: sbtremove2 returned error
ORA-19511: Error received from media manager layer, error text:
   Failed to remove, data_full_KHV_20100518_mmle108q_P1_C1, from image catalog.

the parameter for sbt is: CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(NB_ORA_SERV=nbbth,NB_ORA_CLIENT=hpuxclu1)';

I have no idea what going wrong.

Thanks for support.

Comments 3 CommentsJump to latest comment

Rick Brown's picture

It looks like you're trying to delete the Netbackup backup image from RMAN.
Would it work better to simply exipre the image in Netbackup?

Will Restore's picture

Indeed, an older version document says:

Do not run explicit delete commands for RMAN images. Let NetBackup automatically expire RMAN related NetBackup images based on retention settings in the Oracle backup policy.

Will Restore -- where there is a Will there is a way

Nicolai's picture

I am not a Oracle expert, but don't you need to use the  "ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt" command.

The oracle docs say "To manually allocate a channel in preparation for issuing a CHANGE, DELETE,or CROSSCHECK  command"

Oracle 10 doc's:

Assumption is the mother of all mess ups.

If this post answered your'e qustion -  Please mark as a soloution.