cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

'/* BRBACKUP */ ALTER TABLESPACE "SYSAUX" BEGIN BACKUP' ORA-01031: insufficient privileges

SwapnilkumarL1
Participant

on ‎10-03-2019 7:07 AM

0 Kudos

While taking oracle backup on OS level we are facing error '/* BRBACKUP */ ALTER TABLESPACE "SYSAUX" BEGIN BACKUP' ORA-01031: insufficient privileges.

Please suggest on the same

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (6)

Answers (6)

SwapnilkumarL1
Participant
‎10-11-2019 7:32 AM
0 Kudos

Hi,

Our issue has been resolved by applying SBP bundle patches and updating Opatch.

Regards,

Akash

Show replies
Show replies
SwapnilkumarL1
Participant
‎10-09-2019 7:26 AM
0 Kudos

Dear Sameer,

We have followed SAP note: 134592 but same issue occurs please check below.

EPDEV:oraepd 56> sqlplus /nolog @sapdba_role SR3DB SQL*Plus: Release 12.2.0.1.0 Production on Wed Oct 9 11:37:48 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved. Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production EPDEV:oraepd 57> sqlplus /nolog @sapdba_role SR3 SQL*Plus: Release 12.2.0.1.0 Production on Wed Oct 9 11:37:57 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved. Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production EPDEV:oraepd 58> grant ALL on SAPSR3DB.DBAML to sapdba grant: Command not found. EPDEV:oraepd 59> sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Oct 9 11:40:04 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> grant ALL on SAPSR3DB.DBAML to sapdba 2 * 3 SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production EPDEV:oraepd 60> ls -lrt total 40 lrwxrwxrwx 1 root root 18 Aug 22 00:18 stage -> /oracle/EPD/stage/ drwxrwx--- 5 oraepd dba 4096 Aug 22 00:51 oraInventory drwxr-xr-x 3 root root 4096 Aug 22 00:53 client drwxr-xr-x 24 oraepd dba 4096 Aug 22 17:07 EPD -rwxrwxrwx 1 oraepd dba 3191 Oct 3 11:39 sapconn_role.sql -rwxrwxrwx 1 oraepd dba 9986 Oct 3 11:51 sapdba_role.sql -rw-r--r-- 1 oraepd dba 11930 Oct 9 11:38 sapdba_role.log EPDEV:oraepd 61> pwd /oracle EPDEV:oraepd 62> brbackup -p initEPD.sap -d disk -t online -m all -k yes -e 2 -l E -u / -c BR0051I BRBACKUP 7.40 (34) BR0055I Start of database backup: bfceypfk.and 2019-10-09 11:44:00 BR0484I BRBACKUP log file: /oracle/EPD/sapbackup/bfceypfk.and BR0477I Oracle pfile /oracle/EPD/sapprof/initEPD.ora created from spfile /oracle/EPD/122/dbs/spfileEPD.ora BR1805I Oracle spfile /oracle/EPD/sapprof/spfileEPD.ora created from pfile /oracle/EPD/sapprof/initEPD.ora BR0280I BRBACKUP time stamp: 2019-10-09 11:44:04 BR0319I Control file copy created: /oracle/EPD/sapbackup/cntrlEPD.dbf 21479424 BR0280I BRBACKUP time stamp: 2019-10-09 11:44:04 BR0057I Backup of database: EPD BR0058I BRBACKUP action ID: bfceypfk BR0059I BRBACKUP function ID: and BR0110I Backup mode: ALL BR0077I Database file for backup: /oracle/EPD/sapbackup/cntrlEPD.dbf BR0061I 5 files found for backup, total size 10510.516 MB BR0143I Backup type: online BR0111I Files will be compressed BR0130I Backup device type: disk BR0106I Files will be saved on disk in directory: /backup/Fullbackup/data/bfceypfk BR0140I Number of parallel copy processes: 2 BR0126I Unattended mode active - no operator confirmation required BR0370I Directory /backup/Fullbackup/data/bfceypfk created BR0202I Saving init_ora BR0203I to /backup/Fullbackup/data/EPD ... BR0202I Saving /oracle/EPD/sapprof/initEPD.sap BR0203I to /backup/Fullbackup/data/EPD ... BR0280I BRBACKUP time stamp: 2019-10-09 11:44:04 BR0198I Profiles saved successfully BR0280I BRBACKUP time stamp: 2019-10-09 11:44:05 BR0315I 'Alter tablespace PSAPSR3DB begin backup' successful BR0201I Compressing /oracle/EPD/sapdata4/sr3db_1/sr3db.data1 BR0203I to /backup/Fullbackup/data/bfceypfk/sr3db.data1.Z ... BR0280I BRBACKUP time stamp: 2019-10-09 11:44:05 BR0301E SQL error -1031 at location BrTspBackAlter-3, SQL statement: '/* BRBACKUP */ ALTER TABLESPACE "SYSAUX" BEGIN BACKUP' ORA-01031: insufficient privileges BR0280I BRBACKUP time stamp: 2019-10-09 11:44:05 BR0316E 'Alter tablespace SYSAUX begin backup' failed BR0280I BRBACKUP time stamp: 2019-10-09 11:44:07 BR0317I 'Alter tablespace PSAPSR3DB end backup' successful BR0056I End of database backup: bfceypfk.and 2019-10-09 11:44:05 BR0280I BRBACKUP time stamp: 2019-10-09 11:44:08 BR0054I BRBACKUP terminated with errors EPDEV:oraepd 63>

Show replies
Show replies
former_member634863
Discoverer
‎10-08-2019 9:24 AM
0 Kudos

Please run sapdba_role.sql. Follow the note. This should fix your issue.

134592 - Import of SAPDBA role (sapdba_role.sql)

Thanks,

Sameer

Show replies
Show replies
SwapnilkumarL1
Participant
‎10-03-2019 11:19 AM
0 Kudos

Dear Team,

Please update still we are facing same issue

Show replies
Show replies
SwapnilkumarL1
Participant
‎10-03-2019 9:16 AM
0 Kudos

But in our environment for same oracle version in other system backup is successful then why we need to apply bundle patch. please find below patch version for DEV system which backup failed and for QAS backup got succeed.

DEV version

SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- CON_ID ---------- Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0 PL/SQL Release 12.2.0.1.0 - Production 0 CORE 12.2.0.1.0 Production 0 BANNER -------------------------------------------------------------------------------- CON_ID ---------- TNS for Linux: Version 12.2.0.1.0 - Production 0 NLSRTL Version 12.2.0.1.0 - Production 0 SQL>

QAS version

SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- CON_ID ---------- Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0 PL/SQL Release 12.2.0.1.0 - Production 0 CORE 12.2.0.1.0 Production 0 BANNER -------------------------------------------------------------------------------- CON_ID ---------- TNS for Linux: Version 12.2.0.1.0 - Production 0 NLSRTL Version 12.2.0.1.0 - Production 0 SQL>

Show replies
Show replies
janos_mucsi-besze
Advisor
Advisor
‎10-08-2019 3:51 PM
0 Kudos

What you provided is not the Patch version. You need to query dba_registry_sqlpatch and dba_registry_history. And most importantly check if the Bundle Patch was installed correctly/successfully/completely.

One need to understand that Oracle introduced a more strengthened check to put the SYSAUX tablespace into BACKUP mode.

This is documented in the Oracle guide:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/ALTER-TABLESPACE.html#GUID-CA0...

But this is also documented internally by Oracle in a MOS document:

ORA-1031: Insufficient Privileges In 12cR2 (Doc ID 2252018.1)

Later on this 'enhancement'/restriction got addressed by a Fix. This Fix got first included in below Bundle Pacthes:

UNIX: Patch 12.2.0.1.190115 - 201902
Windows: PATCHBUNDLE12201P_1902-70001556

former_member207186
Contributor
‎10-03-2019 8:08 AM
0 Kudos

Hi,

Regarding this issue, you can check SAP Note
2608913 - Error ORA-01031 in BRBACKUP for tablespace SYSAUX with Oracle 12.2

Regards,
Bíborka

Show replies
Show replies
Ask a Question