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
bo...@dongenergy.dk<mailto:bo...@dongenergy.dk>
www.dongenergy.com<http://www.dongenergy.com/>
