Symptoms
Windows Oracle backup fails with the error "ORA-01031: Insufficient privileges" when only SYSBACKUP privilege is granted to a user.
The avoracle log indicates that the user test is used to connect to a database:
++++++++++++++++++++++++++++++++++++
avoracle Info : RMAN is connecting to the Oracle DB as the DB user 'test'
avoracle Info : RMAN=c:\work\windows.x64_193000_db_home\bin/rman
avoracle Info : RMAN=c:\work\windows.x64_193000_db_home\bin/rman
avoracle Error : Snapup of ORCL aborted due to rman terminated abnormally - check the logs
++++++++++++++++++++++++++++++++++++
Recovery Manager (RMAN) log indicates that the user does not have sufficient privileges and is not able to establish the connection:
++++++++++++++++++++++++++++++++++++
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges
Recovery Manager complete.
++++++++++++++++++++++++++++++++++++
Cause
This occurs due to a software glitch in the Avamar Windows avoracle plug-in.
Resolution
Upgrade the Avamar Server to version 19.8.100-83 or later. The fix is incorporated in Avamar 19.8 and later software releases.