cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

BR278E error during backup

Former Member

on ‎08-26-2011 3:40 PM

0 Kudos

HI all,

Our database backup was running ok for the passed 3 months after the SAP system was installed. Recently, I keep getting BR278E error during backup. Below are the error message:

BR0202I Saving init_ora

BR0203I to /dev/rmt/0mn ...

BR0278E Command output of 'LANG=C cd /oracle/PRD/102_64/dbs && /usr/sap/PRD/SYS/

exe/run/brtools -f printarg initPRD.ora spfilePRD.ora | LANG=C cpio -ovB > /dev/

rmt/0mn':

initPRD.ora

spfilePRD.ora

^GEnd of medium on "output".

To continue, type device/file name when ready.

The SAP system is on Solaris/Oracle running ECC6.0. LTO-4 tape drive is used for the backup. Tape_size in initSID.sap is set to 720000M. Current database size is 128Gb.

What is the reason for the backup failure?

Rdgs,

Lim

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
‎08-26-2011 3:48 PM
0 Kudos

Hi Lim,

Are your other backups like archive log backups running Ok for this server?

If yes, please check if there is any changes in the files of online backup profile of brtools and the utl file being used.

Also, please check if the tape volumes are properly being mounted or not.

Refer to the link below for the discussion on a similar issue.

Br,

Venky.

Show replies
Show replies
Former Member
‎08-26-2011 4:15 PM
0 Kudos

Hi,

A LTO-4 tape capacity is around 800Gb uncompress. My database is only 128Gb. Tape continuation should not apply right?

Rdgs

former_member524429
Active Contributor
‎08-26-2011 6:50 PM
0 Kudos

Hi,

Provide full backup action log information, which you can find as /oracle/<SID>/sapbackup location. Also provide snapshot of init<SID>.sap file parameter information. This will help anyone to have better idea about error causes & symptoms.

You can put tape_size = 800G in init<SID>.sap file.

Tape Media is Ok ?

Try to reinitialize tape again with force option and try again.

brbackup -i force -v SCRAP -c

Regards,

Bhavik G. Shroff

former_member184473
Active Contributor
‎08-26-2011 11:54 PM
0 Kudos

Hello,

Can you try the first backup with option -NSC?

Caution: You should only use the -NSC option if you are absolutely sure that the available space is sufficient!

Regards,

Eduardo Rezende

Former Member
‎08-27-2011 3:43 AM
0 Kudos

Hi,

This is my initSID.sap

  1. @(#) $Id: //bas/640_REL/src/ccm/rsbr/initSUN.sap#4 $ SAP

  2. backup mode [all | all_data | full | incr | sap_dir | ora_dir

  3. | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

  4. | <generic_path> | (<object_list>)]

  5. default: all

backup_mode = all

  1. restore mode [all | all_data | full | incr | incr_only | incr_full

  2. | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

  3. | <generic_path> | (<object_list>)]

  4. redirection with '=' is not supported here - use option '-m' instead

  5. default: all

restore_mode = all

  1. backup type [offline | offline_force | offline_standby | offline_split

  2. | offline_mirror | offline_stop | online | online_cons | online_split

  3. | online_mirror

  4. default: offline

backup_type = online

  1. backup device type

  2. [tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk

  3. | disk_copy | disk_standby | stage | stage_copy | stage_standby

  4. | util_file | util_file_online | rman_util | rman_disk | rman_stage

  5. | rman_prep]

  6. default: tape

backup_dev_type = tape

  1. backup root directory [<path_name> | (<path_name_list>)]

  2. default: $SAPDATA_HOME/sapbackup

backup_root_dir = /oracle/PRD/sapbackup

  1. stage root directory [<path_name> | (<path_name_list>)]

  2. default: value of the backup_root_dir parameter

stage_root_dir = /oracle/PRD/sapbackup

  1. compression flag [yes | no | hardware | only]

  2. default: no

compress = hardware

  1. compress command

  2. first $-character is replaced by the source file name

  3. second $-character is replaced by the target file name

  4. <target_file_name> = <source_file_name>.Z

  5. for compress command the -c option must be set

  6. recommended setting for brbackup -k only run:

  7. "compress -b 12 -c $ > $"

  8. no default

compress_cmd = "compress -b 12 -c $ > $"

  1. uncompress command

  2. first $-character is replaced by the source file name

  3. second $-character is replaced by the target file name

  4. <source_file_name> = <target_file_name>.Z

  5. for uncompress command the -c option must be set

  6. no default

uncompress_cmd = "uncompress -c $ > $"

  1. directory for compression [<path_name> | (<path_name_list>)]

  2. default: value of the backup_root_dir parameter

compress_dir = /oracle/PRD/sapreorg

  1. brarchive function [save | second_copy | double_save | save_delete

  2. | second_copy_delete | double_save_delete | copy_save

  3. | copy_delete_save | delete_saved | delete_copied]

  4. default: save

archive_function = copy_delete_save

  1. directory for archive log copies to disk

  2. default: first value of the backup_root_dir parameter

archive_copy_dir = /oracle/PRD/sapbackup

  1. directory for archive log copies to stage

  2. default: first value of the stage_root_dir parameter

archive_stage_dir = /oracle/PRD/sapbackup

  1. new sapdata home directory for disk_copy | disk_standby

  2. no default

  3. new_db_home = /oracle/C11

  4. stage sapdata home directory for stage_copy | stage_standby

  5. default: value of the new_db_home parameter

  6. stage_db_home = /oracle/C11

  7. original sapdata home directory for split mirror disk backup

  8. no default

  9. orig_db_home = /oracle/C11

  10. remote host name

  11. no default

  12. remote_host = <host_name>

  13. remote user name

  14. default: current operating system user

  15. remote_user = <user_name>

  16. tape copy command [cpio | cpio_gnu | dd | dd_gnu | rman | rman_dd]

  17. default: cpio

tape_copy_cmd = dd

  1. disk copy command [copy | dd | dd_gnu | rman]

  2. default: copy

disk_copy_cmd = copy

  1. stage copy command [rcp | ftp]

  2. default: rcp

stage_copy_cmd = rcp

  1. flags for cpio output command

  2. default: -ovB

cpio_flags = -ovB

  1. flags for cpio input command

  2. default: -iuvB

cpio_in_flags = -iuvB

  1. flags for cpio command for copy of directories to disk

  2. default: -pdcu

cpio_disk_flags = -pdcu

  1. flags for dd output command

  2. default: "obs=16k"

  3. recommended setting:

  4. Unix: "obs=nk bs=nk", example: "obs=64k bs=64k"

  5. NT: "bs=nk", example: "bs=64k"

dd_flags = "obs=64k bs=64k"

  1. flags for dd input command

  2. default: "ibs=16k"

  3. recommended setting:

  4. Unix: "ibs=nk bs=nk", example: "ibs=64k bs=64k"

  5. NT: "bs=nk", example: "bs=64k"

dd_in_flags = "ibs=64k bs=64k"

copy_in_cmd = "dd ibs=64k obs=8k if=$"

  1. rewind command

rewind = "mt -f $ rewind"

  1. rewind and set offline command

rewind_offline = "mt -f $ offline"

  1. tape positioning command

tape_pos_cmd = "mt -f $ fsf $"

  1. recommended values for tape devices with hardware compression:

tape_size = 720000M

  1. address of backup device without rewind

tape_address = /dev/rmt/0mn

  1. address of backup device with rewind

tape_address_rew = /dev/rmt/0m

  1. volumes for brarchive

volume_archive = (PRDA09, PRDA10)

  1. volumes for brbackup

volume_backup = (PRDB09, PRDB10)

  1. expiration period for backup volumes in days

expir_period = 5

  1. recommended usages of backup volumes

tape_use_count = 260

Edited by: limws1 on Aug 27, 2011 4:44 AM

Former Member
‎08-27-2011 4:07 AM
0 Kudos

Hi,

This is my backup log:

BR0051I BRBACKUP 7.00 (40)

BR0055I Start of database backup: begqinct.pnt 2011-08-27 10.34.03

BR0484I BRBACKUP log file: /oracle/PRD/sapbackup/begqinct.pnt

BR0477I Oracle pfile /oracle/PRD/102_64/dbs/initPRD.ora created from spfile /oracle/PRD/102_64/dbs/spfilePRD.ora

BR0280I BRBACKUP time stamp: 2011-08-27 10.34.04

BR0319I Control file copy created: /oracle/PRD/sapbackup/cntrlPRD.dbf 10657792

BR0101I Parameters

Name Value

oracle_sid PRD

oracle_home /oracle/PRD/102_64

oracle_profile /oracle/PRD/102_64/dbs/initPRD.ora

sapdata_home /oracle/PRD

sap_profile /oracle/PRD/102_64/dbs/initPRD.sap

backup_mode PSAPSR3USR

backup_type online

backup_dev_type tape

compress hardware

tape_copy_cmd dd

cpio_flags -ovB

cpio_in_flags -iuvB

dd_flags obs=64k bs=64k

dd_in_flags ibs=64k bs=64k

rewind mt -f $ rewind

rewind_offline mt -f $ offline

tape_size 720000.000 MB

tape_address /dev/rmt/0mn

tape_address_rew /dev/rmt/0m

volume_backup SCRATCH

expir_period 5

tape_use_count 260

exec_parallel 0

system_info oraprd/oraprd kesappr01 SunOS 5.10 Generic_144488-09 sun4u

oracle_info PRD 10.2.0.5.0 8192 6941 102807580 kesappr01 UTF8 UTF8

sap_info 701 SAPSR3 PRD S1826084239 R3_ORA 0020182996

make_info sun_64 OCI_102 Feb 21 2009

command_line brbackup -u / -t online -m PSAPSR3USR -p initPRD.sap -v SCRATCH

BR0280I BRBACKUP time stamp: 2011-08-27 10.34.04

BR0057I Backup of database: PRD

BR0058I BRBACKUP action ID: begqinct

BR0059I BRBACKUP function ID: pnt

BR0110I Backup mode: PARTIAL

BR0060I Tablespace for backup: PSAPSR3USR

BR0077I Database file for backup: /oracle/PRD/sapbackup/cntrlPRD.dbf

BR0061I 2 files found for backup, total size 85.172 MB

BR0143I Backup type: online

BR0113I Files will be compressed by hardware

BR0130I Backup device type: tape

BR0102I Following backup device will be used: /dev/rmt/0mn

BR0104I 1 scratch volume will be used

BR0280I BRBACKUP time stamp: 2011-08-27 10.34.04

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

BR0280I BRBACKUP time stamp: 2011-08-27 10.34.09

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0237I Scratch volume required in device /dev/rmt/0mn

BR0210I Please mount BRBACKUP volume, if you have not already done so

BR0280I BRBACKUP time stamp: 2011-08-27 10.34.09

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

BR0280I BRBACKUP time stamp: 2011-08-27 10.34.13

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRBACKUP time stamp: 2011-08-27 10.34.13

BR0226I Rewinding tape volume in device /dev/rmt/0m ...

BR0351I Restoring /oracle/PRD/sapbackup/.tape.hdr0

BR0355I from /dev/rmt/0mn ...

BR0241I Checking label on volume in device /dev/rmt/0mn

BR0280I BRBACKUP time stamp: 2011-08-27 10.34.14

BR0226I Rewinding tape volume in device /dev/rmt/0m ...

BR0202I Saving /oracle/PRD/sapbackup/.tape.hdr0

BR0203I to /dev/rmt/0mn ...

BR0209I Volume in device /dev/rmt/0mn has name SCRATCH

BR0202I Saving init_ora

BR0203I to /dev/rmt/0mn ...

BR0278E Command output of 'LANG=C cd /oracle/PRD/102_64/dbs && /usr/sap/PRD/SYS/exe/run/brtools -f printarg initPRD.ora spfilePRD.ora | LANG=C cpio -ovB > /dev/rmt/0mn':

initPRD.ora

spfilePRD.ora

End of medium on "output".

To continue, type device/file name when ready.

BR0280I BRBACKUP time stamp: 2011-08-27 10.34.25

BR0279E Return code from 'LANG=C cd /oracle/PRD/102_64/dbs && /usr/sap/PRD/SYS/exe/run/brtools -f printarg initPRD.ora spfilePRD.ora | LANG=C cpio -ovB > /dev/rmt/0mn': 0

BR0222E Copying init_ora to/from /dev/rmt/0mn failed due to previous errors

BR0221E Writing volume header files to /dev/rmt/0mn failed

BR0056I End of database backup: begqinct.pnt 2011-08-27 10.34.25

BR0280I BRBACKUP time stamp: 2011-08-27 10.34.26

BR0054I BRBACKUP terminated with errors

Former Member
‎08-27-2011 4:10 AM
0 Kudos

Hi Bhavik,

I have tried initializing a few tapes and backup onto these tapes. Brbackup still gives the same error.

Rdgs

Former Member
‎08-27-2011 4:17 AM
0 Kudos

Hi Eduardo,

What does option -NSC do? I cannot find this option in brbackup documentation of available options

Rdgs

former_member524429
Active Contributor
‎08-27-2011 6:38 AM
0 Kudos

Hi,

R u sure, you are using correct media (as mentioned by you..which is LTO4) ?

Tape Media is Ok ? Have you tried to do the same activities (tape initialization & perform DB backup using brbackup) ?

Can you set the parameter tape_size= 800G and try again to initialize the tape, proceed with db backup ?

You can refer these SAP Notes 8707 , 540543 to get more information on parameter tape_size.

Also see the tape status, when you get such error again by executing the following command.

mt -f status /dev/rmt/0mn

Regards,

Bhavik G. Shroff

Former Member
‎08-27-2011 7:43 AM
0 Kudos

Hi,

My backup has been running ok for the past 3 months on LTO-4 tape until recently. As mentioned, I have tried initailizing tapes and performed backup again with no success. Tape size value should be ok. I even set it to 30G and still doesn't work.

mt status returns no error. Using tar command to backup to tape seems ok but I am unable to retrieve the content table using tar -xvf. It returns checksum error.

Rdgs

former_member184473
Active Contributor
‎08-28-2011 3:56 PM
0 Kudos

Hello,

Option -NSC mens (No Space Check). Use it with the first backup only and make sure there is enough space available.

Regards,

Eduardo

Ask a Question