Strange BRBackup error

[Former Member]

Hello all,

I am facing a strange issue with brbackup. When initiating a backup from brtools on the OS, the backup works perfectly. However, when i try to start the backup from DB13, it fails.

I'm running SAP 4.7 on Oracle 9.2.

I have added a part of the logs from both a succesfull and an unsuccesfull backup.

Can somebody shed some light on this?

Kind regards,

Cees

This is a part of the log of the failing backup :

BR0280I BRBACKUP time stamp: 2008-07-01 02.00.57

BR0057I Backup of database: DS1

BR0058I BRBACKUP action ID: bdygmzqe

BR0059I BRBACKUP function ID: anf

BR0110I Backup mode: ALL

BR0077I Database file for backup: K:\oracle\DS1\sapbackup\cntrlDS1.dbf

BR0061I 27 files found for backup, total size 71429.789 MB

BR0143I Backup type: online

BR0130I Backup device type: util_file

BR0109I Files will be saved by backup utility

BR0289I BRARCHIVE will be started at the end of processing

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

BR0280I BRBACKUP time stamp: 2008-07-01 02.00.57

BR0315I 'Alter tablespace PSAPDS1 begin backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 02.00.57

BR0315I 'Alter tablespace PSAPDS1620 begin backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 02.00.57

BR0315I 'Alter tablespace PSAPDS1USR begin backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 02.00.57

BR0315I 'Alter tablespace PSAPUNDO begin backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 02.00.57

BR0315I 'Alter tablespace SYSTEM begin backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 02.00.57

BR0315I 'Alter tablespace WISE begin backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 02.00.57

BR0229I Calling backup utility with function 'backup'...

BR0280I BRBACKUP time stamp: 2008-07-01 02.00.57

BR0279E Return code from 'L:\usr\sap\DS1\SYS\exe\run\backint.exe -u DS1 -f backup -i K:\oracle\DS1\sapbackup\.bdygmzqe.lst -t file -p J:\oracle\DS1\920\database\initDS1.utl -c': 128

BR0232E 0 of 27 files saved by backup utility

BR0280I BRBACKUP time stamp: 2008-07-01 02.00.57

BR0231E Backup utility call failed

BR0280I BRBACKUP time stamp: 2008-07-01 02.01.00

BR0317I 'Alter tablespace PSAPDS1 end backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 02.01.00

BR0317I 'Alter tablespace PSAPDS1620 end backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 02.01.01

BR0317I 'Alter tablespace PSAPDS1USR end backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 02.01.01

BR0317I 'Alter tablespace PSAPUNDO end backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 02.01.01

BR0317I 'Alter tablespace SYSTEM end backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 02.01.01

BR0317I 'Alter tablespace WISE end backup' successful

BR0056I End of database backup: bdygmzqe.anf 2008-07-01 02.00.57

BR0280I BRBACKUP time stamp: 2008-07-01 02.01.01

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2008-07-01 02.01.01

BR0291I BRARCHIVE will be started with options '-U -d util_file -c force -p initDS1.sap -cds'

BR0280I BRBACKUP time stamp: 2008-07-01 02.01.02

BR0292I Execution of BRARCHIVE finished with return code 5

-

---

This is a part of the logfile from the succesfull backup :

BR0280I BRBACKUP time stamp: 2008-07-01 12.53.52

BR0057I Backup of database: DS1

BR0058I BRBACKUP action ID: bdygpfpd

BR0059I BRBACKUP function ID: anf

BR0110I Backup mode: ALL

BR0077I Database file for backup: k:\oracle\DS1\sapbackup\cntrlDS1.dbf

BR0061I 27 files found for backup, total size 71429.789 MB

BR0143I Backup type: online

BR0130I Backup device type: util_file

BR0109I Files will be saved by backup utility

BR0280I BRBACKUP time stamp: 2008-07-01 12.53.52

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

BR0280I BRBACKUP time stamp: 2008-07-01 12.54.14

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRBACKUP time stamp: 2008-07-01 12.54.15

BR0315I 'Alter tablespace PSAPDS1 begin backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 12.54.15

BR0315I 'Alter tablespace PSAPDS1620 begin backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 12.54.15

BR0315I 'Alter tablespace PSAPDS1USR begin backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 12.54.15

BR0315I 'Alter tablespace PSAPUNDO begin backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 12.54.15

BR0315I 'Alter tablespace SYSTEM begin backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 12.54.15

BR0315I 'Alter tablespace WISE begin backup' successful

BR0280I BRBACKUP time stamp: 2008-07-01 12.54.15

BR0229I Calling backup utility with function 'backup'...

BR0278I Command output of 'L:\usr\sap\DS1\SYS\exe\run\backint.exe -u DS1 -f backup -i k:\oracle\DS1\sapbackup\.bdygpfpd.lst -t file -p J:\oracle\DS1\920\database\initDS1.utl':

WARNING: sort_backup_type not specified in .utl file

WARNING: default sort_backup_type to <size> for restore

********************************************************************************

Program: L:\usr\sap\DS1\SYS\exe\run\backint.exe 5.1

Input File: k:\oracle\DS1\sapbackup\.bdygpfpd.lst

Profile: J:\oracle\DS1\920\database\initDS1.utl

Function: BACKUP

Backup Type: BACKUP_FILE

********************************************************************************

[1832.00] Backup started 07/01/2008 12:54:15

[1832.00]

[1832.00] 12:54:17 Initiating backup

[1832.00] 12:54:28 INF - Waiting for mount of media id 000089 on server srv0002 for writing.

[1832.00] 12:54:29 INF - BACKUP START

[1832.00] 12:54:29 BKR - M:\

[1832.00] 12:54:29 BKR - M:\oracle\

[1832.00] 12:54:29 BKR - M:\oracle\DS1\

[1832.00] 12:54:29 BKR - M:\oracle\DS1\sapdata2\

[1832.00] 12:54:29 BKR - M:\oracle\DS1\sapdata2\undo_1\

[1832.00] 12:57:44 INF - Beginning backup on server srv0002 of client srv0044.

[1832.00] 13:11:51 BKR - M:\oracle\DS1\sapdata2\undo_1\UNDO.DATA1

[1832.00] 13:11:51 BKR - M:\

[Former Member]

Hello. Check errors in "event viewer' on OS, are you see any error ? Regards.

[Former Member]

Hi Sergo,

I don't see any errors in the event logs.

So no help there.

Regards,

Cees

[Former Member]

Try to add full authorizations on folder J:\oracle\DS1\920\database and on K:\oracle\DS1\sapbackup to, for SAPSERVICE"SID" user. Regards.

Edited by: Sergo Beradze on Jul 2, 2008 3:46 PM

[stefan_koehler]

Hello Cees,

what third party backup tool are you using (for example TDP, etc..)?

Do you run the brbackup command on the OS with the same user as the SAP is running with?

The BR*Tools are doing some pre-steps for the backup (tablespace backup mode) correct and if the "extern" backup tool is being used there is an error.

Have you a logfile for the third party tool?

Regards

Stefan

[Former Member]

Hi Sergo,

I added full control to sapservice<sid> and there's no change.

Regards,

Cees

[Former Member]

Are you can check logs in K:\oracle\DS1\sapbackup\ folder (check last by time) ? In DB13 the backup starts under sapservice<sid> user... and from SID"adm" user you can succesfully try backup? Regards.

[Former Member]

Hello Stefan,

The third party tool we are using is Veritas Netbackup.

I use sapservice<sid>, who is the same user as SAP is using for executing the backup.

The external tool is not initiating the backup, but only used as the administrative tool for the backups. the backup is initiated from sap to brbackup. setting the tablespaces is not the error in this case.

The third pasrty tool doesn't create a logfile, because the backup aborts before communicating with the backup-tool.

I suspect some environment variable or something, but i havent'found out which one.

Especially because doing the backup from BR*Tools works perfectly.

Regards,

Cees

[Former Member]

Hi Sergo,

starting a backup from both sapserviceDS1 and DS1adm works when started directly from the command line using BR*Tools.

Regards,

Cees