Oracle backup fails

[former_member84399]

Hello all,

I am trying to backup my Oracle 10 database call PSP (part of a brand new PI 7.0 system) using brbackup 7.00 patch 24. It is running on Solaris 10

I execute command

brbackup -u / -c -d util_file_online -t online_cons -m all &

and I get the following error message

pisand:orapsp 123% BR0051I BRBACKUP 7.00 (24)

BR0055I Start of database backup: bdxpfrus.anf 2008-03-31 15.25.26

BR0484I BRBACKUP log file: /oracle/PSP/sapbackup/bdxpfrus.anf

BR0477I Oracle pfile /oracle/PSP/102_64/dbs/initPSP.ora created from spfile /oracle/PSP/102_64/dbs/spfilePSP.ora

BR0280I BRBACKUP time stamp: 2008-03-31 15.25.28

BR0319I Control file copy created: /oracle/PSP/sapbackup/cntrlPSP.dbf 12664832

BR0280I BRBACKUP time stamp: 2008-03-31 15.25.28

BR0057I Backup of database: PSP

BR0058I BRBACKUP action ID: bdxpfrus

BR0059I BRBACKUP function ID: anf

BR0110I Backup mode: ALL

BR0077I Database file for backup: /oracle/PSP/sapbackup/cntrlPSP.dbf

BR0061I 16 files found for backup, total size 23272.195 MB

BR0143I Backup type: online_cons

BR0130I Backup device type: util_file_online

BR0109I Files will be saved by backup utility

BR0142I Files will be switched to backup status during the backup

BR0126I Unattended mode active - no operator confirmation required

BR0280I BRBACKUP time stamp: 2008-03-31 15.25.28

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

BR0278I Command output of '/usr/sap/PSP/SYS/exe/run/backint -u PSP -f backup -i /oracle/PSP/sapbackup/.bdxpfrus.lst -t file_online -p /oracle/PSP/102_64/dbs/initPSP.utl -c':

ERROR: incorrect format or option in .utl file (-p)BR0280I BRBACKUP time stamp: 2008-03-31 15.25.29

BR0279E Return code from '/usr/sap/PSP/SYS/exe/run/backint -u PSP -f backup -i /oracle/PSP/sapbackup/.bdxpfrus.lst -t file_online -p /oracle/PSP/102_64/dbs/initPSP.utl -c': 2

BR0232E 0 of 16 files saved by backup utility

BR0280I BRBACKUP time stamp: 2008-03-31 15.25.29

BR0231E Backup utility call failed

BR0056I End of database backup: bdxpfrus.anf 2008-03-31 15.25.29

BR0280I BRBACKUP time stamp: 2008-03-31 15.25.31

BR0054I BRBACKUP terminated with errors

[1] Exit 5 brbackup -u / -c -d util_file_online -t online_cons -m all

Any ideas? My .utl and .sap files are copied from a system where the backup works fine and I have changed the SID and hostname references in there

Many thanks

Andreas

[markus_doehr2 · Accepted solution]

What backup software are you using? Backint is a program delivered by your backup software provider, check those logs.

Markus

[former_member84399 · Accepted solution]

Hello Markus and Fidel,

Thanks for your answers. I am using Netbackup 6.5. Since the SAP system that I am trying to backup is a new one, I took the .utl file from another system where the backup runs ok and changed the references of SID and parameter client in there

The netbackup logs as far as I know are under /usr/openv/netbackup/logs but I can not see anything at all in there (there is a directory called user_ops and inside it another one called nbjlogs but they are both empty)

Regards

Andreas

[fidel_vales · Accepted solution]

Hello Andreas,

It is normal that you do not see any error on the netbackup logs. The reason is that netbackup never was started.

Basically the "chain of events" should be

BRBACKUP is started, it gather the necessary data for the backup and it has to pass it to the backup tool. As the backup tool (netbackup in your case) is develop by a 3rd party company, SAP needs an interface between BRBACKUP and the backup tool.

This interface is called "BACKINT". Backint is develop by the same company as the backup tool. The backint gathers the data from BRBACKUP and send it to the backup tool (netbackup).

the error happens when BRBACKUP calls the BACKINT utility:

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

>BR0278I Command output of '/usr/sap/PSP/SYS/exe/run/backint -u PSP -f backup -i /oracle/PSP/sapbackup/.bdxpfrus.lst -t file_online -p /oracle/PSP/102_64/dbs/initPSP.utl -c':

>ERROR: incorrect format or option in .utl file (-p)BR0280I BRBACKUP time stamp: 2008-03-31 15.25.29

>BR0279E Return code from '/usr/sap/PSP/SYS/exe/run/backint -u PSP -f backup -i /oracle/PSP/sapbackup/.bdxpfrus.lst -t file_online -p /oracle/PSP/102_64/dbs/initPSP.utl -c': 2

As the backint call has failed, then the backup tool is not started, no logs from the backup tool.

As indicated before the issue seem to be in the configuration of the backint, parameter file "/oracle/PSP/102_64/dbs/initPSP.utl"

You should check the content of this file, it is a non SAP tool, perhaps someone here is using the same utility as you, but you should check this file and the documentation of it. I do not know if this documentation is "freely" available or where could be available.

[former_member84399]

Thank you all for your replies. I am embarrased to say that I hadn't copied all the relevant scripts under the netbackup scripts folder in the local system. When this was done , it worked fine

Thanks again

Andreas

[fidel_vales]

Hello,

As Markus indicated, you are using a 3rd party tool and it seems that it is not properly configured:

> *ERROR: incorrect format or option in .utl file (-p)*BR0280I BRBACKUP time stamp: 2008-03-31 15.25.29

The utl file is the configuration file for the backint and it seems that it contain a wrong parameter, option ...

> BR0279E Return code from '/usr/sap/PSP/SYS/exe/run/backint -u PSP -f backup -i /oracle/PSP/sapbackup/.bdxpfrus.lst -t file_online -p /oracle/PSP/102_64/dbs/initPSP.utl -c': 2

review the file /oracle/PSP/102_64/dbs/initPSP.utl and the documentation of your 3rd party tool