Database mount ID mismatch ORA-16009: invalid redo transport destination (Doc ID 1450132.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 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/qd_f4wp1/f4wp1/trace/f4wp1_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





-------- f4wp1_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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms