Database mount ID mismatch ORA-16009: invalid redo transport destination
(Doc ID 1450132.1)
Last updated on MAY 08, 2023
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Primary with one or more physical or logical standby databases
All the databases involved in data guard configuration are correctly configured
with log_archive_dest_n and log_archive_config parameters
There are no errors in the available standby database alertlogs when the below messages pop up in Primary alertlog
---- Primary alertlog ----
Thu Apr 12 10:27:47 2012
RFS[1]: Assigned to RFS process 23666
RFS[1]: Database mount ID mismatch [0x5d0945b9:0x5ce6c765] (1560888761:1558628197)
RFS[1]: Not using real application clusters
Thu Apr 12 10:27:48 2012
RFS[2]: Assigned to RFS process 23668
RFS[2]: Database mount ID mismatch [0x5d0945b9:0x5ce6c765] (1560888761:1558628197)
RFS[2]: Not using real application clusters
Thu Apr 12 10:27:49 2012
Thu Apr 12 18:54:39 2012
ALTER SYSTEM SET log_archive_trace=8191 SCOPE=BOTH; <<<<-------- Enabling trace leaves ORA-16009
Thu Apr 12 18:54:46 2012
Thu Apr 12 19:14:26 2012
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[555]: Assigned to RFS process 17392
RFS[555]: Database mount ID mismatch [0x5d0945b9:0x5ce6c765] (1560888761:1558628197)
RFS[555]: Not using real application clusters
Errors in file /orahome/app/oracle/diag/rdbms/<primary db_unique_name>/<SID>/trace/<SID>_rfs_17392.trc:
ORA-16009: invalid redo transport destination
Thu Apr 12 19:15:27 2012
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 23666
RFS[1]: Database mount ID mismatch [0x5d0945b9:0x5ce6c765] (1560888761:1558628197)
RFS[1]: Not using real application clusters
Thu Apr 12 10:27:48 2012
RFS[2]: Assigned to RFS process 23668
RFS[2]: Database mount ID mismatch [0x5d0945b9:0x5ce6c765] (1560888761:1558628197)
RFS[2]: Not using real application clusters
Thu Apr 12 10:27:49 2012
Thu Apr 12 18:54:39 2012
ALTER SYSTEM SET log_archive_trace=8191 SCOPE=BOTH; <<<<-------- Enabling trace leaves ORA-16009
Thu Apr 12 18:54:46 2012
Thu Apr 12 19:14:26 2012
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[555]: Assigned to RFS process 17392
RFS[555]: Database mount ID mismatch [0x5d0945b9:0x5ce6c765] (1560888761:1558628197)
RFS[555]: Not using real application clusters
Errors in file /orahome/app/oracle/diag/rdbms/<primary db_unique_name>/<SID>/trace/<SID>_rfs_17392.trc:
ORA-16009: invalid redo transport destination
Thu Apr 12 19:15:27 2012
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
-------- <SID>_rfs_17392.trc ----------
krsr_rfs_nfy: Startup received from ARCH pid 6366 <<< --------------------- This is the process of some read/write open database connected to this primary
krsd_init_sdips: called from [krsr.c:3189] with function 2
krso_proc_add: Detected dead process 16969; subsuming V$MANAGED_STANDBY slot
krso_proc_add: Using V$MANAGED_STANDBY slot 0xca8a68420
krsr_rfs_nfy: Identified 3 RFS client(s)
*** 2012-04-12 19:14:26.262 879 krsr.c
RFS message number 427 (RFSATTCH state:1 mode:1 flag:0x800002) start
*** 2012-04-12 19:14:26.269 1799 krsa.c
Completed CFTXN 0x7fff2299ae50 (last PID:17392) [krsr.c:4466] IX-
Resignalling exception 16009 [krsr.c:4469]
ORA-16009: invalid redo transport destination
*** 2012-04-12 19:14:26.370 883 krsv.c
krsv_dpga: Freeing krsrrx
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 |