cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle backup fails with BR0279E status

Former Member
0 Kudos

Dear friends,

SAP backups is failing with following message.

kindly help me to get it resolved.

SAP_SCHEDULED = 1

SAP_USER_INITIATED = 0

SAP_SERVER = lonvsnsmbk001_bkp

SAP_POLICY = SCP_backup

SAP_SCHED =

SAP_SNC_SCHED = Weekly

Execute setenv SAP_SERVER lonvsnsmbk001_bkp; setenv SAP_POLICY SCP_backup; setenv SAP_SNC_SCHED Weekly; brbackup -u / -c -d util_file_online -t online -m al

l

#########################################################################

  1. This system is for the use of authorized users only. #

  2. Individuals using this computer system without authority, or in #

  3. excess of their authority, are subject to having all of their #

  4. activities on this system monitored and recorded by system #

  5. personnel. #

  6. #

  7. In the course of monitoring individuals improperly using this #

  8. system, or in the course of system maintenance, the activities #

  9. of authorized users may also be monitored. #

  10. #

  11. Anyone using this system expressly consents to such monitoring #

  12. and is advised that if such monitoring reveals possible #

  13. evidence of criminal activity, system personnel may provide the #

  14. evidence of such monitoring to law enforcement officials. #

#########################################################################

BR0051I BRBACKUP 7.00 (40)

BR0055I Start of database backup: beeywrsv.anf 2011-01-09 06.31.25

BR0484I BRBACKUP log file: /oracle/SCP/sapbackup/beeywrsv.anf

BR0477I Oracle pfile /oracle/SCP/102_64/dbs/initSCP.ora created from spfile /oracle/SCP/102_64/dbs/spfileSCP.ora

BR0280I BRBACKUP time stamp: 2011-01-09 06.31.26

BR0319I Control file copy created: /oracle/SCP/sapbackup/cntrlSCP.dbf 12664832

BR0280I BRBACKUP time stamp: 2011-01-09 06.31.26

BR0057I Backup of database: SCP

BR0058I BRBACKUP action ID: beeywrsv

BR0059I BRBACKUP function ID: anf

BR0110I Backup mode: ALL

BR0077I Database file for backup: /oracle/SCP/sapbackup/cntrlSCP.dbf

BR0061I 22 files found for backup, total size 46730.242 MB

BR0143I Backup type: online

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: 2011-01-09 06.31.26

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

BR0278I Command output of '/usr/sap/SCP/SYS/exe/run/backint -u SCP -f backup -i /oracle/SCP/sapbackup/.beeywrsv.lst -t file_online -p /oracle/SCP/102_64/dbs/

initSCP.utl -c':

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

Program: /usr/sap/SCP/SYS/exe/run/backint 6.5

Input File: /oracle/SCP/sapbackup/.beeywrsv.lst

Profile: /oracle/SCP/102_64/dbs/initSCP.utl

Function: BACKUP

Backup Type: BACKUP_FILE_ONLINE

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

06:31:27.843 [24209] <1> : Requested to keep </oracle/SCP/sapdata2/srm_8/srm.data8> in backup mode/offline.

06:31:27.843 [24209] <1> : Requested to keep </oracle/SCP/sapdata3/srm_1/srm.data1> in backup mode/offline.

06:31:27.843 [24209] <1> : Requested to keep </oracle/SCP/sapdata3/srm_2/srm.data2> in backup mode/offline.

06:31:27.843 [24209] <1> : Requested to keep </oracle/SCP/sapdata3/srm_3/srm.data3> in backup mode/offline.

06:31:27.843 [24209] <1> : Requested to keep </oracle/SCP/sapdata3/srm_4/srm.data4> in backup mode/offline.

06:31:27.843 [24209] <1> : Requested to keep </oracle/SCP/sapdata4/srm_5/srm.data5> in backup mode/offline.

06:31:27.843 [24209] <1> : Requested to keep </oracle/SCP/sapdata4/srm_6/srm.data6> in backup mode/offline.

06:31:27.843 [24209] <1> : Requested to keep </oracle/SCP/sapdata4/srm_7/srm.data7> in backup mode/offline.

06:31:27.843 [24209] <1> : Requested to keep </oracle/SCP/sapdata1/srm701_1/srm701.data1> in backup mode/offline.

06:31:27.843 [24209] <1> : Requested to keep </oracle/SCP/sapdata1/srm701_2/srm701.data2> in backup mode/offline.

06:31:27.843 [24209] <1> : Requested to keep </oracle/SCP/sapdata1/srm701_3/srm701.data3> in backup mode/offline.

06:31:27.843 [24209] <1> : Requested to keep </oracle/SCP/sapdata2/srm701_4/srm701.data4> in backup mode/offline.

06:31:27.844 [24209] <1> : Requested to keep </oracle/SCP/sapdata2/srm701_5/srm701.data5> in backup mode/offline.

06:31:27.844 [24209] <1> : Requested to keep </oracle/SCP/sapdata2/srm701_6/srm701.data6> in backup mode/offline.

06:31:27.844 [24209] <1> : Requested to keep </oracle/SCP/sapdata2/srm701_7/srm701.data7> in backup mode/offline.

06:31:27.844 [24209] <1> : Requested to keep </oracle/SCP/sapdata2/srm701_8/srm701.data8> in backup mode/offline.

06:31:27.844 [24209] <1> : Requested to keep </oracle/SCP/sapdata2/srm701_9/srm701.data9> in backup mode/offline.

06:31:27.844 [24209] <1> : Requested to keep </oracle/SCP/sapdata4/srmusr_1/srmusr.data1> in backup mode/offline.

06:31:27.844 [24209] <1> : Requested to keep </oracle/SCP/sapdata1/undo_1/undo.data1> in backup mode/offline.

06:31:27.844 [24209] <1> : Requested to keep </oracle/SCP/sapdata1/sysaux_1/sysaux.data1> in backup mode/offline.

06:31:27.844 [24209] <1> : Requested to keep </oracle/SCP/sapdata1/system_1/system.data1> in backup mode/offline.

06:31:27.844 [24209] <1> : Requested to keep </oracle/SCP/sapbackup/cntrlSCP.dbf> in backup mode/offline.

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.28

#BEGIN /oracle/SCP/sapdata2/srm_8/srm.data8

BR0315I 'Alter tablespace PSAPSRM begin backup' successful

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.29

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.31

#BEGIN /oracle/SCP/sapdata3/srm_1/srm.data1

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.31

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.35

#BEGIN /oracle/SCP/sapdata3/srm_2/srm.data2

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.35

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.37

#BEGIN /oracle/SCP/sapdata3/srm_3/srm.data3

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.37

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.41

#BEGIN /oracle/SCP/sapdata3/srm_4/srm.data4

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.41

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.43

#BEGIN /oracle/SCP/sapdata4/srm_5/srm.data5

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.43

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.47

#BEGIN /oracle/SCP/sapdata4/srm_6/srm.data6

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.47

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.49

#BEGIN /oracle/SCP/sapdata4/srm_7/srm.data7

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.49

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.53

#BEGIN /oracle/SCP/sapdata1/srm701_1/srm701.data1

BR0315I 'Alter tablespace PSAPSRM701 begin backup' successful

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.53

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.55

#BEGIN /oracle/SCP/sapdata1/srm701_2/srm701.data2

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.55

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.59

#BEGIN /oracle/SCP/sapdata1/srm701_3/srm701.data3

BR0280I BRCONNECT time stamp: 2011-01-09 06.31.59

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.01

#BEGIN /oracle/SCP/sapdata2/srm701_4/srm701.data4

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.02

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.04

#BEGIN /oracle/SCP/sapdata2/srm701_5/srm701.data5

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.04

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.08

#BEGIN /oracle/SCP/sapdata2/srm701_6/srm701.data6

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.08

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.10

#BEGIN /oracle/SCP/sapdata2/srm701_7/srm701.data7

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.10

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.14

#BEGIN /oracle/SCP/sapdata2/srm701_8/srm701.data8

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.14

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.16

#BEGIN /oracle/SCP/sapdata2/srm701_9/srm701.data9

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.16

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.20

#BEGIN /oracle/SCP/sapdata4/srmusr_1/srmusr.data1

BR0315I 'Alter tablespace PSAPSRMUSR begin backup' successful

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.20

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.22

#BEGIN /oracle/SCP/sapdata1/undo_1/undo.data1

BR0315I 'Alter tablespace PSAPUNDO begin backup' successful

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.22

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.26

#BEGIN /oracle/SCP/sapdata1/sysaux_1/sysaux.data1

BR0315I 'Alter tablespace SYSAUX begin backup' successful

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.26

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.28

#BEGIN /oracle/SCP/sapdata1/system_1/system.data1

BR0315I 'Alter tablespace SYSTEM begin backup' successful

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.28

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.32

#BEGIN /oracle/SCP/sapbackup/cntrlSCP.dbf

BR0280I BRCONNECT time stamp: 2011-01-09 06.32.33

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata2/srm_8/srm.data8> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata3/srm_1/srm.data1> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata3/srm_2/srm.data2> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata3/srm_3/srm.data3> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata3/srm_4/srm.data4> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata4/srm_5/srm.data5> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata4/srm_6/srm.data6> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata4/srm_7/srm.data7> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata1/srm701_1/srm701.data1> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata1/srm701_2/srm701.data2> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata1/srm701_3/srm701.data3> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata2/srm701_4/srm701.data4> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata2/srm701_5/srm701.data5> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata2/srm701_6/srm701.data6> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata2/srm701_7/srm701.data7> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata2/srm701_8/srm701.data8> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata2/srm701_9/srm701.data9> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata4/srmusr_1/srmusr.data1> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata1/undo_1/undo.data1> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata1/sysaux_1/sysaux.data1> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapdata1/system_1/system.data1> is kept in backup mode/offline.

06:32:33.989 [24209] <1> : </oracle/SCP/sapbackup/cntrlSCP.dbf> is kept in backup mode/offline.

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

BR0280I BRBACKUP time stamp: 2011-01-09 06.32.36

BR0279E Return code from '/usr/sap/SCP/SYS/exe/run/backint -u SCP -f backup -i /oracle/SCP/sapbackup/.beeywrsv.lst -t file_online -p /oracle/SCP/102_64/dbs/i

nitSCP.utl -c': 2

BR0232E 0 of 22 files saved by backup utility

BR0280I BRBACKUP time stamp: 2011-01-09 06.32.36

BR0231E Backup utility call failed

BR0280I BRBACKUP time stamp: 2011-01-09 06.32.38

BR0317I 'Alter tablespace PSAPSRM end backup' successful

BR0280I BRBACKUP time stamp: 2011-01-09 06.32.38

BR0317I 'Alter tablespace PSAPSRM701 end backup' successful

BR0280I BRBACKUP time stamp: 2011-01-09 06.32.38

BR0317I 'Alter tablespace PSAPSRMUSR end backup' successful

BR0280I BRBACKUP time stamp: 2011-01-09 06.32.38

BR0317I 'Alter tablespace PSAPUNDO end backup' successful

BR0280I BRBACKUP time stamp: 2011-01-09 06.32.38

BR0317I 'Alter tablespace SYSAUX end backup' successful

BR0280I BRBACKUP time stamp: 2011-01-09 06.32.38

BR0317I 'Alter tablespace SYSTEM end backup' successful

BR0056I End of database backup: beeywrsv.anf 2011-01-09 06.32.36

BR0280I BRBACKUP time stamp: 2011-01-09 06.32.38

BR0054I BRBACKUP terminated with errors

Edited by: akasibe on Jan 9, 2011 9:49 AM

Edited by: akasibe on Jan 9, 2011 9:51 AM

Accepted Solutions (0)

Answers (2)

Answers (2)

markus_doehr2
Active Contributor
0 Kudos

> BR0280I BRBACKUP time stamp: 2011-01-09 06.32.36

> BR0279E Return code from '/usr/sap/SCP/SYS/exe/run/backint -u SCP -f backup -i /oracle/SCP/sapbackup/.beeywrsv.lst -t file_online -p /oracle/SCP/102_64/dbs/i

> nitSCP.utl -c': 2

backint is the tool provided by your backup software vendor - please check with him for that problem.

Markus

Former Member
0 Kudos

This backup is failing after customer has performed restoration for this instance from previous backup that was taken on tape.

=========================================

BR0280I BRBACKUP time stamp: 2011-01-09 06.32.36

BR0279E Return code from '/usr/sap/SCP/SYS/exe/run/backint -u SCP -f backup -i /oracle/SCP/sapbackup/.beeywrsv.lst -t file_online -p /oracle/SCP/102_64/dbs/i

nitSCP.utl -c': 2

BR0232E 0 of 22 files saved by backup utility

BR0280I BRBACKUP time stamp: 2011-01-09 06.32.36

BR0231E Backup utility call failed

=============================================

Former Member
0 Kudos

What is your external backup tool?

Anyway, this external backup tool should write logfiles of its own, and you should find more information there.