Contact Premier Online Trainings Today

Oracle DBA - PLS-00201 identifier DBMS_RCVCAT GETDBID must be declared

Date Added: 30 Nov.2019 Date Updated: 30 Nov.2019 Oracle DBA Full Blog

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