>>> Response appended on behalf of Thomas Prause


BRBACKUP thinks that RMAN has not saved all objects:

BR0522E 112 of 108 files / save sets processed by RMAN

If you disagree you may open an incident at SAP. BRBACKUP
belongs to SAP BR*Tools and is not part of TSM for ERP.
(All messages prefixed with BR are from BR*Tools.
TSM for ERP messages have BKI.)

If you have only a single drive you could limit the number
of RMAN channels to one. Set 'rman_channels=1'
in /oracle/ECP/112_64/dbs/initECP.sap

Regards,
  Thomas


>
> From: "Stackwick, Stephen" <Stephen.Stackwick AT ICFI DOT COM>
> To: ADSM-L AT vm.marist DOT edu
> Date: 07/15/2014 03:05 PM
> Subject: TSM for ERP - RMAN backup apparently succeeds, BRBACKUP gives
up
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> Using RMAN to backup a 10.2 Oracle SAP database with TSM for ERP 6.
> 3. It seems when TSM preempts a drive, it kills the corresponding
> RMAN channel. Sounds reasonable, but apparently RMAN continues with
> the remaining channel(s) to finish the backup, obviously taking a
> little longer. But the TSM for ERP program BRBACKUP, doesn't seem
> able to deal with that and falls over:
>
> First, RMAN:
> RMAN-03009: failure of backup command on sbt_1 channel at 07/14/2014
22:19:05
> ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
> ORA-19511: Error received from media manager layer, error text:
>    BKI9309E: Operation terminated due to an explicit abort request.
> ORA-19502: write error on file "ECP_beohkssf.27102_1", block number
> 13010401 (block size=8192)
> ORA-27030: skgfwrt: sbtwrite2 returned error
> ORA-19511: Error received from media manager layer, error text:
>    BKI5008E: Tivoli Storage Manager Error.
> channel sbt_1 disabled, job failed on it will be run on another channel
> channel sbt_2: finished piece 1 at 14-JUL-14
> :
> :
> Finished backup at 15-JUL-14
>
> released channel: sbt_1
> released channel: sbt_2
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure of release command at 07/15/2014 04:04:46
> RMAN-06012: channel: sbt_1 not allocated
>
> RMAN>
>
> List of Backup Sets
> ===================
>
> RMAN proceeds to list all the backupsets and, indeed, they are all
> there and backed up. But, apparently, because of the RMAN-03002
> "error", BRBACKUP concludes there was a failure and ends the backup,
> reporting failure:
>
> Recovery Manager complete.
> BR0280I BRBACKUP time stamp: 2014-07-15 04.04.55
> BR0279E Return code from 'SHELL=/bin/sh /oracle/ECP/112_64/bin/rman
> nocatalog': 1
> BR0522E 112 of 108 files / save sets processed by RMAN
> BR0536E RMAN call for database instance ECP failed
> BR0200I BR_TRACE: location BrRmanCall-56, commands for RMAN in: /
> oracle/ECP/sapbackup/.beohkssf.cmd
> @/oracle/ECP/sapbackup/..beohkssf..cmd
> host '/usr/sap/ECP/SYS/exe/run/brtools -f delete /oracle/ECP/
> sapbackup/..beohkssf..cmd';
> run { allocate channel sbt_1 device type 'SBT_TAPE'
> parms 'ENV=(XINT_PROFILE=/oracle/ECP/112_64/dbs/
>
initECP.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=beohkssf.fnr)';
> allocate channel sbt_2 device type 'SBT_TAPE'
> parms 'ENV=(XINT_PROFILE=/oracle/ECP/112_64/dbs/
>
initECP.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=beohkssf.fnr)';
> backup incremental level 0 tag beohkssf format 'ECP_beohkssf.%s_%p'
> filesperset 4
> database;
> release channel sbt_1;
> release channel sbt_2; }
> list backup of database tag beohkssf;
> exit;
>
> BR0280I BRBACKUP time stamp: 2014-07-15 04.04.55
> BR0506E Full database backup (level 0) using RMAN failed
>
> BR0056I End of database backup: beohkssf.fnr 2014-07-15 04.04.55
> BR0280I BRBACKUP time stamp: 2014-07-15 04.04.57
> BR0054I BRBACKUP terminated with errors
>
> Doesn't seem right to me. Is there a workaround (I know, I know,
> have enough tape drives), or is this PMR territory?
>
> Steve Stackwick
>
> STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) |
> Stephen.Stackwick AT icfi DOT com<mailto:sstackwick AT icfi DOT com> | 
> icfi.com<
> http://www.icfi.com/>
> ICF INTERNATIONAL | 7125 Thomas Edison Dr, Suite 100, Columbia, Md
> 21046 | 443-573-0524, 443-718-4900 (o)
>