Below is the error message I receive in rman
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
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
2> set until scn <scn>;
3> restore database;
4> recover database;
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;