ORA-20079: full resync from primary database is not done RMAN-06613

Problem:

在DR備份時,發生 ORA-20079: full resync from primary database is not done 的錯誤訊息,

ORA-20079: full resync from primary database is not done

starting resync from primary
resyncing from database with DB_UNIQUE_NAME db
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 03/30/2022 10:37:46
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at 03/30/2022 10:37:46
RMAN-10032: unhandled exception during execution of job step 1: 
ORA-06512: at "KRMICD", line 719
ORA-06512: at line 1962
RMAN-06613: Connect identifier for DB_UNIQUE_NAME dbstby not configured

手動執行show all;也會有問題

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 03/30/2022 10:37:46
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at 03/30/2022 10:38:30
RMAN-10032: unhandled exception during execution of job step 1: 
ORA-06512: at "KRMICD", line 719
ORA-06512: at line 1962
RMAN-06613: Connect identifier for DB_UNIQUE_NAME dbstby not configured

Solution:

unregister and register standby database then config identifier for DB_UNIQUE_NAME

Step 1. unregister database & register database

how to unregister and register database

Step 2. config identifier for DB_UNIQUE_NAME

$ rman target /
RMAN> CONFIGURE DB_UNIQUE_NAME '<db unique name primary>'   CONNECT IDENTIFIER  '<tns to primary>' ;
RMAN> CONFIGURE DB_UNIQUE_NAME '<db unique name standby>'   CONNECT IDENTIFIER  '<tns to standby>' ;

參考來源:

After New Files are Added to primary, RMAN Fails at Standby with ORA-20079: Full Resync From Primary Database Is Not Done (Doc ID 1604302.1)

張貼留言

0 留言