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

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

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: