cancel
Showing results for 
Search instead for 
Did you mean: 

Error during the redo log backup

Former Member
0 Kudos

Hi Experts,

We are getting error during the redolog backup.I m paste the logs here for your ready refrence.

this is on ECC5.0 on AIX bascop08 3 5 00396F7C4C00 with database oracle 9.2.0.7.0

We would appreciate for your quick response towards corrective action.

BR0002I BRARCHIVE 6.40 (50)

BR0006I Start of offline redo log processing: aeardegy.svd 2009-05-28 07.08.28

BR0484I BRARCHIVE log file: /oracle/QBS/saparch/aeardegy.svd

BR0252W Function remove() failed for '/oracle/QBS/920_64/dbs/sap.ora' at location BrInitOraCreate-1

BR0253W errno 13: Permission denied

BR0252W Function fopen() failed for '/oracle/QBS/920_64/dbs/initQBS.ora' at location BrInitOraCopy-2

BR0253W errno 13: Permission denied

BR0101I Parameters

Name Value

oracle_sid QBS

oracle_home /oracle/QBS/920_64

oracle_profile /oracle/QBS/920_64/dbs/initQBS.ora

sapdata_home /oracle/QBS

sap_profile /oracle/QBS/920_64/dbs/initQBS.sap

backup_dev_type util_file

util_par_file /oracle/QBS/920_64/dbs/initQBS.utl

archive_dupl_del only

system_info oraqbs/oracbs bascop08 AIX 3 5 00396F7C4C00

oracle_info QBS 9.2.0.7.0 8192 423 5563906655

sap_info 640 SAPR3 QBS W1421187153 R3_ORA 0020121351

make_info rs6000_64 OCI_920 Oct 11 2008

command_line brarchive -u system/******** -c -d util_file -sd

BR0252E Function fopen() failed for '/oracle/QBS/saparch/archQBS.log' at location arch_last_get-1

BR0253E errno 13: Permission denied

BR0016I 0 offline redo log files processed, total size 0.000 MB

BR0252W Function fopen() failed for '/oracle/QBS/saparch/archQBS.log' at location BrCleanup-8

BR0253W errno 13: Permission denied

BR0121W Processing of log file /oracle/QBS/saparch/archQBS.log failed

BR0007I End of offline redo log processing: aeardegy.svd 2009-05-28 07.08.29

BR0280I BRARCHIVE time stamp: 2009-05-28 07.08.29

BR0005I BRARCHIVE terminated with errors

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi,

I am taking offline backup iam getting error :

Returncode : 0005 error during processing .OS is AIX and DB is oracle.can any one guide me for to solve this error.

BR0280I BRBACKUP time stamp: 2010-11-06 02.15.42

BR0063I 32 of 33 files processed - 79001.775 MB of 79006.924 MB done

BR0204I Percentage done: 99.99%, estimated end time: 2:15

BR0001I **************************************************

BR0202I Saving /oracle/PRD/origlogA/cntrl/cntrlPRD.dbf

BR0203I to /dev/rmt0.1 ...

#FILE..... /oracle/PRD/origlogA/cntrl/cntrlPRD.dbf

#SAVED.... cntrlPRD.dbf PRDB05/36

BR0280I BRBACKUP time stamp: 2010-11-06 02.15.45

BR0063I 33 of 33 files processed - 79006.924 MB of 79006.924 MB done

BR0204I Percentage done: 100.00%, estimated end time: 2:15

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2010-11-06 02.15.47

BR0304I Starting and opening database instance PRD ...

BR0280I BRBACKUP time stamp: 2010-11-06 02.16.34

BR0305I Start and open of database instance PRD successful

BR0117I ARCHIVE LOG LIST after backup for database instance PRD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/PRD/oraarch/PRDarch

Archive format %t_%s.dbf

Oldest online log sequence 9812

Next log sequence to archive 9815

Current log sequence 9815 SCN: 156140548

Database block size 8192 Thread: 1

BR0056I End of database backup: beemrney.afp 2010-11-06 02.16.34

BR0280I BRBACKUP time stamp: 2010-11-06 02.16.36

BR0052I BRBACKUP completed successfully

BR0280I BRBACKUP time stamp: 2010-11-06 02.16.36

BR0291I BRARCHIVE (action ID aeemrney) will be started with options '+beemrney.afp,19628058347,PRDB05,33:286938 -d pipe -c force -p initPR

BR0280I BRBACKUP time stamp: 2010-11-06 02.35.03

BR0292I Execution of BRARCHIVE (action ID aeemrney) finished with return code 5

thank you

former_member524429
Active Contributor
0 Kudos

Hi,

Create another new thread for your issue to get quick and precise replies.

Anyway analyse brarchive log backup file located at /oracle/<SID>/saparch location to get more detailed information about errors in ur case.

Regards,

Bhavik G. Shroff

markus_doehr2
Active Contributor
0 Kudos

> BR0002I BRARCHIVE 6.40 (50)

> BR0006I Start of offline redo log processing: aeardegy.svd 2009-05-28 07.08.28

> BR0484I BRARCHIVE log file: /oracle/QBS/saparch/aeardegy.svd

> BR0252W Function remove() failed for '/oracle/QBS/920_64/dbs/sap.ora' at location BrInitOraCreate-1

>

> BR0253W errno 13: Permission denied

>

> BR0252W Function fopen() failed for '/oracle/QBS/920_64/dbs/initQBS.ora' at location BrInitOraCopy-2

>

> BR0253W errno 13: Permission denied

make sure the owner of brarchive in the kernel directory is ora<SID> and that the s-bit is set (or simply execute "./saproot.sh <SID>" in the kernel directory).

Markus

former_member204746
Active Contributor
0 Kudos

your colleague posted the same error.. are you both working on the same issue? are you using 2 ID asking the same question?

Former Member
0 Kudos

Same message raised by shisir

Check Permission of archived file which is giving error .

It can be happen archive file not filled by arcn process supplied by online redolog file.

You can take online archive backup again only with -s option .

For Br error code and action see Snote -17163.

Check Your userID,UserGroup which you r using for brarchive.

Former Member
0 Kudos

seems to be permission issue, check the permissions/owner for brarchive

Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA

Former Member
0 Kudos

Thanks for your prompt reply but i have checked note 113747 but did'nt get clear idea .can you explore this more .

Former Member
0 Kudos

Hello,

Does the user running this has sufficient rights on the filesystem

oracle/QBS/saparch/archQBS.log...?

The user must be a part of the dba group.

may help you.

Thanks,Prasanna

Former Member
0 Kudos

as per logs,

two reasons possible,

permission/owner the tool or permission/owner of the target on which this tool is trying to act

as per Note, you could check the permission and owner of brtools, brarchive etc by going into exe directory

at os, as sidadm, type

cdexe or cd /sapmnt/SID/exe

ls -l brarchive

and check ther permission and owner, should be good as per Note, otherwise change them manually by chmod or chown or run saproot.sh SID, which automatically adjusts the permissions for these

and other alternative, check permission/owner of /oracle/SID/saparch, should be orasid and with dba group, as already suggested by Prasanna