on 04-22-2010 1:30 PM
Good Evening Everyone,
I'm new to the BASIS Field and I would humbly like to ask for your opinions about this matter. We're working on an IBM p6-520 Server running AIX 5.3. The system only has 1 4mm tape drive.
I have executed Brtools to perform a full database backup. after a few hours, the backup failed at around 46%.
Could someone enlighten me on what actually happened based on the logs?
If you need additional information, I'd be happy to help.
Here is the log...
BR0280I BRBACKUP time stamp: 2010-04-22 06.56.29
BR0063I 25 of 46 files processed - 56000.195 MB of 119476.307 MB done
BR0204I Percentage done: 46.87%, estimated end time: 8:55
BR0001I ***********************___________________________
BR0201I Compressing /oracle/BBT/sapdata2/sr3700_6/sr3700.data6
BR0203I to /oracle/BBT/sapreorg/sr3700.data6.Z ...
BR0202I Saving /oracle/BBT/sapreorg/sr3700.data6.Z
BR0203I to /dev/rmt0.1 ...
BR0278E Command output of 'LANG=C cd /oracle/BBT/sapreorg && echo sr3700.data6.Z | LANG=C cpio -ovB > /dev/rmt0.1':
< sr3700.data6.Z > ?
BR0240E Size 5120 of saved/restored data is different from the size 2264214421 of file/save set /oracle/BBT/sapreorg/sr3
700.data6.Z
10 blocks
BR0280I BRBACKUP time stamp: 2010-04-22 07.01.47
BR0279E Return code from 'LANG=C cd /oracle/BBT/sapreorg && echo sr3700.data6.Z | LANG=C cpio -ovB > /dev/rmt0.1': 2
BR0222E Copying /oracle/BBT/sapreorg/sr3700.data6.Z to/from /dev/rmt0.1 failed due to previous errors
BR0115I Compression rate for all files 5.0426:1
BR0280I BRBACKUP time stamp: 2010-04-22 07.01.49
BR0304I Starting and opening database instance BBT ...
BR0280I BRBACKUP time stamp: 2010-04-22 07.02.06
BR0305I Start and open of database instance BBT successful
BR0056I End of database backup: bedbhazl.aft 2010-04-22 07.01.47
BR0280I BRBACKUP time stamp: 2010-04-22 07.02.07
BR0054I BRBACKUP terminated with errors
###############################################################################
BR0292I Execution of BRBACKUP finished with return code 5
My first guess would be a problem with your tape and/or tape drive.
Try again, maybe with a different tape, maybe use a cleaning tape first.
If problems continue, you may have to contact hardware support.
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Good Morning Everyone,
Last time I came across with the following error when I changed initBBT.sap's tape_copy_cmd parameter to 'dd'.
BR0278E Command output of 'LANG=C dd obs=64k bs=64k if=/oracle/BBT/sapreorg/sr3.data1.Z of =/dev/rmt0.1' :
dd: write error: Invalid argument
I was able to remedy this error by just setting the block size of the tape drive's settings from '1024' to '0' thru AIX's smitty administration tool.
The offline backup is now successful.
Thanks again for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here's an update on what happened back at work,
I was able to overwrite the tape cartridge which i have been getting errors from using AIX's volume group backup savevg, meaning we could rule out tape device problems. I was able to fill up the tape (It was asking for the next tape).
So I went on to do #2 and modify the 'tape_copy_cmd' parameter from 'cpio' to 'dd'.
BR0202I Saving /oracle/BBT/sapreorg/sr3.data1.Z
BR0203I to /dev/rmt0.1...
BR0278E Command output of 'LANG=C dd obs=64k bs=64k if=/oracle/BBT/sapreorg/sr3.data1.Z of =/dev/rmt0.1' :
dd: write error: Invalid argument
3899+1 records in
3899+1 records out
BR0280I BRBACKUP time stamp: 2010-04-24 07.19.09
BR0279E Return code from 'LANG=C dd obs=64k bs=64k if=/oracle/BBT/sapreorg/sr3.data1.Z of=/dev/rmt0.1' : 2
BR0222E Copying /oracle/BBT/sapreorg/sr3.data1.Z to/from /dev/rmt0.1 failed due to previous errors
I think there is some sort of syntax error going on here. I double checked my init<SID>.sap tape_copy_cmd parameter and it seems to be supplied properly.
I have some other notes to follow tomorrow and hopefully one them works. I just posted this hoping to get more input.
I'll update more tomorrow.
Many Thanks everyone
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for all the suggestions.
Apparently, backing up to tape is taking a long time.
Based on what you guys suggested, it might be a tape drive problem so ill be using this course of action...
1. I'll be issuing AIX's savevg command to backup the volume group on the same exact tape i have had errors on. If it goes well, we can rule out tape drive issues and move on to...
2. Changing tape_copy_cmd parameter from 'cpio' to 'dd' and try running brtools once again.
I'll let you guys know as soon as i get results.
Again, thanks for all the suggestions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Michael,
Have you tried to backup in local drive? If not try it as well if succeeded maybe the problem is on your tape drive.
Thank you.
Joel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check initSID.sap file & change the value of parameter "tape_copy_cmd = cpio" to "dd". cpio failes backup for files larger than 2 GB
Thanks
Karan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Michael,
Exact error code is not present in logs you past here, check privious error & error code. If the no error was there in log file it means the problem is because of Tape or Tape Drive only.
BR,
Darshan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.