Skip to Content
avatar image
Former Member

BRARCHIVE - ORA-01031: insufficient privileges Error

Hi,

I am getting following error while backing up oracle archive log file.

BR0002I BRARCHIVE 7.00 (22)

BR0006I Start of offline redo log processing: advgvlaz.svd 2007-05-17 00.03.57

BR0484I BRARCHIVE log file: /oracle/BXN/saparch/advgvlaz.svd

BR0477I Oracle pfile /oracle/BXN/102_64/dbs/initBXN.ora created from spfile /oracle/BXN/102_64/dbs/spfi

leBXN.ora

BR0280I BRARCHIVE time stamp: 2007-05-17 00.03.58

BR0301W SQL error -1031 at location BraDbLogOpen-5, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20070517000357', 'svd',

'BXN', 'disk', '9999', ' ', 'advgvlaz', ' ')'

ORA-01031: insufficient privileges

BR0324W Insertion of database log header failed

BR0101I Parameters

Name Value

oracle_sid BXN

oracle_home /oracle/BXN/102_64

oracle_profile /oracle/BXN/102_64/dbs/initBXN.ora

sapdata_home /oracle/BXN

sap_profile /oracle/BXN/102_64/dbs/initBXN.sap

backup_dev_type disk

archive_copy_dir /oracle/BXN/sapbackup

compress no

disk_copy_cmd copy

cpio_disk_flags -pdcu

archive_dupl_del only

system_info orabxn/orabxn cpsapv08 HP-UX B.11.23 U ia64

oracle_info BXN 10.2.0.2.0 8192 364 8385422911885 cpsapv08 UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003BXN0011C16913853470013NetWeaver_ORA

make_info hpia64 OCI_102 Jan 20 2007

command_line /usr/sap/BXN/SYS/exe/run/brarchive -p initBXN.sap -u / -c -sd -d disk

BR0280I BRARCHIVE time stamp: 2007-05-17 00.03.58

BR0301W SQL error -1031 at location BraDbLogOpen-6, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, OBJ, RC, ENDE, ACTID) VALUES ('20070516233347', 'sve', 'tape', '999

9', ' ', 'advgvijj')'

ORA-01031: insufficient privileges

BR0324W Insertion of database log header failed

BR0013W No offline redo log files found for processing

BR0280I BRARCHIVE time stamp: 2007-05-17 00.03.58

BR0301W SQL error -1031 at location BraDbLogOpen-5, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20070517000357', 'svd',

'BXN', 'disk', '9999', ' ', 'advgvlaz', ' ')'

ORA-01031: insufficient privileges

I have already run sapdba_role.sql and sapconn_role.sql on the database for the SAPSID accounts but I am still getting this error. Before it was working fine. This is not working since this database has been system copied from production.

Can somebody please help?

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • May 17, 2007 at 07:02 PM

    Hi,

    Redolog files seems to be corrupted.

    Try to copy them again to the target system.

    If you're doing an ftp, take care to use binary mode for the file transfers.

    Regards,

    Gokhan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 17, 2007 at 07:06 PM

    Hi

    Is ur db upgraded from 9.2 ? if yes please go through these notes.

    834917

    91216

    Thanks

    Prince Jose

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Prince,

      This database is not upgraded from 9iR2. This database is already running in QA, Production. This problem is present since I did system copy from production to this database. This database is at 10.2.0.2.

      Regards

  • avatar image
    Former Member
    May 17, 2007 at 07:07 PM

    Hi Shailandra,

    Which user are you using to execute the brarchive?

    It is possible that this user does not have authorization at the Oracle schema objects level.

    Please, check it.

    If it do not solve your problem, let me know.

    Regards,

    Itamar Marioto

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Eric Brunelle

      Hi,

      I ran the command like this.

      sqlplus /nolog @sapdba_role.sql SAPSR3

      sqlplus /nolog @sapdba_role.sql SAPSR3DB

      The output from the log file does not have any error.

      Regards

  • avatar image
    Former Member
    May 17, 2007 at 07:15 PM

    Shailandra,

    I supose that the problem is the ORA<SID> wasn't adjusted in this database.

    Could you check it please?

    Regards,

    Itamar Marioto

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 18, 2007 at 03:50 AM

    Hi Shailandra,

    Before changing the passwords, check if the database backup works and its only archivelog backup that fails. If database backup works, then it uses the same procedure to authenticate for the brarchive process.

    Are you using the latest sapdba_role.sql script? The error appears to be related to privileges.

    Regards,

    Nisch

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 18, 2007 at 01:42 PM

    Hi,

    I'll try to give a some hints to check as a lot of people here are ( IMHO ) giving non correct advice.

    you are getting the following error:

    <i>BR0301W SQL error -1031 at location BraDbLogOpen-6, SQL statement:

    'INSERT INTO <b>SAP_SDBAH</b> (BEG, FUNCT, OBJ, RC, ENDE, ACTID) VALUES ('20070516233347', 'sve', 'tape', '999

    9', ' ', 'advgvijj')'

    <b>ORA-01031</b>: insufficient privileges</i>

    Which is pretty clear. The user does not have authorizations to insert data in <b>SAP_SDBAH</b> ( nothing to do with the user password )

    I cannot see who is the user who tries to insert ( how did you started the brarchive? )

    nevertheless, <b>SAP_SDBAH</b> is NOT a table but a synonym that points to a SDBAH table ( in one specific schema ). The user does not have authorizations to insert into that table.

    I'd advise to check what is the "underline" table.

    Is this an MCOD system?

    If so, you have to keep in mind that you will have several database users, but the synonym can only point to one of the schemas in the system. This means that you should configure the synonyms and perfom all activities ONLY on one schema ( from only one SAP system, one <sid>adm )

    Add comment
    10|10000 characters needed characters exceeded

    • I believe that newest path sets of BRTOOLS have this issue.

      I had the same issue and added this (on windows):

      sqlplus / as sysdba

      grant select on SAP_SDBAH to sapr3,sapserviceSID,SIDadm;

  • avatar image
    Former Member
    Dec 12, 2010 at 01:19 PM

    Execute the sql script sapdba_role.sql according to sap note 134592.

    You can find the script at /oracle/<SID>/102_64/dbs/ or the note.

    Add comment
    10|10000 characters needed characters exceeded