Symptom
Online Backup fails with error:
BR0301E SQL error -1031 at location BrTspBackAlter-3, SQL statement: '/ BRBACKUP / ALTER TABLESPACE "SYSAUX" BEGIN BACKUP'
ORA-01031: insufficient privileges
However, sapdba role is rereated with note 134592 and assigned:
select GRANTEE, GRANTED_ROLE from dba_role_privs where GRANTEE like 'OPS$%';
OPS$ORAVEQ SAPDBA
OPS$ORACLE SAPDBA
OPS$SAPSERVICEVEQ SAPDBA
OPS$VEQADM SAPDBA
Read more...
Environment
oracle 12.2
Product
Keywords
oracle 12.2 bug SYSAUX online backup ORA-1031 , KBA , BC-DB-ORA-DBA , Database Administration , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.