brbackup errors, please advice

[Former Member]

I do brbackup on instance SR1, online full backup + archivelog, sometimes successful, sometimes fails with the same error(the error appears at different point in each backup run), with exactly the same settings, the server has 6G free memory, should not be a memory issue, following is my error part, please advice:

BR0280I BRBACKUP time stamp: 2007-10-15 13.41.00

BR0063I 24 of 43 files processed - 61360.188 MB of 127840.336 MB done

BR0204I Percentage done: 48.00%, estimated end time: 14:10

BR0001I ************************__________________________

BR0202I Saving /oracle/SR1/sapdata2/sr3700_5/sr3700.data5

BR0203I to /orcl_bkup/SR1/datafile/bdwjnanj/sr3700.data5 ...

BR0278E Command output of 'SHELL=/bin/sh /oracle/SR1/102_64/bin/rman nocatalog':

Recovery Manager: Release 10.2.0.2.0 - Production on Mon Oct 15 13:41:00 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN>

RMAN> connect target *

RMAN-00571: ===========================================================

RMAN-00569: ======= ERROR MESSAGE STACK FOLLOWS ===

RMAN-00571: ============================================

ORA-09925: Unable to create audit trail file

SVR4 Error: 13: Permission denied

Additional information: 9925

RMAN> *end-of-file*

RMAN>

host command complete

RMAN> 2> 3> 4> 5> 6>

RMAN-00571: =====================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

RMAN-00571: ===========================================================

RMAN-03002: failure of allocate command at 10/15/2007 13:41:01

RMAN-06171: not connected to target database

RMAN>

Recovery Manager complete.

BR0280I BRBACKUP time stamp: 2007-10-15 13.41.01

BR0279E Return code from 'SHELL=/bin/sh /oracle/SR1/102_64/bin/rman nocatalog': 1

BR0536E RMAN call for database instance SR1 failed

BR0280I BRBACKUP time stamp: 2007-10-15 13.41.01

BR0506E Full database backup (level 0) using RMAN failed

BR0222E Copying /oracle/SR1/sapdata2/sr3700_5/sr3700.data5 to/from /orcl_bkup/SR1/datafile/bdwjnanj failed due to previous errors

BR0056I End of database backup: bdwjnanj.fnd 2007-10-15 13.41.02

BR0280I BRBACKUP time stamp: 2007-10-15 13.41.04

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2007-10-15 13.41.04

[Former Member · Accepted solution]

ORA-09925: Unable to create audit trail file

-- In init<SID..ora find the directory set to AUDIT_FILE_DEST. Can you please check the permissions of this directory at the OS level?

[Former Member · Accepted solution]

hi,

the permission is:

drwxr-xr-x 2 orasr1 dba /oracle/SR1/102_64/rdbms/audit

I am running brbackup from sapgui /db13,

I am not sure whether this is a permission issue, even the error says so,

because the brbackup run sometimes succeed, sometimes failed, with exactly the same settings, if it is a permission issue, it would fail everytime, correct? please advice

[Former Member · Accepted solution]

Right click on the ORACLE_HOME folder--->Properties->Security Tab->Advance .

See the users and the permissions. Check if the Administrator and the SYSTEM user has Full Control under the Permission tab.

Regards

[Former Member]

Nebody pls reply if u can find the solution to the following job log:-

Job name Status Scheduled start Actual start End Time

DBA:ALLOFF+LOG______@193446/4000 Completed 03.01.2008 19:34:53 03.01.2008 19:34:53 03.01.2008 19:34:53]

The job details are as folllows:-

Job started

Step 001 started (program RSDBAJOB, variant &0000000000374, user ID KRATHOD)

Execute logical command BRBACKUP On host sappro-mum

Parameters:-u / -jid ALGOF20080103193446 -c force -t offline_force -m all -p initSRP.sap -v SRPB10 -a -c force

-p initSRP.sap -cds

Job finished

[Former Member]

Priyankush,

As per the log Please delete file E:\oracle\SRP\sapbackup\.lock.brb and kick off the backup again

[Former Member]

hey bos thanks......pls reply the offline backup issue....it wil be very nice of u.thanks again.also pls tell me where to give reward points

Edited by: Priyankush Ghosh on Jan 4, 2008 4:52 AM

[Former Member]

My client is getting the following error when trying to do the back-up online...pls help.

BR0051I BRBACKUP 7.00 (13)

BR0055I Start of database backup: bdwypiha.ant 2008-01-03 21.00.54

BR0071E BRBACKUP currently running or was killed

BR0072I Please delete file E:\oracle\SRP\sapbackup\.lock.brb if BRBACKUP was killed

BR0073E Setting of BRBACKUP lock failed

BR0056I End of database backup: bdwypiha.ant 2008-01-03 21.00.54

BR0280I BRBACKUP time stamp: 2008-01-03 21.00.54

BR0054I BRBACKUP terminated with errors

[Former Member]

Please refer to SAP Note 40730 - adm user cannot start database //

SAP Note 480266 - Problems with the SYSDBA/SYSOPER/INTERNAL connect

Regards,

Prem

[Former Member]

Hi ,

As ORA-09925 occurs along with operating system error 13 (Permission denied), there may be problems accessing the files under $ORACLE_HOME/rdbms/audit. Check whether this directory exists and whether ora<sid> has write permission. Also checkout Note 583861.

Regards

Umesh

[Former Member]

Hi,

Pl check the following note to get an insight of the prob

Note 583861 - UNIX: Errors due to Oracle executable.

Though it is for unix, still it gives a good tracking.

Hope it helps.

Regards