使用RMAN DUPLICATE复制数据库时出现PLS-00201错误

刘泽宇

在使用RMAN DUPLICATE活动复制数据库搭建物理备库时，出现报错：
DBGSQL:     TARGET> begin :fhdbi := dbms_rcvcat.getDbid; end;
DBGSQL:        sqlcode = 6550
DBGSQL:         B :fhdbi = 32767
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/18/2021 20:11:36
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
ORA-06550: line 1, column 17:
PLS-00201: identifier 'DBMS_RCVCAT.GETDBID' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


数据库使用的是非catalog，因此在连接时，需要跟上nocatalog关键字：
rman target sys/oracle@orcl auxiliary sys/oracle@orcldg nocatalog

connected to target database: ORCL (DBID=1589961912)
using target database control file instead of recovery catalog
connected to auxiliary database: ORCL (not mounted)


再次进行 duplicate target database for standby fromactive database;即可