Thursday, April 19, 2012

RMAN vitual private catalog - RMAN-06801: no base catalog found



-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