RMAN "show all" get error: RMAN-06613 ORA-20079
(Doc ID 2630535.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]Information in this document applies to any platform.
Symptoms
1. RMAN "show all" returns the following error when connecting to a database which was previously a physical standby database.
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;
PRIMARY_DB_UNIQUE_NAME
------------------------------
STBY
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
......
......
Cause
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
Symptoms |
Cause |
Solution |