BR0261E BRBACKUP cancelled by signal 15- Error in Archivelog backup to tape

[Former Member]

Dear All,

I am facing the backup issue for long time. i have tried with different solution. But still i couldnot clear.

Please help me to clear the issue.

System Details :

OS : HP-UX

DB : ORACLE 9.2.0.6.0

SAP : ECC6 , Kernel : 304 and DBTOOL : 52 (latest one).

I am taking the database and arch backup into tape.

Tape and init<SID>.sap details : tape_address = /dev/rmt/0mn, tape_address_rew = /dev/rmt/0m, tape_size = 400000M,

expir_period = 0, tape_use_count = 300

Database backup is fine and archive log backup also taking but end of the process its throughing the error.

BR0261E BRBACKUP cancelled by signal 15.

Arch Log error :

BR0278E Command output of 'LANG=C cd /oracle/VRD/sapreorg && /usr/sap/VRD/SYS/exe/run/brtools -f detach LANG=C cpio -iuvB .tape.hdr0 < /dev/rmt/0mn':

640 blocks

BR0280I BRARCHIVE time stamp: 2010-05-12 10.16.16

BR0279E Return code from 'LANG=C cd /oracle/VRD/sapreorg && /usr/sap/VRD/SYS/exe/run/brtools -f detach LANG=C cpio -iuvB .tape.hdr0 < /dev/rmt/0mn': 0

BR0359E Restore of /oracle/VRD/sapreorg/.tape.hdr0 from /dev/rmt/0mn failed due to previous errors

BR0218E Checking label on volume in device /dev/rmt/0mn failed

BR0280I BRARCHIVE time stamp: 2010-05-12 10.16.16

BR0226I Rewinding tape volume in device /dev/rmt/0m ...

BR0007I End of offline redo log processing: aedfcnau.svd 2010-05-12 10.16.35

BR0280I BRARCHIVE time stamp: 2010-05-12 10.16.35

BR0005I BRARCHIVE terminated with errors

Please advise on this.

With Regards,

Senthil Kumar.C

[Former Member · Accepted solution]

Hi,

BR0218E Checking label on volume in device /dev/rmt/0mn failed

I think tape media was not initialized before taking backup.

Can you try first initializing the tape and then perform the backup again...

If got failed post the fresh log...

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Hi Rajesh,

Thanks for your reply. In case if its not initialized than database backup wouldnot happend.

We initiated the tape yesterday and backup happend today morning. But above saidsame error comming for more than a week,

With Regards,

Senthil Kumar.C

[Former Member · Accepted solution]

Hi All,

I have changed the tape device and started the backup with tape initialization.. same error occuring on same place.

Please do the needful.

With Regards,

Senthil kumar.C

[volker_borowski2]

Hi,

to display the actual label on the tape execute

brbackup -i show

Since your log shows 650 blocks being retrieved upon the label check,

I have my doubts that the file on position 1 will be the header.

So something does a rewind in between (cron?)

Start small.

Do a backup without redologs first, so only brbackup is involved.

If this is working, try brarchive alone without brbackup.

If this works as well, your fine with hardware !

The problem will be in brbackup to brarchive comunication then,

so a current patchlevel of DBATOOLS might help.

What is the head of brarchive-log like? Anything to see, if may be

a rewind is issued at the begin (which would be faulty, if

started by brbackup with the append option).

Volker

[Former Member]

Hii All,

Sorry for the late reply. my problem has been solved. There was a proble in tape.

With Regards,

CSK

[Former Member]

Hi Kumar,

I have the same error as you did, when i tried to whole backup my system.

And you said that the real problem for this error is the tape.

Can you explain it in more detail?

[Former Member]

Are brbackup and brarchive at different runs and different tapes?

And all runs of brbackup succeed, all runs of brarchive fail?

You might want to try with new tapes for brarchive.

tape_use_count = 300 is a bit high imho.

regards

Edited by: Joe Bo. on May 12, 2010 4:26 PM

[Former Member]

Dear Joe,

Thanks for your reply.

can change the parameter tape_use_count = 300 to 100?. advise me whether some other parameter causing the error.

I am running the online backup with the option : Whole database online + redo log backup in same run.

DB13 log file : i can see that, brbackup completed (datafiles), after starting arch log backup here i'm getting the error.

BR0018I Waiting for the next offline redo log file...

BR0056I End of database backup: bedfduej.ant 2010-05-12 16.25.46

BR0280I BRBACKUP time stamp: 2010-05-12 16.25.46

BR0052I BRBACKUP completed successfully

BR0280I BRBACKUP time stamp: 2010-05-12 16.25.46

BR0291I BRARCHIVE (action ID aedfduej) will be started with options '+bedfduej.ant,154422812672,VRDB03,35:24535 -jid ALLOG20100512153100 -d tape -c force -p initVRD.sap -cds'

BR0280I BRBACKUP time stamp: 2010-05-12 16.28.26

BR0261E BRBACKUP cancelled by signal 15

BR0056I End of database backup: bedfduej.ant 2010-05-12 16.28.26

BR0280I BRBACKUP time stamp: 2010-05-12 16.28.26

BR0054I BRBACKUP terminated with errors

Detailed error from arch log backup : --- arch log files also getting backup but finally i'm getting error so whole backup

ending with Return code: " 0005 Error during processing"

Arch log backup log :

BR0016I 8 offline redo log files processed, total size 75.882 MB

BR0202I Saving space_log

BR0203I to /dev/rmt/0mn ...

BR0202I Saving det_log

BR0203I to /dev/rmt/0mn ...

BR0202I Saving sum_log

BR0203I to /dev/rmt/0mn ...

BR0280I BRARCHIVE time stamp: 2010-05-12 16.27.48

BR0226I Rewinding tape volume in device /dev/rmt/0m ...

BR0351I Restoring /oracle/VRD/sapreorg/.tape.hdr0

BR0355I from /dev/rmt/0mn ...

BR0278E Command output of 'LANG=C cd /oracle/VRD/sapreorg && /usr/sap/VRD/SYS/exe/run/brtools -f detach LANG=C cpio -iuvB .tape.hdr0 < /dev/rm

650 blocks

BR0280I BRARCHIVE time stamp: 2010-05-12 16.27.48

BR0279E Return code from 'LANG=C cd /oracle/VRD/sapreorg && /usr/sap/VRD/SYS/exe/run/brtools -f detach LANG=C cpio -iuvB .tape.hdr0 < /dev/rmt

BR0359E Restore of /oracle/VRD/sapreorg/.tape.hdr0 from /dev/rmt/0mn failed due to previous errors

BR0218E Checking label on volume in device /dev/rmt/0mn failed

BR0280I BRARCHIVE time stamp: 2010-05-12 16.27.48

BR0226I Rewinding tape volume in device /dev/rmt/0m ...

BR0007I End of offline redo log processing: aedfduej.cds 2010-05-12 16.28.26

BR0280I BRARCHIVE time stamp: 2010-05-12 16.28.26

BR0005I BRARCHIVE terminated with errors

[Former Member]

Hello,

parameter tape_use_count by itself doesn't matter. What does matter is: How often are tapes used? You know, the more often, the more possible damages. So I would try new ones now.

tape_use_count = 300 (or 100) only means: You will get a warning if tapes are used more than 300 (or 100) times.

And what happens if you insert one of the offending tapes, rewind it, and try:

cpio -iuvB .tape.hdr0 < /dev/rmt/0mn

Is there a file .tape.hdr in the current directory, and what is in it? (Should be a text file.)

regard

PS:

The counter how often a tape has been used is stored in file .tape.hdr.

But afaik the counter is reset to 0 whenever you initialize a tape.

So probably in your case tape_use_count doesn't mean anything at all.

But do you (or your colleagues) remember how often the tapes have actually been used?

Edited by: Joe Bo. on May 12, 2010 4:50 PM

[Former Member]

Dear Joe,

I dont know how many times tape used. But i have tried with 2 different tapes. both having same issue.

my customer using 30 labels for entire month. parameter :expir_period = 0 using.

is there any chance for permission issue?..

there is backup data and logfiles while rewinding the tape. in that time only its getting error.

With Regards,

Senthil Kumar.

[Former Member]

Hello,

a few more ideas before going home:

I don't think 2 different tapes will be a proof...

I suppose you did try a cleaning tape?

Permission issue? Hmm... maybe.

Check if there is a file .tape.hdr anywhere on your system. If so, delete it.

Make sure you run brbackup and brarchive as user ora<sid>. s-bit correct for programs brbackup and brarchive?

Write permissions in /oracle/VRD/sapreorg ?

For further testing you could try brbackup and brarchive in two separate runs.

regards

[Former Member]

Hi Joe,

ya I checked for the file permission.. I gave 775 too :).

i dont know where can i find .tape.hdr.. should I check in OS level or in tape?..

i will try with 2 diff backup also...

Please share in case if u have any other option..

With Regards,

Senthil Kumar.C

[Former Member]

Hi,

I agree with Joe..

What he is suggesting, is to actually check the BRtools permissions as per the below note.

[113747 - Permissions for DBA tools BRTools and SAPDBA.pdf|https://service.sap.com/sap/support/notes/113747]

Carefully check the permissions as mentioned in note. Specially "s-bit".

Also see the result after changing parmeter to "expir_period = 30" in init<SID>.sap. (I know, it is not really the cause..)

Regards.

Rajesh Narkhede