怎么样创建RMAN恢复目录
[A]首先,创建一个数据库用户,一般都是RMAN,并给予recovery_catalog_owner角色权限
sqlplus sys
SQL> create user rman identified by rman;
SQL> alter user rman default tablespace tools temporary tablespace temp;
SQL> alter user rman quota unlimited on tools;
SQL> grant connect, resource, recovery_catalog_owner to rman;
SQL> exit;
然后,用这个用户登录,创建恢复目录
rman catalog rman/rman
RMAN> create catalog tablespace tools;
RMAN> exit;
最后,你可以在恢复目录注册目标数据库了
rman catalog rman/rman target backdba/backdba
RMAN> register database;
------------------------------------------------------------------------------------------
|创建RMAN恢复目录的过程记录 |
------------------------------------------------------------------------------------------
系统环境:WINXP+ORACLE9.2.0.1客户端
1、在客户端上使用rman的时候提示文件缺少(不知道是什么原因)
C:/>rman
恢复管理器: 版本9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-03000: recovery manager compiler component initialization failed
RMAN-06000: could not open recovery manager library file: D:/oracle9i/ora92/RDBM
S/ADMIN/RECOVER.BSQ
LFI-00108: Open expect the file [RECOVER][BSQ] to exist.
2、从服务端拷贝RECOVER.BSQ到ORACLE目录
C:/>rman
恢复管理器: 版本9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> catalog scott/tiger@pgjt
RMAN-00571: ===========&#