Oracle 11G R2 RAC环境
今天启动其中一个节点报错,提示如下:
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch
解决方法:
根据ORA-19808提示,应该为调整Oracle某个参数导致,两个节点的参数不一致。
查看两个节点参数:
Node1==============>>
SQL> show parameter db_recov
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +ASM_FRA
db_recovery_file_dest_size big integer 3882M
Node2==============>>
SQL> show parameter db_recove
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +DATA
db_recovery_file_dest_size big integer 5G
<<<<<<<=============================
两个节点参数不一致..因此修改Node1参数与Node2保持一致即可解决问题:
1、以mount模式启动
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+DATA' SCOPE=spfile;
alter system set db_recovery_file_dest_size=5g scope=spfile;