Pages

Wednesday, 27 May 2015

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;

Error:

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 05/27/2015 14:55:04
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


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

No comments:

Post a Comment