sysbackup to user to perform the rman backup

The user trying to perform backup should have sysbackup permission under oracle 12.

But we need to setup few things to get it working. We assume that we are going to use username backup_user to create backups. Below are the steps we need to do in order for it to work.

1. Create new password file.
2. Grant sysbackup to backup_user;
3. Make sure rman backup connect has as sysbackup when connecting to target.

Create New Password File:

$ orapwd file=orapwbase sysbackup=y force=y
Enter password for SYS: <<<< Enter OLD / NEW SYS password >>>>
Enter password for SYSBACKUP: <<<< Enter SYSBACKUP password >>>>


SQL> grant sysbackup to backup_user;

$ rman
RMAN> connect target 'backup_user/<password>@base_prod as sysbackup'     <<<<------------    Mandatory
connected to target database: TESTDB (DBID=123456789)
RMAN>


That's it !!!

This way we are only granting the permissions which are required.