BR Archive errors

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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