BR0292I Execution of BRARCHIVE finished with return code 3

[Former Member]

Dear All,

I have scheduled whole offline backup+redologs through DB13, in this brbackup has been completed with 0 return code, but brarchive finished with return code 3. here i am copying log file

BR0056I End of database backup: bebdxgru.afd 2009-08-04 00.36.28

BR0280I BRBACKUP time stamp: 2009-08-04 00.36.29

BR0052I BRBACKUP completed successfully

BR0280I BRBACKUP time stamp: 2009-08-04 00.36.29

BR0291I BRARCHIVE will be started with options '-U -jid ALGOF20090803235900 -d disk -c force -p init

BQW.sap -cds'

BR0280I BRBACKUP time stamp: 2009-08-04 00.36.30

BR0292I Execution of BRARCHIVE finished with return code 3

Please help to solve this error i am using AIX 6 with oracle 10g

[Former Member]

This message was moderated.

[Former Member]

solved

[markus_doehr2]

Are the permissions on the BR*TOOLS correct? Did you execute "saproot.sh <SID>" in the kernel directory after updating the tools?

Markus

[Former Member]

Hi chandra

please check the following

1.Permission for the path where take the backup is happening

2.Size of the drive where you are taking the backup

please check the SAP note

Note 17163 - BRARCHIVE/BRBACKUP messages and codes

Request you to post the log

IS THIS ISSUE HAPPENING DAILY ?

cheers

George

[Former Member]

Hi Georg,

BRArchive working fine with brtools, when i am scheduling from DB13 i am getting follow error

BR0056I End of database backup: bebecenp.afd 2009-08-05 00.37.12

BR0280I BRBACKUP time stamp: 2009-08-05 00.37.13

BR0052I BRBACKUP completed successfully

BR0280I BRBACKUP time stamp: 2009-08-05 00.37.13

BR0291I BRARCHIVE will be started with options '-U -jid ALGOF20090804235900 -d disk -c force -p init

BWQ.sap -cds'

BR0280I BRBACKUP time stamp: 2009-08-05 00.37.14

BR0292I Execution of BRARCHIVE finished with return code 3

You can find here BRBackup was sucessfully completed.

and this is issue is coming reqularly..

[Former Member]

Even if you run brbackup and brarchive together from DB13, there should be a separate log file for brarchive.

That's what I was talking about in my previous post.

[Former Member]

Hi George,

Your are right but brarchive log not generating in DB13 it is giving following

Could not read detail log aebechvt.log

Message no. Q2304

Diagnosis

The system could not access or read the detail log.

System Response

Log not displayed.

Procedure

Check the operating system to determine whether the selected log exists and whether the R/3 System has permission to read this file.

[Former Member]

Hello Chandra,

not sure to whom you are talking. My name is not George.

And yes, I know, the log of brarchive is not visible in DB13.

As I wrote above, you may either try DB12, or go to your saparch directory at operating system level.

[Former Member]

Hi Joe,

I am taliking with you only, sorry for the wrong name mentioned, in saparch not having the brarchive log file, 2 days backs log is showing wich i have taken brarchive backup through brtools

Regards

Chandra

[Former Member]

In this case probably there won't be a log in DB12 either.

So please try to start brarchive (redo log backup) only from DB13. Then there should be a more verbose log file.

regards

[Former Member]

even after scheduling only Redolog backup also getting same message

BRARCHIVE Action Log for Database BWQ

From: 05.08.2009 14:07:17

LogFile: aebefbtd.log

Return Code: 0003 Error during initialization

Database Host: pspdbwq

No action log for this action found in the database

Check the detail log

[Former Member]

Not what I had expected. But anyway, another thing to check:

When you started brarchive from brtools, I suppose you did it as user ora<sid> ?

Compare permissions of programs brbackup and brarchive; if they differ, make them the same.

And another check: Did you check button 'Job logs' in DB13? I suppose what you posted is from 'Action logs'.

[Former Member]

You are correct, i have checked both are same

[Former Member]

And did you check button 'Job logs' in DB13?

[Former Member]

Yes i have selected check box for the BRARCHIVE verify option

[Former Member]

Chandra,

not sure if we are talking about the same things here.

Not sure what BRARCHIVE verify option actually is.

And what Markus is asking, is in essence the same as my question about permissions of brbackup and brarchive. For more clearness, please show output of ls -l command for brbackup and brarchive.

[Former Member]

As per Markus question: i didnt updated the BRTools.

Job log content is:

05.08.2009 15:04:42 Job started

05.08.2009 15:04:42 Step 001 started (program RSDBAJOB, variant &0000000000205, user ID CHANDRAB)

05.08.2009 15:04:42 Execute logical command BRARCHIVE On host pspdbwq

05.08.2009 15:04:42 Parameters:-u / -jid LOG__20090805150442 -c force -p initBWQ.sap -cds

05.08.2009 15:04:43 BR0002I BRARCHIVE 7.00 (24)

05.08.2009 15:04:43 BR0181E Option '-cds' not supported for 'disk'

05.08.2009 15:04:43 BR0007I End of offline redo log processing: aebefgvq.log 2009-08-05 15.04.42

05.08.2009 15:04:43 BR0280I BRARCHIVE time stamp: 2009-08-05 15.04.43

05.08.2009 15:04:43 BR0005I BRARCHIVE terminated with errors

05.08.2009 15:04:43 External program terminated with exit code 3

05.08.2009 15:04:43 BRARCHIVE returned error status E

05.08.2009 15:04:43 Job finished

Even i have check with Option -SD error as follows:

05.08.2009 15:03:57 Job started

05.08.2009 15:03:57 Step 001 started (program RSDBAJOB, variant &0000000000204, user ID CHANDRAB)

05.08.2009 15:03:57 Execute logical command BRARCHIVE On host pspdbwq

05.08.2009 15:03:57 Parameters:-u / -jid LOG__20090805150357 -c force -p initBWQ.sap -sd

05.08.2009 15:03:57 BR0002I BRARCHIVE 7.00 (24)

05.08.2009 15:03:57 BR0252E Function fopen() failed for '/oracle/BWQ/saparch/aebefgtx.svd' at location main-6

05.08.2009 15:03:57 BR0253E errno 13: Permission denied

05.08.2009 15:03:57 BR0121E Processing of log file /oracle/BWQ/saparch/aebefgtx.svd failed

05.08.2009 15:03:57 BR0007I End of offline redo log processing: aebefgtx.svd 2009-08-05 15.03.57

05.08.2009 15:03:57 BR0280I BRARCHIVE time stamp: 2009-08-05 15.03.57

05.08.2009 15:03:57 BR0005I BRARCHIVE terminated with errors

05.08.2009 15:03:57 External program terminated with exit code 3

05.08.2009 15:03:57 BRARCHIVE returned error status E

05.08.2009 15:03:57 Job finished

[markus_doehr2]

Please execute

ls -l br*

in the kernel directory and post the output.

Markus

[Former Member]

I have checked in the kernel directory it showing "no match"

[markus_doehr2]

> I have checked in the kernel directory it showing "no match"

So where are your br*tools installed? Do it in that directory...

Markus

[Former Member]

Ah,

it seems that's what we have been looking for:

BR0181E Option '-cds' not supported for 'disk'

And that should be self-explaining.

Don't choose brarchive option -cds, but somethind different, like -sd

regards

[Former Member]

so what i have to check, i am trying to checking aebefgtx.svd file in the saparch and sapbackup but i didnt find the same

[Former Member]

Sorry, ignore my previous post.

I didn't read all of yours.

Edited by: Joe Bo. on Aug 5, 2009 12:47 PM

[Former Member]

try this.

ls -l `which brarchive`

[Former Member]

-rwxrwxr-x 1 orabwd dba 4845110 Apr 25 2007 brarchive

-rwsrwxr-x 1 orabwd dba 4965775 Apr 25 2007 brbackup

-rwsrwxr-x 1 orabwd dba 6439637 Apr 25 2007 brconnect

-rwxrwxr-x 1 orabwd dba 5451685 Apr 25 2007 brrecover

-rwxrwxr-x 1 orabwd dba 2016295 Apr 21 2007 brrestore

-rwxrwxr-x 1 orabwd dba 6640109 Apr 25 2007 brspace

-rwsrwxr-x 1 orabwd dba 2654772 Apr 23 2007 brtools

[Former Member]

Well, permissions are not the same.

rws, and rwx, you see?

The clean solution is saproot.sh, as suggested by Markus.

A quick and dirty solution also could be:

chmod 4775 brarchive

hope this helps

Edited by: Joe Bo. on Aug 5, 2009 1:02 PM

[Former Member]

i am trying from the sidadm to change permesions as u mentioned it saying that "chmod: brarchive: Operation not permitted"

[Former Member]

Of course not.

root or ora<sid>

[Former Member]

It is alowing from the orasid, so which funciton option i need to select whether SS or SD

[Former Member]

It depends on what you need.

brarchive options are explained somewhere in the manual, search for it!

-ss doesn't make sense for disk backups, like -cds

-s will copy to new directory

-sd will copy to new directory and delete from oraarch

Or go to Unix prompt and type:

brarchive -h

Edited by: Joe Bo. on Aug 5, 2009 1:18 PM

[Former Member]

Hi Joe,

It has been solved by giving 4775 permissions to brarchive, Thank you verymuch to providing good solution, and also thanks to Markus.

rgs

chandra

[Former Member]

Hi Chandra,

Please post the BRARCHIVE logs.

Regards,

Varadhu

[Former Member]

You should be able to find more information in the log file of brarchive, in saparch directory.

You should also be able to view it in transaction DB12.

hope this helps