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;