Skip to Content
avatar image
Former Member

Unable to take DB13 archivelog backup on tape - new tapedrive installed

Hi,

We have installed new tapedrive and while taking the archive log backup from DB13 it is giving the following errors

(ECC 6.0, Oracle 10.2.0.2, Win2k3)

BR0280I BRARCHIVE time stamp: 2010-04-20 15.19.03

BR0008I Offline redo log processing for database instance: DEV

BR0009I BRARCHIVE action ID: aedazpgn

BR0010I BRARCHIVE function ID: cds

BR0048I Archive function: copy_delete_save

BR0011I 44 offline redo log files found for processing, total size 2082.087 MB

BR0112I Files will not be compressed

BR0130I Backup device type: tape

BR0102I Following backup device will be used: /dev/nmt0

BR0103I Following backup volume will be used: DEVA08

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0208I Volume with name DEVA08 required in device /dev/nmt0

BR0280I BRARCHIVE time stamp: 2010-04-20 15.19.03

BR0226I Rewinding tape volume in device /dev/mt0 ...

BR0351I Restoring F:\oracle\DEV\sapreorg\.tape.hdr0

BR0355I from /dev/nmt0 ...

BR0241I Checking label on volume in device /dev/nmt0

BR0242I Scratch volume in device /dev/nmt0 will be renamed to DEVA08

BR0280I BRARCHIVE time stamp: 2010-04-20 15.19.03

BR0226I Rewinding tape volume in device /dev/mt0 ...

BR0202I Saving F:\oracle\DEV\sapreorg\.tape.hdr0

BR0203I to /dev/nmt0 ...

BR0209I Volume in device /dev/nmt0 has name DEVA08

BR0202I Saving init_ora

BR0203I to /dev/nmt0 ...

BR0202I Saving L:\oracle\DEV\102\database\initdev.sap

BR0203I to /dev/nmt0 ...

BR0280I BRARCHIVE time stamp: 2010-04-20 15.19.16

BR0198I Profiles saved successfully

BR0202I Saving M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001

BR0203I to /dev/nmt0 ...

BR0278E Command output of 'dd bs=128k conv=sync if=M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 of=/dev/nmt0':

dd: unable to initialize ASPI manager

dd: using NT tape support

dd: The request could not be performed because of an I/O device error.

dd: write error: The request could not be performed because of an I/O device error.

51+0 records in

50+0 records out

1 write error

dd: The request could not be performed because of an I/O device error.

BR0280I BRARCHIVE time stamp: 2010-04-20 16.19.22

BR0279E Return code from 'dd bs=128k conv=sync if=M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 of=/dev/nmt0': 1

BR0222E Copying M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 to/from /dev/nmt0 failed due to previous errors

BR0016I 0 offline redo log files processed, total size 0.000 MB

BR0007I End of offline redo log processing: aedazpgn.cds 2010-04-20 16.19.22

BR0280I BRARCHIVE time stamp: 2010-04-20 16.19.22

BR0005I BRARCHIVE terminated with errors

We are able to take OS backup and restore it.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

10 Answers

  • avatar image
    Former Member
    Apr 21, 2010 at 12:16 PM

    Hi,

    Gone through the note. Updated the drivers.

    parameters changed to

    tape_size = 320G to tape_size = 800G

    dd_flags = "bs=128k" to dd_flags = "bs=64k"

    dd_in_flags = "bs=128k" to dd_in_flags = "bs=64k"

    With both the parameters we are getting the errors. we are able to initilialize the tape from DB13

    If any parameters details pls check the above init<SID>.sap file

    Error in DB13

    BR0202I Saving M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001

    BR0203I to /dev/nmt0 ...

    BR0278E Command output of 'dd bs=128k conv=sync if=M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 of=/dev/nmt0':

    dd: unable to initialize ASPI manager

    dd: using NT tape support

    dd: The request could not be performed because of an I/O device error.

    dd: write error: The request could not be performed because of an I/O device error.

    32+0 records in

    31+0 records out

    1 write error

    dd: The I/O bus was reset.

    BR0280I BRARCHIVE time stamp: 2010-04-21 17.08.14

    BR0279E Return code from 'dd bs=128k conv=sync if=M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 of=/dev/nmt0': 1

    BR0222E Copying M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 to/from /dev/nmt0 failed due to previous errors

    BR0016I 0 offline redo log files processed, total size 0.000 MB

    BR0007I End of offline redo log processing: aedbeuyt.cds 2010-04-21 17.08.14

    BR0280I BRARCHIVE time stamp: 2010-04-21 17.08.14

    BR0005I BRARCHIVE terminated with errors

    Pls suggest

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi James,

      BR0278E Command output of 'dd bs=128k conv=sync if=M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 of=/dev/nmt0':

      Above entry in the log show the same value as previous... (bs=128k).

      As per the note, dd error may not occurs if the value is set to 64k in windows system.

      Either your profile init<SID>.sap was not saved after correcting the parameter or you are using some different profile in DB13 backup scheduler....

      Kindly check the same, It should reflect the value (64k) in the log also...

      Did you check taking other backup using NTBACKUP. it will help you to isolate the problem and troubleshoot it.

      Regards.

      Rajesh Narkhede

      Edited by: Rajesh Narkhede on Apr 22, 2010 8:51 AM

  • avatar image
    Former Member
    Apr 20, 2010 at 01:18 PM

    Hi,

    We have installed new tapedrive and while taking the archive log backup from DB13 it is giving the following errors

    (ECC 6.0, Oracle 10.2.0.2, Win2k3)

    BR0280I BRARCHIVE time stamp: 2010-04-20 15.19.03

    BR0008I Offline redo log processing for database instance: DEV

    BR0009I BRARCHIVE action ID: aedazpgn

    BR0010I BRARCHIVE function ID: cds

    BR0048I Archive function: copy_delete_save

    BR0011I 44 offline redo log files found for processing, total size 2082.087 MB

    BR0112I Files will not be compressed

    BR0130I Backup device type: tape

    BR0102I Following backup device will be used: /dev/nmt0

    BR0103I Following backup volume will be used: DEVA08

    BR0134I Unattended mode with 'force' active - no operator confirmation allowed

    BR0208I Volume with name DEVA08 required in device /dev/nmt0

    BR0280I BRARCHIVE time stamp: 2010-04-20 15.19.03

    BR0226I Rewinding tape volume in device /dev/mt0 ...

    BR0351I Restoring F:\oracle\DEV\sapreorg\.tape.hdr0

    BR0355I from /dev/nmt0 ...

    BR0241I Checking label on volume in device /dev/nmt0

    BR0242I Scratch volume in device /dev/nmt0 will be renamed to DEVA08

    BR0280I BRARCHIVE time stamp: 2010-04-20 15.19.03

    BR0226I Rewinding tape volume in device /dev/mt0 ...

    BR0202I Saving F:\oracle\DEV\sapreorg\.tape.hdr0

    BR0203I to /dev/nmt0 ...

    BR0209I Volume in device /dev/nmt0 has name DEVA08

    BR0202I Saving init_ora

    BR0203I to /dev/nmt0 ...

    BR0202I Saving L:\oracle\DEV\102\database\initdev.sap

    BR0203I to /dev/nmt0 ...

    BR0280I BRARCHIVE time stamp: 2010-04-20 15.19.16

    BR0198I Profiles saved successfully

    BR0202I Saving M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001

    BR0203I to /dev/nmt0 ...

    BR0278E Command output of 'dd bs=128k conv=sync if=M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 of=/dev/nmt0':

    dd: unable to initialize ASPI manager

    dd: using NT tape support

    dd: The request could not be performed because of an I/O device error.

    dd: write error: The request could not be performed because of an I/O device error.

    51+0 records in

    50+0 records out

    1 write error

    dd: The request could not be performed because of an I/O device error.

    BR0280I BRARCHIVE time stamp: 2010-04-20 16.19.22

    BR0279E Return code from 'dd bs=128k conv=sync if=M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 of=/dev/nmt0': 1

    BR0222E Copying M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 to/from /dev/nmt0 failed due to previous errors

    BR0016I 0 offline redo log files processed, total size 0.000 MB

    BR0007I End of offline redo log processing: aedazpgn.cds 2010-04-20 16.19.22

    BR0280I BRARCHIVE time stamp: 2010-04-20 16.19.22

    BR0005I BRARCHIVE terminated with errors

    We are able to take OS backup and restore it.

    we have made the changes and kept cpio instead of dd in initDEV.sap and it is showing running for more than 2 hours.

    Please find below the log

    BR0280I BRARCHIVE time stamp: 2010-04-20 16.33.32

    BR0008I Offline redo log processing for database instance: DEV

    BR0009I BRARCHIVE action ID: aedazvwi

    BR0010I BRARCHIVE function ID: cds

    BR0048I Archive function: copy_delete_save

    BR0011I 44 offline redo log files found for processing, total size 2082.087 MB

    BR0112I Files will not be compressed

    BR0130I Backup device type: tape

    BR0102I Following backup device will be used: /dev/nmt0

    BR0103I Following backup volume will be used: DEVA08

    BR0134I Unattended mode with 'force' active - no operator confirmation allowed

    BR0208I Volume with name DEVA08 required in device /dev/nmt0

    BR0280I BRARCHIVE time stamp: 2010-04-20 16.33.32

    BR0226I Rewinding tape volume in device /dev/mt0 ...

    Please suggest

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      The error would be

      > dd: unable to initialize ASPI manager dd: using NT tape support dd: The request could not be performed because of an I/O device error. dd: write error: The request could not be performed because of an I/O device error. 510 records in 500 records out 1 write error dd: The request could not be performed because of an I/O device error. BR0280I BRARCHIVE time stamp: 2010-04-20 16.19.22 BR0279E Return code from 'dd bs=128k conv=sync if=M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 of=/dev/nmt0':

      Can you give us the below parameters;

      tape_Address

      tape_address_rew

      Also the tape address you have given is correct? Try to take a backup from command line in to the same tape at OS level (Some os level backup)

      Regards,

      Kishore soma

  • avatar image
    Former Member
    Apr 21, 2010 at 06:15 AM

    Hi

    We are able to take NTBACKUP on tapes.

    Below is the init<SID>.sap file

    1. @(#) $Id: //bas/700_REL/src/ccm/rsbr/initNT.sap#9 $ SAP

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

    1. #

    2. SAP BR*Tools sample profile. #

    3. The parameter syntax is the same as for init.ora parameters. #

    4. Enclose parameter values which consist of more than one symbol in #

    5. double quotes. #

    6. After any symbol, parameter definition can be continued on the next #

    7. line. #

    8. A parameter value list should be enclosed in parentheses, the list #

    9. items should be delimited by commas. #

    10. There can be any number of white spaces (blanks, tabs and new lines) #

    11. between symbols in parameter definition. #

    12. Comment lines must start with a hash character. #

    13. #

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

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

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

    2. default: %SAPDATA_HOME%\sapbackup

    backup_root_dir = F:\oracle\DEV\sapbackup

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

    2. default: value of the backup_root_dir parameter

    stage_root_dir = F:\oracle\DEV\sapbackup

    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. "%SAPEXE%\mkszip -l 0 -c $ > $"

    8. no default

    compress_cmd = "E:\usr\sap\DEV\SYS\exe\nuc\NTIA64\mkszip -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 = "E:\usr\sap\DEV\SYS\exe\nuc\NTIA64\uncompress -c $ > $"

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

    2. default: value of the backup_root_dir parameter

    compress_dir = F:\oracle\DEV\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 = F:\oracle\DEV\sapbackup

    1. directory for archive log copies to stage

    2. default: first value of the stage_root_dir parameter

    archive_stage_dir = F:\oracle\DEV\sapbackup

    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 = X:\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 = dd

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

    2. 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. caution: option "obs=" not supported for Windows

    4. recommended setting:

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

    6. Windows: "bs=nk", example: "bs=64k"

    dd_flags = "bs=128k"

    1. flags for dd input command

    2. default: "ibs=16k"

    3. caution: option "ibs=" not supported for Windows

    4. recommended setting:

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

    6. Windows: "bs=nk", example: "bs=64k"

    dd_in_flags = "bs=128k"

    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 = "mt -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 = "mt -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 = "mt -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. volume size in KB = K, MB = M or GB = G (backup device dependent)

    32. default: 1200M

    33. recommended values for tape devices without hardware compression:

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

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

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

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

    38. 112 m 8 mm Video tape: 2000M

    39. 112 m 8 mm high density: 4500M

    40. DLT 2000 10/20 GB: 10000M

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

    42. DLT 4000 20/40 GB: 20000M

    43. DLT 7000 35/70 GB: 35000M

    44. recommended values for tape devices with hardware compression:

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

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

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

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

    49. 112 m 8 mm Video tape: 1800M

    50. 112 m 8 mm high density: 4300M

    51. DLT 2000 10/20 GB: 9000M

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

    53. DLT 4000 20/40 GB: 18000M

    54. DLT 7000 35/70 GB: 30000M

    tape_size = 320G

    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 = 320G

    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 | /dev/nst0

    10. Linux: /dev/nst0

    tape_address = /dev/nmt0

    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/nmt0

    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 | /dev/st0

    14. Linux: /dev/st0

    tape_address_rew = /dev/mt0

    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/mt0

    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 = (DEVA01, DEVA02, DEVA03, DEVA04, DEVA05,

    DEVA06, DEVA07, DEVA08, DEVA09, DEVA10,

    DEVA11, DEVA12, DEVA13, DEVA14, DEVA15,

    DEVA16, DEVA17, DEVA18, DEVA19, DEVA20,

    DEVA21, DEVA22, DEVA23, DEVA24, DEVA25,

    DEVA26, DEVA27, DEVA28, DEVA29, DEVA30)

    1. volumes for brbackup

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

    3. no default

    volume_backup = (DEVB01, DEVB02, DEVB03, DEVB04, DEVB05,

    DEVB06, DEVB07, DEVB08, DEVB09, DEVB10,

    DEVB11, DEVB12, DEVB13, DEVB14, DEVB15,

    DEVB16, DEVB17, DEVB18, DEVB19, DEVB20,

    DEVB21, DEVB22, DEVB23, DEVB24, DEVB25,

    DEVB26, DEVB27, DEVB28, DEVB29, DEVB30)

    1. expiration period for backup volumes in days

    2. default: 30

    expir_period = 0

    1. recommended usages of backup volumes

    2. default: 100

    tape_use_count = 100

    1. backup utility parameter file

    2. default: no parameter file

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Have you checked the "tape size", "dd_flags" and "dd_in_flags" parameter in init<SID>.sap ?

      Refer the below note:

      [Note 540543 - Composite SAP note: dd errors when calling in BR tools|https://service.sap.com/sap/support/notes/540543]

      You can also first run "brbackup -k only" command and then try to take the backup again.

      If it doen't help you, check the following things:

      1. Try to take small backup using NTBACKUP (just for testing...).

      2. The problem may be with your SCSI cable which connect Tape drive to Server.

      3. Check if there is any Drivers are available for your Tape Drive.

      Problem must be at OS level not SAP (DB13 Configuration)

      Regards.

      Rajesh Narkhede

  • avatar image
    Former Member
    Apr 22, 2010 at 06:18 AM

    Hi ,

    PF below the logs:

    E:\usr\sap\DEV\SYS\exe\nuc\NTIA64>mt -f /dev/nmt0 status

    mt: unable to initialize ASPI manager

    mt: using NT tape support

    Default block size = 65536

    Minimum block size = 2

    Maximum block size = 2097152

    Current block size = 0

    Drive supports error correction

    Hardware data compression: on

    E:\usr\sap\DEV\SYS\exe\nuc\NTIA64>mt -f /dev/nmt0 rewind

    mt: unable to initialize ASPI manager

    mt: using NT tape support

    E:\usr\sap\DEV\SYS\exe\nuc\NTIA64>mt -f /dev/nmt0 offline

    mt: unable to initialize ASPI manager

    mt: using NT tape support

    DB13 logs after changing dd bs=64k from 128

    BR0241I Checking label on volume in device /dev/nmt0

    BR0242I Scratch volume in device /dev/nmt0 will be renamed to DEVA08

    BR0280I BRARCHIVE time stamp: 2010-04-22 10.34.55

    BR0226I Rewinding tape volume in device /dev/mt0 ...

    BR0202I Saving F:\oracle\DEV\sapreorg\.tape.hdr0

    BR0203I to /dev/nmt0 ...

    BR0209I Volume in device /dev/nmt0 has name DEVA08

    BR0202I Saving init_ora

    BR0203I to /dev/nmt0 ...

    BR0202I Saving L:\oracle\DEV\102\database\initdev.sap

    BR0203I to /dev/nmt0 ...

    BR0280I BRARCHIVE time stamp: 2010-04-22 10.35.07

    BR0198I Profiles saved successfully

    BR0202I Saving M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001

    BR0203I to /dev/nmt0 ...

    BR0278E Command output of 'dd bs=64k conv=sync if=M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 of=/dev/nmt0':

    dd: unable to initialize ASPI manager

    dd: using NT tape support

    dd: The request could not be performed because of an I/O device error.

    dd: write error: The request could not be performed because of an I/O device error.

    234+0 records in

    233+0 records out

    1 write error

    dd: The request could not be performed because of an I/O device error.

    BR0280I BRARCHIVE time stamp: 2010-04-22 11.15.13

    BR0279E Return code from 'dd bs=64k conv=sync if=M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 of=/dev/nmt0': 1

    BR0222E Copying M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 to/from /dev/nmt0 failed due to previous errors

    BR0016I 0 offline redo log files processed, total size 0.000 MB

    BR0007I End of offline redo log processing: aedbilqw.cds 2010-04-22 11.15.13

    BR0280I BRARCHIVE time stamp: 2010-04-22 11.15.13

    BR0005I BRARCHIVE terminated with errors

    If tape drive is not installed properly we may not able to take NTBACKUP and initialize tape from DB13 I suppose.

    Please suggest

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 22, 2010 at 06:42 AM
    Minimum block size = 2
    Maximum block size = 2097152
    Current block size = 0
    Drive supports error correction
    Hardware data compression: on

    Issue seems with block size, try to take one backup by changing compression mode(off/on).

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 22, 2010 at 12:28 PM

    what version of BR*tools are you using? I wold go get the latest version. The newer version use a different DD and CPIO program.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 23, 2010 at 07:36 PM

    Hi James,

    you can play diffrent blocksizes directly on this command

    'dd bs=64k conv=sync if=M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 of=/dev/nmt0':

    just to see if you can manage a successfull write.

    If this fails, you can either try to work through note 540543 or switch to rman, so it would be oracle

    writing directly to the tape. There is a combination of this according to note 1173119, but it is not

    fully supported yet.

    Volker

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 28, 2010 at 04:24 AM

    Hi,

    Changed the values to 512k but same issue.

    Can any one suggest how to check the ASPI installed or not

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Please consult with your hardware vendor or hardware engineer to find out which SCSI Adapter is installed in your server.

      Then check for the ASPI drivers for that manufacture/model.

      If it is "Adaptec" then below link may help you. There is tool called ASPICHK to check the drivers version and it's health.

      [http://web.ncf.ca/aa571/aspi.htm|http://web.ncf.ca/aa571/aspi.htm]

      You can download ASPI drivers from www.adaptec.com (download link is given in above link)

      It should work with other manufacturers also...

      PLEASE USE LATEST BRTOOLS

      Regards.

      Rajesh Narkhede

  • avatar image
    Former Member
    Apr 28, 2010 at 10:23 AM

    Hi,

    With 1024k

    BR0203I to /dev/nmt0 ...

    BR0278E Command output of 'dd bs=1024k conv=sync if=M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 of=/dev/nmt0':

    dd: unable to initialize ASPI manager

    dd: using NT tape support

    dd: The request could not be performed because of an I/O device error.

    dd: write error: The request could not be performed because of an I/O device error.

    11+0 records in

    10+0 records out

    1 write error

    dd: The I/O bus was reset.

    BR0280I BRARCHIVE time stamp: 2010-04-28 15.44.23

    BR0279E Return code from 'dd bs=1024k conv=sync if=M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 of=/dev/nmt0': 1

    BR0222E Copying M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 to/from /dev/nmt0 failed due to previous errors

    We have latest BRTOOLS

    Add comment
    10|10000 characters needed characters exceeded

    • ...

      most recent windows driver for the tape ?

      tape_copy_cmd = cpio

      ... will do worse performance than dd, but may be will save at least something?

      Your profiles are obviously saved, since you reach a redolog to save...

      If it works, you can adjust blocksizes for cpio as well -Cxxxxx to

      get better throughput.

      Volker

  • avatar image
    Former Member
    Nov 04, 2010 at 08:44 AM

    thanks

    Add comment
    10|10000 characters needed characters exceeded