BR*Tools RMAN_PREP issue

[Former Member]

Folks,

On our NW 7.4 ABAP system with Oracle 11G we face issues with the RMAN_PREP activity. (We did test this also with the latest version of BR*Tools!)

We use the feature on all of our systems, but only the NW 7.4 ABAP is not functioning properly.

Backups etc are running fine so hopefully you have some thought that can fix this issue...

Error:

C:\Windows\system32>brbackup -u / -c force -d rman_prep -p initBWO.sap -m ALL

BR0051I BRBACKUP 7.40 (16)

BR0055I Start of database backup: besvwfdo.rmp 2016-04-01 14:41:52

BR0484I BRBACKUP log file: F:\oracle\BWO\sapbackup\besvwfdo.rmp

BR0477I Oracle pfile D:\oracle\BWO\11204\database\initBWO.ora created from spfile D:\oracle\BWO\11204\database\sp

fileBWO.ora

BR0280I BRBACKUP time stamp: 2016-04-01 14:41:53

BR0057I Backup of database: BWO

BR0058I BRBACKUP action ID: besvwfdo

BR0059I BRBACKUP function ID: rmp

BR0110I Backup mode: ALL

BR0077I Database file for backup: D:\ORACLE\BWO\CNTRL\CNTRLBWO.DBF

BR0061I 56 files found for backup, total size 510236.570 MB

BR0143I Backup type: online

BR0130I Backup device type: rman_prep

BR0523I Preparation for using RMAN only - no backup

BR0140I Number of parallel copy processes: 2

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0525I Preparing backup of F:\ORACLE\BWO\SAPDATA2\BWO_43\BWO.DATA43 using RMAN...

BR0525I Preparing backup of F:\ORACLE\BWO\SAPDATA2\BWO_44\BWO.DATA44 using RMAN...

BR0278E Command output of 'D:\oracle\BWO\11204\BIN\rman nocatalog':

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Apr 1 14:41:53 2016

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

RMAN>

RMAN> connect target *

connected to target database: BWO (DBID=2668774452)

using target database control file instead of recovery catalog

RMAN> **end-of-file**

RMAN>

host command complete

RMAN> 2> 3> 4> 5> 6>

allocated channel: sbt

channel sbt: SID=43 device type=SBT_TAPE

channel sbt: MMS Version 7.20.36.6

executing command: SET NOCFAU

Starting backup at 2016-04-01 14:41:54

channel sbt: starting full datafile backup set

channel sbt: specifying datafile(s) in backup set

input datafile file number=00042 name=F:\ORACLE\BWO\SAPDATA2\BWO_43\BWO.DATA43

channel sbt: starting piece 1 at 2016-04-01 14:41:55

released channel: sbt

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on sbt channel at 04/01/2016 14:41:56

ORA-19506: failed to create sequential file, name="besvwfdo.42", parms=""

ORA-27007: failed to open file

ORA-19511: Error received from media manager layer, error text:

   SBT error = 7008, errno = 0, sbtopen: i/o error

RMAN>

specification does not match any backup in the repository

RMAN>

Recovery Manager complete.

BR0278E Command output of 'BRSBTLIB':

#LOCK F:\oracle\BWO\sapbackup\.lock.brb

#CMD brtools -f rmanprep - 20971528192 0

BR0252E Function CreateProcess() failed for 'brtools -f rmanprep - 20971528192 0' at location BrPipeCreate-9

BR0253E errno 2: The system cannot find the file specified.

BR0272E Execution of program 'brtools -f rmanprep - 20971528192 0' through pipe failed

BR0280I BRSBTLIB time stamp: 2016-04-01 14.41.55

BR0538E Copying of data by BRSBTLIB failed

BR0280I BRSBTLIB time stamp: 2016-04-01 14.41.55

BR0537E BRSBTLIB call sbtopen() failed

BR0280I BRBACKUP time stamp: 2016-04-01 14:41:57

BR0279E Return code from 'D:\oracle\BWO\11204\BIN\rman nocatalog': 0

BR0536E RMAN call for database instance BWO failed

BR0200I BR_TRACE: location BrRmanCall-62, commands for RMAN in: F:\oracle\BWO\sapbackup\.besvwfdo.000

@F:\oracle\BWO\sapbackup\..besvwfdo..000

host 'brtools -f delete F:\oracle\BWO\sapbackup\..besvwfdo..000';

run { allocate channel sbt device type 'SBT_TAPE'

parms 'BLKSIZE=65536 ENV=(BR_ORACLE_SID=BWO,BR_ORACLE_HOME=D:\oracle\BWO\11204,BR_ORACLE_BASE=D:\oracle,SAPDATA_H

OME=F:\oracle\BWO,SAPEXE=E:\usr\sap\BWO\DVEBMGS00\exe)';

set nocfau;

backup as backupset full filesperset 9999 diskratio 0 tag besvwfdo format 'besvwfdo.42' check logical

datafile 'F:\ORACLE\BWO\SAPDATA2\BWO_43\BWO.DATA43';

release channel sbt; }

list backup of datafile 42 tag besvwfdo;

exit;

Thanks in advance!

[former_member207186]

Hi,

Regarding this issue, you can check SAP Note 636847 - "Composite SAP note ORA-19511" for troubleshooting.

Regards,

Bíborka