Skip to Main Content

Oracle RMAN Recover database fails with error when done using SYSBACKUP user

User_522VAOct 8 2021

Below is the error message I receive in rman

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/08/2021 20:48:37
RMAN-11003: failure during parse/execution of SQL statement: alter database recover datafile list clear
ORA-01031: insufficient privileges

I am logged in on a different machine.
I use rman target "user/passwd@service AS SYSBACKUP"
then run the below script
run {
2> set until scn <scn>;
3> restore database;
4> recover database;
5> }
datafiles are restore but during recover phase I get the insufficient privilege error.
If I connect to rman as target "sys/passwd@service", I am able to restore and recover the database.
The user with SYSBACKUP privilege is created as follows:
create user c##restore_guy identified by passwd container=all;
grant SYSBACKUP TO c##restore_guy;

Post Details
Added on Oct 8 2021