Home / Installation/Configurations10g / RMAN backup and logical backup With Different User

RMAN backup and logical backup With Different User

RMAN backup and logical backup With Different User

Step 1: Create the 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; 

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.


About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also


Tablespace Level Fragmentation

Tablespace Level Fragmentation in Oracle Database Introduction In this article, I will discuss tablespace level …

Leave a Reply