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