急救:RMAN备份连接catalog数据库出现错误

[复制链接]
查看11 | 回复1 | 2006-4-17 13:46:34 | 显示全部楼层 |阅读模式
今天在一数据库上准备做rman备份,在建立好目录的表空间, 创建了RMAN用户 rman并给rman授予了权限。语句如下:
SQL> create tablespace rman datafile 'c:\oracle\oradata\cim64\rman.dbf' size 50m
SQL>create user rman identified by rman default tablespace rman temporary tablespace temp;
SQL>grant connect, resource, recovery_catalog_owner to rman;
14[/SIZE] .
然后打开RMAN
RMAN> connect catalog rman/rman
RMAN-06008: connected to recovery catalog database
RMAN-06099: error occurred in source file: krmk.pc, line: 20575
RMAN-06097: text of failing SQL statement: declare vsn varchar2 ( 20 ) ; begin vsn := dbms_rcvcat . getPackageVersion ;

kg_vsn

kg_vsn_
i := vsn ; if vsn is not null then

kg_vsnub4 := to_number ( substr ( vsn , 1 , 2 ) || substr ( vsn , 4 , 2 ) || substr ( vsn , 7 , 2 )
) ; end if ; end ;
RMAN-06004: ORACLE error from recovery catalog database: ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "RMAN.DBMS_RCVCAT" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

RMAN> create catalog tablespace rman
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "rman": expecting one of: "double-quoted-string, identifier, single-quoted-string"
RMAN-01007: at line 1 column 27 file: standard input
没看懂错误提示是什么意思?请各位帮帮忙,我们头还等我消息呢。
回复

使用道具 举报

千问 | 2006-4-17 13:46:34 | 显示全部楼层
删除该用户RMAN后重新创建。
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行