PLS-00201 identifier DBMS_RCVCAT GETDBID must be declared
Getting below error during duplication for standby in target database.
Statement in RMAN:
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER NOFILENAMECHECK;
Issue -
Starting restore at 01-DEC-19
using channel ORA_AUX_DISK_1
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 12/01/2019 00:16:19
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
RMAN>
Solution:
Started the duplication for standby in target in nomount and got the above error,I stop the DB and agian started in nomount then tried the RMAN command.
SQL> shut immediate
SQL> startup nomount
In
RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER NOFILENAMECHECK;
Now the statement is successfull and started the duplication
