Skip to Content
avatar image
Former Member

brbackup errors, please advice

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 16, 2007 at 03:05 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Oct 16, 2007 at 05:38 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2007 at 05:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2007 at 07:02 AM

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

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

    Regards,

    Prem

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 04, 2008 at 05:02 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 04, 2008 at 05:09 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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