[ADSM-L] SAP RMAN full backup fails

Hi all,

I have a SAP BRBackup with RMAN, which after a Oracle upgrade fails.

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Apr 9 11:52:22 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN>
RMAN> connect target *
connected to target database: GQ1 (DBID=3371058019)
using target database control file instead of recovery catalog

RMAN> **end-of-file**

RMAN>
host command complete

RMAN> 2> 3> 4> 5> 6> 7> 8> 9>
executing command: SET BACKUP COPIES

allocated channel: sbt_1
channel sbt_1: SID=73 device type=SBT_TAPE
channel sbt_1: Data Protection for SAP(R)

allocated channel: sbt_2
channel sbt_2: SID=196 device type=SBT_TAPE
channel sbt_2: Data Protection for SAP(R)

Starting backup at 09-APR-13
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00006 name=K:\ORACLE\GQ1\SAPDATA2\SR3_3\SR3.DATA3
input datafile file number=00018 name=K:\ORACLE\GQ1\SAPDATA2\SR3_15\SR3.DATA15
input datafile file number=00027 name=K:\ORACLE\GQ1\SAPDATA2\SR3_24\SR3.DATA24
channel sbt_1: starting piece 1 at 09-APR-13
channel sbt_2: starting incremental level 0 datafile backup set
channel sbt_2: specifying datafile(s) in backup set
input datafile file number=00007 name=K:\ORACLE\GQ1\SAPDATA2\SR3_4\SR3.DATA4
input datafile file number=00019 name=K:\ORACLE\GQ1\SAPDATA2\SR3_16\SR3.DATA16
input datafile file number=00028 name=K:\ORACLE\GQ1\SAPDATA2\SR3_25\SR3.DATA25
channel sbt_2: starting piece 1 at 09-APR-13
RMAN-03009: failure of backup command on sbt_2 channel at 04/09/2013 12:35:00
ORA-19509: failed to delete sequential file, handle="GQ1_bekydgco.2816_1_1", 
parms="BLKSIZE=65536 
ENV=(XINT_PROFILE=E:\oracle\GQ1\11203\database\initGQ1.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=bekydgco.fnr)"
ORA-27027: sbtremove2 returned error
ORA-19511: Error received from media manager layer, error text:
channel sbt_2 disabled, job failed on it will be run on another channel
released channel: sbt_1
released channel: sbt_2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on sbt_1 channel at 04/09/2013 12:35:07
ORA-19509: failed to delete sequential file, handle="GQ1_bekydgco.2815_1_1", 
parms="BLKSIZE=65536 
ENV=(XINT_PROFILE=E:\oracle\GQ1\11203\database\initGQ1.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=bekydgco.fnr)"
ORA-27027: sbtremove2 returned error
ORA-19511: Error received from media manager layer, error text:

RMAN>
specification does not match any backup in the repository

RMAN>

Recovery Manager complete.
BR0280I BRBACKUP time stamp: 2013-04-09 12.35.10
BR0279E Return code from 'E:\oracle\GQ1\11203\BIN\rman nocatalog': 1
BR0522E 6 of 36 files / save sets processed by RMAN
BR0536E RMAN call for database instance GQ1 failed
BR0200I BR_TRACE: location BrRmanCall-56, commands for RMAN in: 
F:\oracle\GQ1\sapbackup\.bekydgco.cmd
@F:\oracle\GQ1\sapbackup\..bekydgco..cmd
host 'E:\usr\sap\GQ1\SYS\exe\uc\NTAMD64\brtools.exe -f delete 
F:\oracle\GQ1\sapbackup\..bekydgco..cmd';
run { set backup copies 1;
allocate channel sbt_1 device type 'SBT_TAPE'
parms 'BLKSIZE=65536 
ENV=(XINT_PROFILE=E:\oracle\GQ1\11203\database\initGQ1.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=bekydgco.fnr)';
allocate channel sbt_2 device type 'SBT_TAPE'
parms 'BLKSIZE=65536 
ENV=(XINT_PROFILE=E:\oracle\GQ1\11203\database\initGQ1.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=bekydgco.fnr)';
backup incremental level 0 tag bekydgco format 'GQ1_bekydgco.%s_%p_%c' 
filesperset 3 check logical
database;
release channel sbt_1;
release channel sbt_2; }
list backup of database tag bekydgco;
exit;

BR0280I BRBACKUP time stamp: 2013-04-09 12.35.10
BR0506E Full database backup (level 0) using RMAN failed

BR0056I End of database backup: bekydgco.fnr 2013-04-09 12.35.10
BR0280I BRBACKUP time stamp: 2013-04-09 12.35.12
BR0054I BRBACKUP terminated with errors


Full BRBackup was running fine before upgrade.
It's running on W2K8 R2 and SAP TSM Agent is 6.2.1.0.


Regards
Bo Nielsen
Senior Technology Consultant
Datacenter

DONG Energy
Nesa Allé 1
2820 
Gentofte<http://maps.google.com/maps?f=q&hl=da&geocode=&q=Nesa+All%c3%a9+1%2c+2820+Gentofte%2c+dk>

Tlf. +45 99 55 54 34

bokni AT dongenergy DOT dk<mailto:BOKNI AT dongenergy DOT dk>
www.dongenergy.com<http://www.dongenergy.com/>