BR0278E error during backup

[Former Member]

Hi All,

Am executing an online bakup of my production server to an hard disk, the amount of free space is 250GB and the db size is around 142GB, when the first data file round 4GB is being copied, it throws an error stting BR0278E, here is the error log

R0077I Database file for backup: F:\oracle\P01\sapbackup\CNTRLP01.DBF

R0061I 41 files found for backup, total size 144640.047 MB

R0143I Backup type: online

R0112I Files will not be compressed

R0130I Backup device type: disk

R0106I Files will be saved on disk in directory: G:\DBbackup\beawvlfu

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

R0370I Directory G:\DBbackup\beawvlfu created

R0202I Saving init_ora

R0203I to G:\DBbackup\P01 ...

R0202I Saving F:\oracle\P01\102\database\initp01.sap

R0203I to G:\DBbackup\P01 ...

R0280I BRBACKUP time stamp: 2009-06-27 14.31.12

R0198I Profiles saved successfully

R0280I BRBACKUP time stamp: 2009-06-27 14.31.13

R0315I 'Alter tablespace PSAPP01 begin backup' successful

R0202I Saving F:\ORACLE\P01\SAPDATA3\P01_1\P01.DATA1

R0203I to G:\DBbackup\beawvlfu\P01.DATA1 ...

R0278E Command output of 'dd bs=64k if=F:\ORACLE\P01\SAPDATA3\P01_1\P01.DATA1 of=G:\DBbackup\beawvlfu\P01.DATA1':

d: write error: There is not enough space on the disk.

5536+0 records in

5535+0 records out

write error

R0280I BRBACKUP time stamp: 2009-06-27 14.35.57

R0279E Return code from 'dd bs=64k if=F:\ORACLE\P01\SAPDATA3\P01_1\P01.DATA1 of=G:\DBbackup\beawvlfu\P01.DATA1': 1

R0222E Copying F:\ORACLE\P01\SAPDATA3\P01_1\P01.DATA1 to/from G:\DBbackup\beawvlfu\P01.DATA1 failed due to previous errors

R0280I BRBACKUP time stamp: 2009-06-27 14.36.02

R0317I 'Alter tablespace PSAPP01 end backup' successful

Any ideas why this happens

Regards,

Balakrishnan

Edited by: Balakrishnan S on Jun 27, 2009 12:18 PM

[Former Member · Accepted solution]

Hello,

My first reaction would be to make absolutely sure you do indeed have enough free space on the target drive. A simple "dir G:\DBbackup" will tell you this when you look at the "bytes free" line at the end. If free space is not the problem, then you may try (it's a long shot but it's the first thing I would do in this situation) to play with the parameters of the "dd" command, and more specifically the block size. You can set this in the init<SID>.sap profile, the parameters are "dd_flags" and "dd_in_flags". Perhaps the blocksize of 64k causes some kind of problem. Try a smaller block size e.g. bs=32k or bs=16k.

If this does not help (and there is a good chance it won't), then let us know.

Regards,

Mark

[anindya_bose]

Hi Bala

First of all please tell us by 142 GB did you mean whole database ( datafile) size or used portion of datafile?

Making "compression=yes " in your initp01.sap file might resolve your issue here, but one thing you need to consider when you

make compression=yes backup time may be 3-6 times of the uncompressed backup.. Duting compress backup BRTOOLS will make every .data file to .data.Z. and this steps take huge time. But if you do not have enough diskspace then you have to go for compression =yes.

If you have suffiecient diskspace you should not go for compressed backup.

Can you please tell me what are the values of the paramaeters below in your initp01.sap file?

1.. backup_root_dir

2. stage_root_dir

These parameters in .SAP file should contain the following values. You can chose them from BTROOLS menu option as well

backup_dev_type = disk

backup_root_dir = target disk (your hard drive)

stage_root_dir = target disk.\

http://help.sap.com/saphelp_bw30b/helpdata/en/0d/d309594a0c11d182b80000e829fbfe/content.htm

http://help.sap.com/saphelp_bw30b/helpdata/en/5c/aa144b1d4a11d2a7620000e81bf4e4/content.htm

Hope this will help

Thanks and Regards

Anindya

[Former Member]

Hi All,

I even tried to do it in compressed mode and found out that it also failed when a file of around 4gb is being created, then I analyzed and found out that the disk in which i was taking a backup was in RAW format, so I changed it to NTFS file format and bingo backup executed perfectly.

Other than NTFS other file system doesnot support file size larger than 4GB

Thanks for all your support.

Regards,

Balakrishnan

[Former Member]

Hi Balakrishnan,

There is no problem. just u change settings in Brtools operation.Hereby furnished the procedure.

1.Login to <orasid> or <sidadm>.

2.Brools - > select the option 4.Backup and database copy

3.Then in the Sub menu select 1 - > Backup

4.Then the Change the Tape name & Backup mode.

5.Change the Backup mode Compression mode (compress) ....... [hardware] insted of "Yes"

do it the steps then start backup.

or

Change the profile init<SID>.SAP.

Parameter - > compress = yes

Hope it Helps.

Regards

Senthil Kumar.S

+91 9994833812

[Former Member]

Hi,

if there is enough space on G: drive and still it is not coping data, then i will suggest to check that drive. by

chkdsk /f command. Also u can check that not a big virtual memory is set in Systm properties on same drive.