Oracle11g创建虚拟私有目录RMAN-06004ORA-00942错误的处理
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Oracle11g创建虚拟私有目录RMAN-06004ORA-00942错误的处理,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3234字,纯文字阅读大概需要5分钟。
内容图文
![Oracle11g创建虚拟私有目录RMAN-06004ORA-00942错误的处理](/upload/InfoBanner/zyjiaocheng/562/fe2763c81814451ca9c517f5125c31c4.jpg)
一个网友在Linux下的11.2.0.4 中创建RMAN的虚拟私有目录报错, 从信息可以看到found eligible base catalog owned by RMAN,说明已
一个网友在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错误信息。
--------------------------------------推荐阅读 --------------------------------------
RMAN 配置归档日志删除策略
Oracle基础教程之通过RMAN复制数据库
RMAN备份策略制定参考内容
RMAN备份学习笔记
Oracle数据库备份加密 RMAN加密
--------------------------------------分割线 --------------------------------------
本文永久更新链接地址:
,内容总结
以上是互联网集市为您收集整理的Oracle11g创建虚拟私有目录RMAN-06004ORA-00942错误的处理全部内容,希望文章能够帮你解决Oracle11g创建虚拟私有目录RMAN-06004ORA-00942错误的处理所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。