- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Oracle RMAN Recover database fails with error when done using SYSBACKUP user
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/[email protected] 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/[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;