BRBACKUP ended with errors!

[Former Member]

Dear Experts,

I am facing a problem while take backup of development server in tape for last few days.System is AIX 5.3 and Oracle 10.2. DB13 backup throws error :

BR0278E Command output of 'LANG=C dd ibs=64k bs=64k if=/dev/rmt0.1 of=/oracle/T01/sapreorg/sr3.data2':

dd read error: I/O error

22357+0 records in

22357+0 records out

BR0280I BRBACKUP time stamp: 2009-05-12 15.46.46

BR0279E Return code from 'LANG=C dd ibs=64k bs=64k if=/dev/rmt0.1 of=/oracle/T01/sapreorg/sr3.data2': 2

BR0359E Restore of /oracle/T01/sapreorg/sr3.data2from /dev/rmt0.1 failed due to previous errors

BR0056I End of database backup: beaodoor.fnt 2009-05-12 15.47.13

BR0054I BRBACKUP terminated with errors

External program terminated with exit code 5

BRBACKUP returned error status E

this error comes from each tape I had [3 tapes].

now whenever I am taking backup using brtools with fource this error is is like :

BR0204I Percentage done: 41.95%, estimated end time: 2:56

BR0001I *********************_____________________________

BR0280I BRBACKUP time stamp: 2009-05-15 00.26.09

BR0317I 'Alter tablespace PSAPSR3 end backup' successful

BR0280I BRBACKUP time stamp: 2009-05-15 00.26.09

BR0315I 'Alter tablespace PSAPSR3700 begin backup' successful

BR0202I Saving /oracle/T01/sapdata1/sr3700_1/sr3700.data1

BR0203I to /dev/rmt0.1 ...

BR0278E Command output of 'LANG=C cd /oracle/T01/sapdata1/sr3700_1 && echo sr3700.data1 | LANG=C cpio -ovB > /dev/rmt0.1':

< sr3700.data1 > ?

BR0240E Size 5120 of saved/restored data is different from the size 3040878592 of file/save set /oracle/T01/sapdata1/sr3700_1/sr3700.data1

10 blocks

BR0280I BRBACKUP time stamp: 2009-05-15 00.26.12

BR0279E Return code from 'LANG=C cd /oracle/T01/sapdata1/sr3700_1 && echo sr3700.data1 | LANG=C cpio -ovB > /dev/rmt0.1': 2

BR0222E Copying /oracle/T01/sapdata1/sr3700_1/sr3700.data1 to/from /dev/rmt0.1 failed due to previous errors

BR0280I BRBACKUP time stamp: 2009-05-15 00.26.14

BR0317I 'Alter tablespace PSAPSR3700 end backup' successful

BR0056I End of database backup: beaooxjp.ant 2009-05-15 00.26.12

BR0280I BRBACKUP time stamp: 2009-05-15 00.26.14

BR0054I BRBACKUP terminated with errors

One thing I want to add when I am giving tcopy /dev/rmt0 it shows some line in the mid like : "read : there is an input or output errror."

And when I am giving tctl -f /dev/rmt0 read : it gives: Can't read from 512 bytes.

But block size of tape is 0. Though I have changed it once from 0 to 512 and then again I replaced it from 512 to 0.

Please help me out. As it is a live server and backup is not being done.

Thank you in advance.

Regards,

Sandy

[Former Member]

Schedule "Initialize Tape" before taking backup and ensure initialisation is success.

• Let me know result.

Rgds

DK

[Former Member]

Hi,

Please check the below link in the HP forum.

http://forums13.itrc.hp.com/service/forums/questionanswer.do?admit=109447627124804182993828353475&threadId=1019693

It clearly states the following:

HP's cpio is still limited to a maximum file size of 2Gb (see the man page warnings). This is due to industry standards. HP did provide supply a patch for tar which increases the maximum file size to 8Gb but a tape with files larger than 2Gb on it cannot be read by unpatched tar or on other platforms -- in other words, not portable.

It means that CPIO in HPUX cannot handle files greater than 2 GB. The solution is to zip the file and then use GNU tar to backup to tape.

You can contact youur hardware vendor to know further details.

Don't forget to make necessary changes in the script to call the GNU Tar instead of CPIO.

regards,

Subhajit.

[Former Member]

Hi Sandy ,

Check the Tape drives are working Properly.

and make sure that the tape has been moved into the drive

Drive 1 -> rmt0

Drive 2 -> rmt1

check these two tape drives are accessible from your AIX server bhy using below command .

lsdev -Cc tape

rmt0 --> Available

rmt1 --> Available.

Since the tape has already been put into drive 1(rmt0) we would check its operation with the command shown below

tctl -f /dev/rmt0 rewind

if u get /dev/rmt0: There is an input or output error.

Restart your Tape Library and secondly execute the command -- > cfgmgr

This would reconfigure the tape drives on your AIX servers.

And then when you would test with the same command

tctl -f /dev/rmt0 rewind

It should work .

Regards

[Former Member]

Hi All,

Me too getting the error during online backup.

could any one tell me how to solvet the problem.

Our is on ECC6 on HP-UX with oracle 10.2

error:

BR0278E Command output of 'LANG=C cd /oracle/MDS/sapdata1/sr3700_1 && echo sr3700.data1 /usr/sap/MDS/SYS/exe/run/brtools -f detach LANG=C cpio -ovB > /dev/rmt/1mn':

(Using tape drive with immediate report mode enabled (reel #1).)

"sr3700.data1": Value too large to be stored in data type

cpio: Size of sr3700.data1 > 2GB. Not dumped.

BR0240E Size 5120 of saved/restored data is different from the size 3271565312 of file/save set /oracle/MDS/sapdata1/sr3700_1/sr3700.data1

10 blocks

BR0280I BRBACKUP time stamp: 2009-07-17 15.29.11

BR0279E Return code from 'LANG=C cd /oracle/MDS/sapdata1/sr3700_1 && echo sr3700.data1 /usr/sap/MDS/SYS/exe/run/brtools -f detach LANG=C cpio -ovB > /dev/rmt/1mn': 0

BR0222E Copying /oracle/MDS/sapdata1/sr3700_1/sr3700.data1 to/from /dev/rmt/1mn failed due to previous errors

BR0280I BRBACKUP time stamp: 2009-07-17 15.29.13

BR0317I 'Alter tablespace PSAPSR3700 end backup' successful

BR0056I End of database backup: bebapwfz.ant 2009-07-17 15.29.11

BR0280I BRBACKUP time stamp: 2009-07-17 15.29.13

BR0054I BRBACKUP terminated with errors

Thanks & Regards!!

[former_member235680]

Hi,

Did you guys try the note 17163 abt the brief descriptions on brbackup error codes? Also would like you to check RW permissions of fileysystems is consideration along with the configuration files in directory /oracle/<SID>/102_64/dbs.

Thanks

Abhishek

[former_member227600]

Hi,

If you are trying to take online backup than you have to read the following note.

Note 948294 - AIX JFS2 mount options to use with Oracle 10g

For online backup you have to mount datafile with cio option.

Karan

[Former Member]

Dear Sir,

I found from smit.log that for development server datafiles are not mounted with cio option. But for Production server it is done. Now as it is a running system should I change mount options for backup. Will it affect the system now. Please give me an idea how to change the the mount options in detail.

Thank you

regards,

sandy

[former_member227600]

Hi,

First of all you have to stop the SAp & DB .Than you have to unmount the file sytem which have data files.

For EX:-

umount /oracle/<SID>/sapdata1

.....................................

umount /oracle/<SID>/sapdataN

Than you have to mount with option cio.

mount -o cio /oracle/<SID>/sapdata1

................................................

mount -o cio /oracle/<SID>/sapdataN

Regards

Karan

[Former Member]

Dear Sir,

I have found from smitty the LV mounted with cio options are mounted on the followings :

/oracle/TKD/sapdata1 jfs2 May 13 13:42 rw,cio,log=/4

/oracle/TKD/sapdata2 jfs2 May 13 13:42 rw,cio,log=/d

/oracle/TKD/sapdata3 jfs2 May 13 13:42 rw,cio,log=/d

/oracle/TKD/sapdata4 jfs2 May 13 13:42 rw,cio,log=/

/oracle/TKD/mirrlogA jfs2 May 13 13:42 rw,cio,log=/

/oracle/TKD/mirrlogB jfs2 May 13 13:42 rw,cio,log=

/oracle/TKD/origlogA jfs2 May 13 13:42 rw,cio,lo

/oracle/TKD/origlogB jfs2 May 13 13:42 rw,cio,log=/

Now what could be the reason for the failure of backup...

Please suggest me.......

Thanks & regards,

Sandy

[former_member227600]

Hi,

According to your backup logs SID is T01

of=/oracle/T01/sapreorg/sr3.data2': dd read error: I/O error 22357+0 records in 22357+0 records out BR0280I BRBACKUP time stamp

And in this reply your SID is TKD

/oracle/TKD/sapdata1 jfs2 May 13 13:42 rw,cio,log=/4
/oracle/TKD/sapdata2 jfs2 May 13 13:42 rw,cio,log=/d
/oracle/TKD/sapdata3 jfs2 May 13 13:42 rw,cio,log=/d
/oracle/TKD/sapdata4 jfs2 May 13 13:42 rw,cio,log=/
/oracle/TKD/mirrlogA jfs2 May 13 13:42 rw,cio,log=/
/oracle/TKD/mirrlogB jfs2 May 13 13:42 rw,cio,log=
/oracle/TKD/origlogA jfs2 May 13 13:42 rw,cio,lo
/oracle/TKD/origlogB jfs2 May 13 13:42 rw,cio,log=/

Can you tell me in detail.what is this.

[Former Member]

Dear Sir,

The system is same & I have changed the SID while posting in the forum. Hope you can understand.

Now could u please make me understand why the error is comming while taking backup only for development server.

regards,

Sandy

[Former Member]

Could anyone help me out please?

[anindya_bose]

Sandy

Did you check whether BRTOOLS patch level in your DEV and PRD system are same?

Also check if you have any .lock file in oracle/SID/sapbackup filder.

what is the value of parameter "tape_copy_cmd" in initSID.sap file? is it dd? you can change it to "cpio"

OSS note https://service.sap.com/sap/support/notes/540543 might help you in diagonizing the error.

Best of Luck..

Edited by: Anindya Bose on Jul 19, 2009 1:43 PM