重庆思庄Oracle、Redhat认证学习论坛

标题: 使用RMAN DUPLICATE复制数据库时出现PLS-00201错误 [打印本页]

作者: 刘泽宇 时间: 2021-1-18 13:20
标题: 使用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;即可

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)