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>