DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, December 9, 2015

RMAN-06613: Connect identifier for DB_UNIQUE_NAME DBNAME_DGS not configured


Rman backup is failed with the error RMAN-06613: Connect identifier for DB_UNIQUE_NAME DBNAME_DGS not configured.

Scenario:
Trying to backup from standby database with the catalog database. No Issue seen if we don’t use catalog database.

Full Error:

doing automatic resync from primary
resyncing from database with DB_UNIQUE_NAME DBNAME_DGP
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 12/08/2015 04:12:05
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at 12/08/2015 04:12:05
RMAN-06613: Connect identifier for DB_UNIQUE_NAME DBNAME_DGS not configured


Solution:

1.      1. It can be skipped if you already registered the database with the catalog
From Primary rman prompt (rman target / catalog=username/password@catalogdb)
RMAN>register database;
2.     
2. On catalog database 
select * from rc_database where name = ‘DBNAME’;
select db_unique_name, database_role, site_key from node where db_key=(from the previous output);

3.      
3. From Primary rman prompt (rman target / catalog=username/password@catalogdb)
configure db_unique_name 'DBNAME_DGS' connect identifier 'DBNAME_DGS';


1 comment:

Sridevi K said...


Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.