Hi,
Sometimes You can get “RMAN-20079: full resync from primary database is not done ” error.
Details of error are as follows.
RMAN-20079: full resync from primary database is not done
ORA-20079: full resync from primary database is not done
Doing automatic resync from primary
resyncing from database with DB_UNIQUE_NAME < db unique name>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 04/30/2020 23:11:00
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at 04/30/2020 23:11:00
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-00942: table or view does not exist
This error is related with the TNS connect string when connecting to the standby.
$ rman target / catalog <username>/<password>@<catalog tns> RMAN> resync catalog from db_unique_name MSDB; resyncing from database with DB_UNIQUE_NAME MSDB RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of resync from db_unique_name command on default channel at 04/30/2020 15:29:39 ORA-17629: Cannot connect to the remote database server ORA-17627: ORA-03113: end-of-file on communication channel ORA-17629: Cannot connect to the remote database server
Use the Standby TNS Alias instead of Primary Alias. To solve this error, use the Standby TNS Alias as follows.
$ rman target <username>/<password>@MSDBDG catalog <username>/<password>@<catalog tns>
RMAN> resync catalog from db_unique_name MSDB;
resyncing from database with DB_UNIQUE_NAME MSDB
starting full resync of recovery catalog
full resync complete
Do you want to learn more details about RMAN, then read the following articles.
https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/