Oracle 11g创建虚拟私有目录RMAN-06004 ORA-00942错误的处理

一个网友在Linux下的11.2.0.4 中创建RMAN的虚拟私有目录报错:
[Oracle@jb ~]$ rmanRecovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:23:25 2015Copyright （c） 1982, 2011, Oracle and/or its affiliates. All rights reserved.RMAN> connect catalog vpc1/vpc1@csconnected to recovery catalog databaseRMAN> create virtual catalog;found eligible base catalog owned by RMAN
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-00942: table or view does not exist
从上面信息可以看到found eligible base catalog owned by RMAN,说明已经找到了合格的基本恢复目录用户,由于使用的基本恢复目录用户rman已经注册了数据库,于是新建一个基本恢复目录用户cat1，虚拟私有目录用户 virtcat1.创建基本恢复目录用户cat1,虚拟私有目录用户virtcat
SQL> create user cat1 identified by cat1
2 default tablespace sysaux
3 quota unlimited on sysaux;User created.SQL> grant recovery_catalog_owner to cat1;Grant succeeded.SQL> create user virtcat identified by virtcat
2 default tablespace sysaux
3 quota unlimited on sysaux;User created.SQL> grant recovery_catalog_owner to virtcat;Grant succeeded.
2.创建基本恢复目录
[oracle@jb ~]$ rman catalog cat1/cat1@csRecovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:24:50 2015Copyright （c） 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to recovery catalog databaseRMAN> create catalog;recovery catalog createdRMAN> grant register database to virtcat;Grant succeeded.
3.创建虚拟私有恢复目录
[oracle@jb cs]$ rman catalog virtcat/virtcat@csRecovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:25:40 2015Copyright （c） 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to recovery catalog databaseRMAN> create virtual catalog;found ineligible base catalog owned by RMAN
found eligible base catalog owned by CAT1
created virtual catalog against base catalog owned by CAT1
4.在虚拟私有目录中注册目标数据库
[oracle@jb cs]$ rman target sys/system@db catalog virtcat/virtcat@csRecovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:46:51 2015Copyright （c） 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database: DB （DBID=1640573015）
connected to recovery catalog databaseRMAN> register database;database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
总结：在创建与使用虚拟私有恢复目录时，基本恢复目录中不能注册目标数据库，否则会出现RMAN-06004, ORA-00942错误信息。--------------------------------------推荐阅读 --------------------------------------RMAN 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm--------------------------------------分割线 --------------------------------------更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址