?
Solved

Database mount ID mismatch

Posted on 2009-12-16
4
Medium Priority
?
4,678 Views
Last Modified: 2012-05-08
There was some kind of hardware problem where the NAS switch failed.  This was resolved, but when the standby was brought up again i'm getting these messages in the alert_log of primary.

Wed Dec 16 19:51:19 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[71]: Assigned to RFS process 19204
RFS[71]: Database mount ID mismatch [0x9d030fd2:0x9d02cab6]
RFS[71]: Not using real application clusters
Wed Dec 16 19:51:19 2009
Errors in file /u01/app/oracle/admin/BB600/udump/bb60_rfs_19204.trc:
ORA-16009: remote archive log destination must be a STANDBY database
Wed Dec 16 19:56:19 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[72]: Assigned to RFS process 19619
RFS[72]: Database mount ID mismatch [0x9d030fd2:0x9d02cab6]
RFS[72]: Not using real application clusters
Wed Dec 16 19:56:19 2009
Errors in file /u01/app/oracle/admin/BB600/udump/bb60_rfs_19619.trc:
ORA-16009: remote archive log destination must be a STANDBY database


What do i need to do to resolve these errors?
~
0
Comment
Question by:xoxomos
  • 3
4 Comments
 
LVL 3

Accepted Solution

by:
logictank earned 1200 total points
ID: 26069444
Looks like you may have remote archiving enabled on the Standby database, disable it using, for example:

alter system set log_archive_dest_3 = ' '
 
Note:  You'll need to determine which 'log_archive_dest_#' location is enabled for remote archiving, the Standby should only be archiving to the local disks.
0
 

Author Comment

by:xoxomos
ID: 26076248
Thanks.  I saw something like that on google and i'm 100% certain that will work.  If that was correct, and i need only change that parameter on standby, that would be much better.  Right now i'm waiting on Oracle.
Seems like years later and they still may be '... stuck on this one'. I should have followed that post.
As I recall, i set the parameter that way for failover capability or whatever so that the standby, acting as primary, could send archives to whatever was acting as standby.
0
 

Author Closing Comment

by:xoxomos
ID: 31667568
Mil gracias :-)
0
 

Author Comment

by:xoxomos
ID: 26076279
So far all Oracle is saying is '.... thank you for sending...please send again'. :-)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question