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

[Former Member]

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.

[Former Member]

thanks

[Former Member]

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

[volker_borowski2]

...

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

[Former Member]

Hi,

Changed the values to 512k but same issue.

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

[Former Member]

Hi james,

Change values to 1024K, I also faced the same problem & same thing I had done 64k, 128k, 512k & 1024k solved my problem.

Also if you got the error above this with invalid argument( AIX) then you need to set option cio in /etc/filesystems

BR,

Darshan..

[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

[volker_borowski2]

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

[former_member204746]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[volker_borowski2]

>

> 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"
> 
> BR0278E Command output of 'dd bs=128k conv=sync if=M:\oracle\DEV\oraarch\DEVARCHARC07424_0629125750.001 of=/dev/nmt0':
> 
> Pls suggest

Try again, after saving initSID.sap

Command is still using bs=128k not 64k

Try

mt -f /dev/nmt0 status

two times from the command line and please post result.

Check if

mt -f /dev/nmt0 rewind

and

mt -f /dev/nmt0 offline

are working correctly

Volker

[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

[Former Member]

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

[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

[Former Member]

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

[former_member227600]

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

I have paste some content from SAP Note 540543. Please go through the SAP note for more detail. And perform all checks mention in SAP note.

2. Possible additional messages:

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

dd: non-recoverable media error - check media

dd: recoverable error (<zahl1> <zahl2> ...)

dd: Data error (cyclic redundancy check)

dd: I/O error

dd: The I/O bus was reset.

dd: The semaphore timeout period has expired.

Check if the hardware used (tape, drive, controller and so on) works correctly. You can perform the following tests:

• Does the error also occur with another tape?

• Does the error also occur with another drive?

• Does the error also occur with another backup tool (for example, ntbackup on NT)?

• Does the error also occur when calling dd directly (instead of via the BR tools)?

You may also contact your hardware partner if you are not sure.

Please let us know if all above test is successful & after that you are unable to take backup

[kishore_soma]

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