My Oracle Support Banner

RMAN "show all" get error: RMAN-06613 ORA-20079 (Doc ID 2630535.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Information in this document applies to any platform.


NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.


1. RMAN "show all" returns the following error when connecting to a database which was previously a physical standby database.


RMAN> connect target /

connected to target database: xxx (DBID=2693775679)

RMAN> show all;

starting full resync of recovery catalog
ORA-20079: full resync from primary database is not done

doing automatic resync from primary
resyncing from database with DB_UNIQUE_NAME PRIMARY
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 11/13/2019 16:26:05
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 11/13/2019 16:26:05
RMAN-06613: Connect identifier for DB_UNIQUE_NAME STBY not configured

2. v$database has following value for column: PRIMARY_DB_UNIQUE_NAME

SQL> select PRIMARY_DB_UNIQUE_NAME from v$database;



3. RMAN debug trace show following error:



DBGRESYNC: channel default: Calling checkOnlineRedoLog +DMARCH/chdmpd1s/onlinelog/group_40.4544.962535013 [18:14:58.854] (resync)
DBGRPC: krmxrpc - channel default kpurpc2 err=0 db=rcvcat proc=RMANCHDMPD1.DBMS_RCVCAT.CHECKONLINEREDOLOG excl: 0
DBGRESYNC: channel default: Calling checkOnlineRedoLog +DMARCH/chdmpd1s/onlinelog/group_51.4545.962535013 [18:14:58.856] (resync)
DBGRPC: krmxrpc - channel default kpurpc2 err=20079 db=rcvcat proc=RMANCHDMPD1.DBMS_RCVCAT.CHECKONLINEREDOLOG excl: 159 <<<<<<<<<<<<<<<<<<< err=20079 when checking group_51.4545.962535013






To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.