-bash-3.2$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 19 10:46:45 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> create user rc_01 identified by rc_011234
2 default tablespace rc_tbs
3 quota unlimited on rc_tbs;
User created.
SQL> grant recovery_catalog_owner to rc_01;
Grant succeeded.
-bash-3.2$ rman target / catalog=rc_01/rc_011234@oratest
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Apr 19 10:49:36 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORATEST (DBID=3309052188)
connected to recovery catalog database
RMAN> create virtual catalog;
found ineligible base catalog owned by RC_USER
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06801: no base catalog found
-bash-3.2$ oerr rman 6426
6426, 1, "RECOVERY_CATALOG_OWNER role must be granted to user %s"
// *Cause: The CREATE CATALOG or UPGRADE CATALOG command was used, but the
// USERID that was supplied in the CATALOG connect string does not
// have the RECOVERY_CATALOG_OWNER role granted as a DEFAULT role.
// *Action: Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog
// owner.
-bash-3.2$ rman target / catalog=rc_user/rc_user1234@oratest
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Apr 19 10:50:21 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORATEST (DBID=3309052188)
connected to recovery catalog database
RMAN> grant catalog for database oratest to rc_01;
Grant succeeded.
RMAN> exit
Recovery Manager complete.
-bash-3.2$ rman target / catalog=rc_01/rc_011234@oratest
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Apr 19 11:06:01 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORATEST (DBID=3309052188)
connected to recovery catalog database
RMAN> create virtual catalog;
found eligible base catalog owned by RC_USER
created virtual catalog against base catalog owned by RC_USER
RMAN>
No comments:
Post a Comment