RMAN backup and logical backup With Different User

RMAN backup and logical backup With Different User

Step 1: Create the user

CREATE USER bkp_user IDENTIFIED BY bkp_user DEFAULT TABLESPACE users TEMPORARY 
TABLESPACE temp PROFILE DEFAULT; 
GRANT CONNECT TO bkp_user; 
GRANT exp_full_database TO bkp_user; 
GRANT imp_full_database TO bkp_user; 
GRANT recovery_catalog_owner TO bkp_user; 
GRANT select_catalog_role TO bkp_user; 
GRANT CREATE SESSION TO bkp_user; 

Step 2: Connect RMAN with the Above Created User

$ rman

RMAN> connect target bkp_user/bkp_user

RMAN> backup database;

Note: Script can be written and job can be scheduled to take backup.