Month: March 2014

Duplicating for standby PLS-00201: identifier ‘DBMS_RCVCAT.GETDBID’ must be declared

when duplicating with

RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE;

you might encounter the following error

Starting restore at 27-MAR-14

using channel ORA_AUX_DISK_1

DBGSQL: TARGET> begin :fhdbi := dbms_rcvcat.getDbid; end;
DBGSQL: sqlcode = 6550
DBGSQL: B :fhdbi = 1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/27/2014 15:30:58
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

to solve the above issue make sure you specify nocatalog when  when connecting with rman

Example

#rman nocatalog