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

  • 12 May 2021
  • 0 replies

Userlevel 2
Badge +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:


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

0 replies

Be the first to reply!