Skip to main content

CDB Restore is failing with ORA-01031: insufficient privileges when using sysbackup privilige


Commvault Marcus
Vaulter
Forum|alt.badge.img+8

 

Multi-tenant CDB restores fail during the recovery phase with the following error when using sysbackup privilige:

 

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 05/11/2021 15:33:48

RMAN-11003: failure during parse/execution of SQL statement: alter database recover datafile list clear

ORA-01031: insufficient privileges

 

to overcome this error make sure that the user was created with container=all statement:

Example:

create user C##BACKUP identified by ********* container=all;

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings