Backup Terminated

[Former Member]

Dear all

when i am taken a backup through brtools

terminated with following error

BR0202I Saving D:\ORACLE\MVP\SAPDATA2\SR3_7\SR3.DATA7

BR0203I to /dev/nmt0 ...

#FILE..... D:\ORACLE\MVP\SAPDATA2\SR3_7\SR3.DATA7

#SAVED.... SR3.DATA7 MVPB01/11

BR0280I BRBACKUP time stamp: 2009-10-05 22.51.27

BR0063I 8 of 58 files processed - 16740.063 MB of 132797.117 MB done

BR0204I Percentage done: 12.61%, estimated end time: 23:29

BR0001I ******____________________________________________

BR0202I Saving D:\ORACLE\MVP\SAPDATA2\SR3_8\SR3.DATA8

BR0203I to /dev/nmt0 ...

BR0278E Command output of 'dd bs=64k conv=sync if=D:\ORACLE\MVP\SAPDATA2\SR3_8\SR3.DATA8 of=/dev/nmt0':

dd: unable to initialize ASPI manager

dd: using NT tape support

dd: Data error (cyclic redundancy check).

dd: write error: Data error (cyclic redundancy check).

6128+0 records in

6127+0 records out

1 write error

BR0280I BRBACKUP time stamp: 2009-10-05 23.01.50

BR0279E Return code from 'dd bs=64k conv=sync if=D:\ORACLE\MVP\SAPDATA2\SR3_8\SR3.DATA8 of=/dev/nmt0': 1

BR0222E Copying D:\ORACLE\MVP\SAPDATA2\SR3_8\SR3.DATA8 to/from /dev/nmt0 failed due to previous errors

BR0280I BRBACKUP time stamp: 2009-10-05 23.01.55

BR0317I 'Alter tablespace PSAPSR3 end backup' successful

BR0056I End of database backup: bebpusfr.ant 2009-10-05 23.01.50

BR0280I BRBACKUP time stamp: 2009-10-05 23.01.55

BR0054I BRBACKUP terminated with errors

Can anyone please help me to solve this issue

Thanks in Adbance

Jose H.

[Former Member]

Answered

[Former Member]

This is my Init<sid>.sap file

backup_mode = all

restore_mode = all

backup_type = online

backup_dev_type = tape

compress = no

compress_cmd = "compress -c $ > $"

compress_dir = d:/oracle/MVP/sapreorg

archive_function = save

archive_copy_dir = d:/oracle/MVP/sapbackup

archive_stage_dir = d:/oracle/MVP/sapbackup

tape_copy_cmd = dd

cpio_in_flags = -iuvB

cpio_disk_flags = -pdcu

dd_flags = "bs=64k"

dd_in_flags = "bs=64k"

saveset_members = 1

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

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

rewind = "mt -f $ rewind"

rewind_offline = "mt -f $ offline"

tape_pos_cmd = "mt -f $ fsf $"

tape_size = 200G

exec_parallel = 0

tape_address = /dev/nmt0

tape_address_rew = /dev/mt0

volume_archive = (MVPA01, MVPA02, MVPA03, MVPA04, MVPA05

volume_backup = (MVPB01, MVPB02, MVPB03, MVPB04, MVPB05

expir_period = 6

tape_use_count = 100

[Former Member]

Could be a problem with your tape or tape drive.

Try with a different tape, or perhaps use a cleaning tape.

[Former Member]

Hi Joe,

There is no problem in Tape Drive and Tape. Because i can take the redo log backup using Brtools.

and i can take the NT back also. I have changed the new taps and Drive. pls assist me

Thanks in Advance

Jose H

[Former Member]

For clarification:

Do you get this error every time you run brbackup?

With every tape ?

And every time with file SR3.DATA8 ?

[Former Member]

Yes . i take always brbackup. 2 days back Tape drive had some problem and then i have replaced the Tape drive and i am usine new set of taps. Now i got the error in SR3.DATA8. I tested in 3 times, both times i got the error in SR3.DaTA8. pls assist me

Thanks

Jose H.

[Former Member]

I think the next thing to check should be whether there is a problem with file SR3.DATA8.

What size is it? Did it grow recently? Is autoextend on ?

What is the size of the other files that are copied to tape successfully?

And then you could try to copy it manually to a tape, with the command brbackup is using:

dd bs=64k conv=sync if=D:\ORACLE\MVP\SAPDATA2\SR3_8\SR3.DATA8 of=/dev/nmt0

regards

[Former Member]

That size arount 20 GB and is auto extended.backup terminated in 12 %.

and how to copy nanually in the following in tape

dd bs=64k conv=sync if=D:\ORACLE\MVP\SAPDATA2\SR3_8\SR3.DATA8 of=/dev/nmt0

Pls assist me how to manually change Tape Volume label.

Thanks

H.Jose

[former_member72237]

Hi Jose,

As you mention that you have replace the TAPE DRIVE, I suggest to update the drivers of your tape drive. Also please check the latest version of the firmware of the drive.

Hope this will solve your problem.

regards

Virendra

[Former Member]

backup terminated in 12 %

Yes, 12% of the whole database where saved. This doen't say anything about how much of SR3.DATA8 was saved.

You didn't answer my question whether size of SR3.DATA8 changed recently, and what the size of other successfully save files is.

BR0063I 8 of 58 files processed

Are these 8 files about the same size, or significantly smaller?

how to copy nanually

Insert a spare tape (one that currently is not used for brbackup ot brarchive) in the tape drive, as user <sid>adm open a DOS window and type the command.

how to manually change Tape Volume label

Not sure why no need to do so, but its all in the manual. Try help.sap.com, or type command 'brbackup -h'

And yes, Virendra has a good point.

I too suspect that it still might be a problem with your tape drive. But I first wanted to make sure that it is not a problem of that file.

reagrds

[former_member524429]

Dear Jose,

Please refer [SAP NOTE 540543|https://service.sap.com/sap/support/notes/540543].

Does the error also occur with another Tape/ another Tape Drive / with another Backup Tool (e.g. NTBACKUP, etc) ?

Does the error also occur when calling dd directly instead of via BR Tools ?

Regards,

Bhavik G. Shroff