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

60 阅读 0 评论 40 点赞

我是靠谱客的博主狂野星月，最近开发中收集的这篇文章主要介绍Oracle 11g创建虚拟私有目录RMAN-06004 ORA-00942错误的处理，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

一个网友在linux下的11.2.0.4 中创建RMAN的虚拟私有目录报错:

[oracle@jb ~]$ rman
Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:23:25 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates.
All rights reserved.
RMAN> connect catalog vpc1/vpc1@cs
connected to recovery catalog database
RMAN> 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，虚拟私有目录用户 virtcat

1.创建基本恢复目录用户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@cs
Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:24:50 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates.
All rights reserved.
connected to recovery catalog database
RMAN> create catalog;
recovery catalog created
RMAN> grant register database to virtcat;
Grant succeeded.

3.创建虚拟私有恢复目录

[oracle@jb cs]$ rman catalog virtcat/virtcat@cs
Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:25:40 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates.
All rights reserved.
connected to recovery catalog database
RMAN> 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@cs
Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:46:51 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates.
All rights reserved.
connected to target database: DB (DBID=1640573015)
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

总结：在创建与使用虚拟私有恢复目录时，基本恢复目录中不能注册目标数据库，否则会出现RMAN-06004, ORA-00942错误信息。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26015009/viewspace-1633550/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26015009/viewspace-1633550/