we currently see the ORA-01031 “Insufficient privileges” error in the Oracle alertlog when running an intellisnap backup of a RAC database. The comands to run are
alter database begin backup
ALTER DATABASE BACKUP CONTROLFILE TO '+DGDATA/backup.ctl.galaxy’ REUSE
alter database end backup
Each command results in an ORA-01031.
User used to backup has SYSBACKUP privileges.
Any ideas to solve this issue are welcome!
Best answer by westwood71
The issue was that sysbackup role was granted on current container only.
Granting sysbackup to user with “container=all” resolves the issue.