ORA-01105: mount is incompatible with mounts by other instances ORA-19808: recovery destination parameter mismatch

When tries to start up one instance of the RAC , got below errors.

.....
....
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch
...

Check flash recovery parameters on other node:

SQL> show parameter recovery

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +FRA
db_recovery_file_dest_size big integer 50G

Check  flash recovery parameters in spfile. it is 100GB

*.db_recovery_file_dest_size = 107374182400  <-- 100GB

On other node, change parameter db_recovery_file_dest_size  =100G, which is consistent with the one in spfile.

SQL> alter system set db_recovery_file_dest_size=100g scope=both;

System altered

The start up the instance successfully

$srvctl start instance  -d DBNAME -i INSTANCENAME

or 

SQL>startup
Advertisements
This entry was posted in Configuration, GI and RAC, ORA- ERRORS and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s