delete expired backup of database; fails

[roehrlh]

Hi,

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.

[Rick_Brown]

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]

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.

http://seer.entsupport.symantec.com/docs/270094.htm
 

[Nicolai]

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:
http://www.sc.ehu.es/siwebso/KZCC/Oracle_10g_Documentacion/server.101/b10770/rcmsynta5.htm