"BR0522E 112 of 108 files / save sets processed by RMAN"
Haha! The reason it backed up 4 MORE files than it had to was the fact that
RMAN retried and successfully backed up the 4 files that failed. BR*Tools must
be using a "~=" test, I guess.
Thanks for the suggestion. We'll probably open a ticket with SAP if we can
duplicate the problem with the latest BR*Tools.
Steve
STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | Stephen.Stackwick AT
icfi DOT com | icfi.com
ICF INTERNATIONAL | 7125 Thomas Edison Dr, Suite 100, Columbia, Md 21046 |
443-573-0524, 443-718-4900 (o)
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
> Behalf Of Del Hoobler
> Sent: Tuesday, July 22, 2014 06:31
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] TSM for ERP - RMAN backup apparently succeeds,
> BRBACKUP gives up
>
> >>> 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,B
> R_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,B
> R_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)
> >
|
