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

  • 12 May 2021
  • 0 replies
  • 491 views

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:

Example:

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


0 replies

Be the first to reply!

Reply