ORA-01105 ORA-19808: Database Instance Startup Failed with ORA-01105: mount is incompatible with mounts by other instances

Error Description
For RAC database one instance is running and when I try to start the second instance I am getting following errors
[oracle@node1 script]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 20 12:07:53 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 3305111552 bytes
Fixed Size                  2929744 bytes
Variable Size            3238005680 bytes
Database Buffers           50331648 bytes
Redo Buffers               13844480 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch

Solution Description
See below the value for the db_recovery_file_dest_size is just 10. There is no G/M/K mentioned. That is the reason for the error. There might be chances of mismatch in values on both nodes. To fix this we have to make these values in sync.  

SQL> show parameter db_recovery_file_dest_size          
NAME                           TYPE         VALUE
------------------------------ ------------  ------------------------------
db_recovery_file_dest_size     big integer   10

Do the following commands from the node which is running.
SQL> select name , open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
PRODDB    READ WRITE

Specify the correct value in G/M and use scope=both which will make the changes in the memory of running instance. So you don’t need to bounce the database on both nodes.  
SQL> alter system set db_recovery_file_dest_size=10g scope=both;

System altered.

SQL> show parameter db_recovery_file_dest_size
NAME                           TYPE         VALUE
------------------------------ ------------  ------------------------------
db_recovery_file_dest_size     big integer   10G

Now connect to the database instance which in nomount state(here node1) and open it.
[oracle@node1 script]$ sqlplus / as sysdba

SQL> alter database mount;

Database altered.

SQL> alter database open;


Database altered.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google