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 留言