1、建catalog时,RMAN登陆target库时报错:
[oracle@liuqi1 ~]$ rman target system/oracle@test1 catalog cata/cata@catadb
Recovery Manager: Release 11.2.0.3.0 - Production on Tue May 5 13:26:43 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges
2、授权了sysdba的权限
[oracle@liuqi1~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue May 5 13:27:08 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> grant sysdba to system;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
3、再次登陆成功
[oracle@liuqi1~]$ rman target system/oracle@test1 catalog cata/cata@catadb
Recovery Manager: Release 11.2.0.3.0 - Production on Tue May 5 13:27:24 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: test1 (DBID=2082231315)
connected to recovery catalog database
RMAN>
[oracle@liuqi1 ~]$ rman target system/oracle@test1 catalog cata/cata@catadb
Recovery Manager: Release 11.2.0.3.0 - Production on Tue May 5 13:26:43 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges
2、授权了sysdba的权限
[oracle@liuqi1~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue May 5 13:27:08 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> grant sysdba to system;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
3、再次登陆成功
[oracle@liuqi1~]$ rman target system/oracle@test1 catalog cata/cata@catadb
Recovery Manager: Release 11.2.0.3.0 - Production on Tue May 5 13:27:24 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: test1 (DBID=2082231315)
connected to recovery catalog database
RMAN>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27126919/viewspace-1623724/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27126919/viewspace-1623724/
本文探讨了在遇到RMAN-00554错误时,如何诊断和解决数据库初始化内部恢复管理器失败的问题。内容来源于ITPUB博客,详细分析了可能的原因及修复策略。
646

被折叠的 条评论
为什么被折叠?



