RMAN-04004: error from recovery catalog database: ORA-00942: table or view doesnot exist 解决方式...

为了使用rman,建立了用户rman, 用命令'rman catalog rman/rman'登录时报错:

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: initialization of internal recovery manager package failed

RMAN-04004: error from recovery catalog database: ORA-00942: table or view does

not exist

下面描述我遇到这个问题的过程及解决方法：

1.建立用户：

create tablespace rman_ts datafile 'D:/Oracle/product/10.1.0/oradata/rman/rman_ts.dbf' size 20M;

create user rman identified by rman default tablespace rman_tstemporary tablespace temp quota unlimited on rman_ts;

grant connect,resource,recovery_catalog_owner to rman;

2. 执行rman catalog rman/rman时，系统报上述的错误。

3. 解决方式：

以系统管理员账户登录Oracle系统，把dba权限授予rman即可。

即：grant dba to rman.