Skip to main content

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


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

 

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;

0 replies

Be the first to reply!

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