Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ORA-01031: insufficient privileges on first RMAN backup

Hello all,

I am trying to schedule my first RMAN backup in a RAC ASM setup on Oracle Linux 5.5, Oracle version 11.2.0.3, brtools 7.20 patch 23.

I put the following parameters in initSID.sap

backup_dev_type=disk

disk_copy_cmd=rman

asm_ora_sid = (PID1:+ASM1, PID2:+ASM2)

asm_ora_home = (PID1:/oracle/GRID/11203, PID2:/oracle/GRID/11203)

asm_root_dir = ASM

parallel_instances = (PID1:/oracle/PID/112@PID1,PID2:/oracle/PID/112@PID2)

I first try to run the preparation for the RMAN backup with command line:

brbackup -u system/password -p initPID.sap -d rman_prep -t offline -m all -e 0 -l E

I also tried brbackup -u / -p initPID.sap -d rman_prep -t offline -m all -e 0 -l E

In both cases, I get the below:

R0051I BRBACKUP 7.20 (23)

BR0055I Start of database backup: beiqoexy.rmp 2012-05-29 08.05.18

BR0484I BRBACKUP log file: /oracle/PID/sapbackup/beiqoexy.rmp

BR0278E Command output of '/oracle/PID/112/bin/sqlplus /nolog < /oracle/PID/sapb                                                                             ackup/.beiqoexy.spi':

SQL*Plus: Release 11.2.0.3.0 Production on Tue May 29 08:05:18 2012

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

SQL> SQL> SQL> SQL> ERROR:

ORA-01031: insufficient privileges

SQL>

SQL> SP2-0640: Not connected

SQL> SP2-0640: Not connected

SQL>

BR0280I BRBACKUP time stamp: 2012-05-29 08.05.18

BR0279E Return code from '/oracle/PID/112/bin/sqlplus /nolog < /oracle/PID/sapba                                                                             ckup/.beiqoexy.spi': 0

BR0302E SQLPLUS call for database instance PID failed

BR0303E Determination of Oracle version failed

BR0056I End of database backup: beiqoexy.rmp 2012-05-29 08.05.18

BR0280I BRBACKUP time stamp: 2012-05-29 08.05.18

BR0054I BRBACKUP terminated with errors

I have already run sapdba and sapconn roles.

I have read note  776505 - BR*Tools fail with ORA-01017 / ORA-01031 on Linux and have changed the ownership of brbackup and brarchive

-rwsr-srw- 1 oracle dba      6466617 May 25 09:13 brarchive

-rwsr-srw- 1 oracle dba      6596893 May 25 09:13 brbackup

-rwsrwsr-- 1 oracle oinstall 8418234 May 25 09:13 brconnect

-rwsrwsr-- 1 oracle oinstall 7043091 May 25 09:13 brrecover

-rwsrwsr-- 1 oracle oinstall 2398807 May 25 09:13 brrestore

-rwsrwsr-- 1 oracle oinstall 8856765 May 25 09:13 brspace

-rwsrwsr-- 1 oracle oinstall 3279960 May 25 09:13 brtools

Any ideas?

Many thanks

Andreas

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question