October 27, 2011 / doganay
RMAN USER AND CATALOG USER NECESSARY GRANTS
about oracle, about oracle 11g, about oracle 11g database, about oracle 11g documentation, about oracle database, about oracle database 10g, about oracle database 11g, about oracle database architecture, about oracle database management system, about oracle database tutorial, architecture of oracle database 11g, backup, backup and recovery in oracle 10g using rman, backup and recovery in oracle 11g using rman, backup and restore, backup e restore, backups for backups, features of oracle database 11g, features of oracle database 11g contribute to reduce storage costs, features of oracle database 11g release 2, how to backup and restore, in oracle, list rman commands oracle 10g, oracle, oracle 10g rman commands list, oracle 11g, oracle 11g documentation, oracle 11g documentation release 2, oracle 11g new features, oracle 11g new features for dba, oracle 11g rman cold backup script, oracle 11g rman full backup script, oracle 11g rman hot backup script, oracle as, oracle as a service, oracle as a service linux, oracle for, oracle for beginners, oracle for beginners pdf, oracle for beginners tutorial, oracle for linux, oracle for linux 5, oracle for linux 6, oracle in, oracle rman backup shell script, oracle rman commands list, oracle sql, oracle sql developer, oracle sql queries, oracle sql queries examples, oracle sql queries examples with answers, oracle sql tutorial, oracle sql tutorial for beginners, oracle sql tutorial with examples, oracle tutorial, oracle tutorial for beginners, oracle tutorial for beginners pdf, oracle tutorial pdf, oracle tutorial pdf for beginners, oracle tutorial with examples, oracle tutorial with examples pdf, oracle with, restore, RMAN, RMAN backup, rman backup and recovery, rman backup and recovery in oracle 10g, rman backup and recovery in oracle 11g, rman backup commands, rman backup commands in oracle 10g, rman backup commands in oracle 11g, rman backup commands in oracle 9i, rman backup commands oracle, rman backup commands oracle 10g, rman backup commands oracle 11g, rman backup commands oracle 9i, rman backup in oracle 9i, rman backup script, rman backup script for linux, rman backup script in oracle 10g, rman backup script oracle 11g, rman backup script unix, rman backup shell script, rman backup shell script example, rman backup shell script linux, rman backup shell script unix, rman cold backup script unix, rman commands, rman commands in oracle, rman commands in oracle 10g, rman commands in oracle 11g, rman commands in oracle 8i, rman commands list, rman commands list backup, rman hot backup script unix, rman in oracle, rman in oracle 10g, rman in oracle 11g, rman in oracle 11g guide, rman in oracle 9i, rman in oracle 9i database, rman incremental backup in oracle 9i, sql oracle, sql oracle developer, sql oracle tutorial, sql oracle tutorial beginners, sql oracle tutorial pdf, sql oracle tutorial queries, the oracle, the oracle answers, the oracle answers questions, the oracle answers yes no, the oracle answers your questions, unix shell script rman backup, what is oracle, what is oracle database, what is oracle database 10g, what is oracle database 10g client, what is oracle database 10g client release 2, what is oracle database 10g express, what is oracle database 10g express edition, what is oracle database 11g, what is oracle database 11g express edition, what is oracle database 11g release 1 client, what is oracle database server
Hi,
You must grant these to rmanuser (db user) and catalog user (rman catalog) in order to accomplish a successful backup:
catalog ------------------- GRANT EXP_FULL_DATABASE TO mycataloguser; GRANT RECOVERY_CATALOG_OWNER TO mycataloguser; GRANT CONNECT TO mycataloguser; ALTER USER mycatalog DEFAULT ROLE ALL; ALTER USER mycatalog QUOTA UNLIMITED ON ; GRANT SELECT ON SYS.ROLE_ROLE_PRIVS TO mycataloguser; GRANT SELECT ON SYS.USER_ROLE_PRIVS TO mycataloguser; GRANT SELECT ON SYS.USER_TAB_PRIVS TO mycataloguser; rmanuser ------------------ alter user rmanuser quota unlimited on users; grant create session, alter session, sysdba to rmanuser;
try and pray 🙂
Advertisements
Leave a Reply