Skip to Content
avatar image
Former Member

BR Archive errors

Hi,

I have just started a backup of Redolog files with the attached

initGSD.sap file and getting the following error message:

16.11.2009 15:28:34 Job started

16.11.2009 15:28:34 Step 001 started (program

RSDBAJOB, variant &0000000000002, user ID ABDUL)

16.11.2009 15:28:34 Execute logical command BRARCHIVE

On host GILSAPED

16.11.2009 15:28:34 Parameters:-u / -jid

LOG__20091116152834 -c force -p initGSD.sap -cds -v /DEV/FLASHDRIVE0

16.11.2009 15:28:35 BR0002I BRARCHIVE 7.00 (43)

16.11.2009 15:28:35 BR0157E Value '/DEV/FLASHDRIVE0'

of option '-v' longer than 10 characters

16.11.2009 15:28:35

16.11.2009 15:28:35 BR0007I End of offline redo log

processing: aebxrrlr.log 2009-11-16 15.28.35

16.11.2009 15:28:35 BR0280I BRARCHIVE time stamp:

2009-11-16 15.28.35

16.11.2009 15:28:35 BR0005I BRARCHIVE terminated with

errors

16.11.2009 15:28:35 External program terminated with

exit code 3

16.11.2009 15:28:35 BRARCHIVE returned error status E

16.11.2009 15:28:35 Job finished

The destination I am using for storing backups is a USB drive connected

to an Unix system. The USB (/dev/flashdrive0) is not yet mounted, but can be accessed for read / write.

Please advise me on the config of the initSID.sap file as well. I have just changed the backup destination to /dev/flashdrive0 and nothing more.

Following is my initSID.sap file:

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

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

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

  4. default: all

backup_mode = all

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

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

  3. | <generic_path> | (<object_list>) | partial | non_db

  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 | online_standby | offstby_split | offstby_mirror

  4. default: offline

backup_type = offline

  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 = disk

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

  2. default: $SAPDATA_HOME/sapbackup

backup_root_dir = /dev/flashdrive0

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

  2. default: value of the backup_root_dir parameter

stage_root_dir = /dev/flashdrive0

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

  2. default: no

compress = no

  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 -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/GSD/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 = save

  1. directory for archive log copies to disk

  2. default: first value of the backup_root_dir parameter

archive_copy_dir = /dev/flashdrive0

  1. directory for archive log copies to stage

  2. default: first value of the stage_root_dir parameter

archive_stage_dir = /dev/flashdrive0

  1. delete archive logs from duplex destination [only | no | yes | check]

  2. default: only

  3. archive_dupl_del = only

  4. new sapdata home directory for disk_copy | disk_standby

  5. no default

  6. new_db_home = /oracle/C11

  7. stage sapdata home directory for stage_copy | stage_standby

  8. default: value of the new_db_home parameter

  9. stage_db_home = /oracle/C11

  10. original sapdata home directory for split mirror disk backup

  11. no default

  12. orig_db_home = /oracle/C11

  13. remote host name

  14. no default

  15. remote_host = <host_name>

  16. remote user name

  17. default: current operating system user

  18. remote_user = <user_name>

  19. tape copy command [cpio | cpio_gnu | dd | dd_gnu | rman | rman_gnu

  20. | rman_dd | rman_dd_gnu]

  21. default: cpio

tape_copy_cmd = cpio

  1. disk copy command [copy | copy_gnu | dd | dd_gnu | rman | rman_gnu

  2. | rman_set | rman_set_gnu | ocopy]

  3. default: copy

disk_copy_cmd = copy

  1. stage copy command [rcp | scp | ftp]

  2. default: rcp

stage_copy_cmd = rcp

  1. pipe copy command [rsh | ssh]

  2. default: rsh

pipe_copy_cmd = rsh

  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

  3. use flags -pdu for gnu tools

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. Windows: "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. Windows: "bs=nk", example: "bs=64k"

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

  1. number of members in RMAN save sets [ 1 | 2 | 3 | 4 | tsp | all ]

  2. default: 1

saveset_members = 1

  1. additional parameters for RMAN

  2. rman_channels and rman_filesperset are only used when rman_util,

  3. rman_disk or rman_stage

  4. rman_channels defines the number of parallel sbt channel allocations

  5. rman_filesperset = 0 means:

  6. one file per save set - for non-incremental backups

  7. all files in one save set - for incremental backups

  8. the others have the same meaning as for native RMAN

  9. rman_channels = 1

  10. rman_filesperset = 0

  11. rman_maxpiecesize = 0 # in KB - former name rman_kbytes

  12. rman_rate = 0 # in KB - former name rman_readrate

  13. rman_maxopenfiles = 0

  14. rman_maxsetsize = 0 # in KB - former name rman_setsize

  15. additional parameters for RMAN version 8.1

  16. the parameters have the same meaning as for native RMAN

  17. rman_diskratio = 0 # deprecated in Oracle 10g

  18. rman_pool = 0

  19. rman_copies = 0 | 1 | 2 | 3 | 4 # former name rman_duplex

  20. rman_proxy = no | yes | only

  21. special parameters for an external backup library, example:

  22. rman_parms = "BLKSIZE=65536 ENV=(BACKUP_SERVER=HOSTNAME)"

  23. rman_send = "'<command>'"

  24. rman_send = ("channel sbt_1 '<command1>' parms='<parameters1>'",

  25. "channel sbt_2 '<command2>' parms='<parameters2>'")

  26. rman_compress = no | yes

  27. rman_maxcorrupt = (<dbf_name>|<dbf_id>:<corr_cnt>, ...)

  28. remote copy-out command (backup_dev_type = pipe)

  29. $-character is replaced by current device address

  30. no default

copy_out_cmd = "dd ibs=8k obs=64k of=$"

  1. remote copy-in command (backup_dev_type = pipe)

  2. $-character is replaced by current device address

  3. no default

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

  1. rewind command

  2. $-character is replaced by current device address

  3. no default

  4. operating system dependent, examples:

  5. HP-UX: "mt -f $ rew"

  6. TRU64: "mt -f $ rewind"

  7. AIX: "tctl -f $ rewind"

  8. Solaris: "mt -f $ rewind"

  9. Windows: "mt -f $ rewind"

  10. Linux: "mt -f $ rewind"

rewind = "tctl -f $ rewind"

  1. rewind and set offline command

  2. $-character is replaced by current device address

  3. default: value of the rewind parameter

  4. operating system dependent, examples:

  5. HP-UX: "mt -f $ offl"

  6. TRU64: "mt -f $ offline"

  7. AIX: "tctl -f $ offline"

  8. Solaris: "mt -f $ offline"

  9. Windows: "mt -f $ offline"

  10. Linux: "mt -f $ offline"

rewind_offline = "tctl -f $ offline"

  1. tape positioning command

  2. first $-character is replaced by current device address

  3. second $-character is replaced by number of files to be skipped

  4. no default

  5. operating system dependent, examples:

  6. HP-UX: "mt -f $ fsf $"

  7. TRU64: "mt -f $ fsf $"

  8. AIX: "tctl -f $ fsf $"

  9. Solaris: "mt -f $ fsf $"

  10. Windows: "mt -f $ fsf $"

  11. Linux: "mt -f $ fsf $"

tape_pos_cmd = "tctl -f $ fsf $"

  1. mount backup volume command in auto loader / juke box

  2. used if backup_dev_type = tape_box | pipe_box

  3. no default

  4. mount_cmd = "<mount_cmd> $ $ $ [$]"

  5. dismount backup volume command in auto loader / juke box

  6. used if backup_dev_type = tape_box | pipe_box

  7. no default

  8. dismount_cmd = "<dismount_cmd> $ $ [$]"

  9. split mirror disks command

  10. used if backup_type = offline_split | online_split | offline_mirror

  11. | online_mirror

  12. no default

  13. split_cmd = "<split_cmd> [$]"

  14. resynchronize mirror disks command

  15. used if backup_type = offline_split | online_split | offline_mirror

  16. | online_mirror

  17. no default

  18. resync_cmd = "<resync_cmd> [$]"

  19. additional options for SPLITINT interface program

  20. no default

  21. split_options = "<split_options>"

  22. resynchronize after backup flag [no | yes]

  23. default: no

  24. split_resync = no

  25. pre-split command

  26. no default

  27. pre_split_cmd = "<pre_split_cmd>"

  28. post-split command

  29. no default

  30. post_split_cmd = "<post_split_cmd>"

  31. pre-shut command

  32. no default

  33. pre_shut_cmd = "<pre_shut_cmd>"

  34. post-shut command

  35. no default

  36. post_shut_cmd = "<post_shut_cmd>"

  37. volume size in KB = K, MB = M or GB = G (backup device dependent)

  38. default: 1200M

  39. recommended values for tape devices without hardware compression:

  40. 60 m 4 mm DAT DDS-1 tape: 1200M

  41. 90 m 4 mm DAT DDS-1 tape: 1800M

  42. 120 m 4 mm DAT DDS-2 tape: 3800M

  43. 125 m 4 mm DAT DDS-3 tape: 11000M

  44. 112 m 8 mm Video tape: 2000M

  45. 112 m 8 mm high density: 4500M

  46. DLT 2000 10/20 GB: 10000M

  47. DLT 2000XT 15/30 GB: 15000M

  48. DLT 4000 20/40 GB: 20000M

  49. DLT 7000 35/70 GB: 35000M

  50. recommended values for tape devices with hardware compression:

  51. 60 m 4 mm DAT DDS-1 tape: 1000M

  52. 90 m 4 mm DAT DDS-1 tape: 1600M

  53. 120 m 4 mm DAT DDS-2 tape: 3600M

  54. 125 m 4 mm DAT DDS-3 tape: 10000M

  55. 112 m 8 mm Video tape: 1800M

  56. 112 m 8 mm high density: 4300M

  57. DLT 2000 10/20 GB: 9000M

  58. DLT 2000XT 15/30 GB: 14000M

  59. DLT 4000 20/40 GB: 18000M

  60. DLT 7000 35/70 GB: 30000M

tape_size = 100G

  1. volume size in KB = K, MB = M or GB = G used by brarchive

  2. default: value of the tape_size parameter

  3. tape_size_arch = 100G

  4. level of parallel execution

  5. default: 0 - set to number of backup devices

exec_parallel = 0

  1. address of backup device without rewind

  2. [<dev_address> | (<dev_address_list>)]

  3. no default

  4. operating system dependent, examples:

  5. HP-UX: /dev/rmt/0mn

  6. TRU64: /dev/nrmt0h

  7. AIX: /dev/rmt0.1

  8. Solaris: /dev/rmt/0mn

  9. Windows: /dev/nmt0

  10. Linux: /dev/nst0

tape_address = /dev/rmt0.1

  1. address of backup device without rewind used by brarchive

  2. default: value of the tape_address parameter

  3. operating system dependent

  4. tape_address_arch = /dev/rmt0.1

  5. address of backup device with rewind

  6. [<dev_address> | (<dev_address_list>)]

  7. no default

  8. operating system dependent, examples:

  9. HP-UX: /dev/rmt/0m

  10. TRU64: /dev/rmt0h

  11. AIX: /dev/rmt0

  12. Solaris: /dev/rmt/0m

  13. Windows: /dev/mt0

  14. Linux: /dev/st0

tape_address_rew = /dev/rmt0

  1. address of backup device with rewind used by brarchive

  2. default: value of the tape_address_rew parameter

  3. operating system dependent

  4. tape_address_rew_arch = /dev/rmt0

  5. address of backup device with control for mount/dismount command

  6. [<dev_address> | (<dev_address_list>)]

  7. default: value of the tape_address_rew parameter

  8. operating system dependent

  9. tape_address_ctl = /dev/...

  10. address of backup device with control for mount/dismount command

  11. used by brarchive

  12. default: value of the tape_address_rew_arch parameter

  13. operating system dependent

  14. tape_address_ctl_arch = /dev/...

  15. volumes for brarchive

  16. [<volume_name> | (<volume_name_list>) | SCRATCH]

  17. no default

volume_archive = (GSDA01, GSDA02, GSDA03, GSDA04, GSDA05,

GSDA06, GSDA07, GSDA08, GSDA09, GSDA10,

GSDA11, GSDA12, GSDA13, GSDA14, GSDA15,

GSDA16, GSDA17, GSDA18, GSDA19, GSDA20,

GSDA21, GSDA22, GSDA23, GSDA24, GSDA25,

GSDA26, GSDA27, GSDA28, GSDA29, GSDA30)

  1. volumes for brbackup

  2. [<volume_name> | (<volume_name_list>) | SCRATCH]

  3. no default

volume_backup = (GSDB01, GSDB02, GSDB03, GSDB04, GSDB05,

GSDB06, GSDB07, GSDB08, GSDB09, GSDB10,

GSDB11, GSDB12, GSDB13, GSDB14, GSDB15,

GSDB16, GSDB17, GSDB18, GSDB19, GSDB20,

GSDB21, GSDB22, GSDB23, GSDB24, GSDB25,

GSDB26, GSDB27, GSDB28, GSDB29, GSDB30)

  1. expiration period for backup volumes in days

  2. default: 30

expir_period = 30

  1. recommended usages of backup volumes

  2. default: 100

tape_use_count = 100

Many other parameters are commented out in the default initSID.sap file and I have removed them from this question to keep the message short.

Regards

Abdul

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 17, 2009 at 07:23 AM

    Hi,

    16.11.2009 15:28:34 Parameters:-u / -jid

    LOG__20091116152834 -c force -p initGSD.sap -cds -v /DEV/FLASHDRIVE0

    You are taking backup on disk. Don't use -v option it is for volume.

    Aslo see the below link.

    http://sap.ittoolbox.com/groups/technical-functional/sap-basis/db13-database-backup-2648299

    Thanks,

    Shambo

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 17, 2009 at 07:26 AM

    Hi,

    Can you re-paste above message as readable....

    Just send us your query first after that only error messag, not all the content.

    *anyways issue looks like related to BRCONNECT

    Regards

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded