ORA-01105 ORA-19808 When Start Up RAC Instance

Make sure database parameter values are consistent through all RAC instances.

When tries to start up one instance of the RAC , the following errors occur.

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

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.