Forum Stats

  • 3,814,069 Users
  • 2,258,814 Discussions


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

User_522VA Member Posts: 1 Green Ribbon

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/[email protected] 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/[email protected]", 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;