问题描述:rac环境节点1修改参数后,节点2启动出现ORA-01105、ORA-01677告警,如下所示:标签:01105,name,heal,healdg,file,SQL,data,节点,ORA From: https://blog.51cto.com/u_12991611/5897256
环境:oracle rac(双节点) 11.2.0.4 此为双节点rac dg环境
1、问题重现
--节点2启动报错
SQL> startup
ORACLE instance started.
Total System Global Area 855982080 bytes
Fixed Size 2258040 bytes
Variable Size 352324488 bytes
Database Buffers 494927872 bytes
Redo Buffers 6471680 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-01677: standby file name convert parameters differ from other instance
2、问题排查
--查节点1参数
SQL> show parameter log_file_name_convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_file_name_convert string +data/healdg/tempfile/, +data/
heal/tempfile/, +data/healdg/o
nlinelog/, +data/heal/onlinelo
g/, +data/healdg/controlfile/,
+data/heal/controlfile/
SQL> show parameter db_file_name_convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string +data/healdg/datafile/, +data/
heal/datafile/, +data/healdg/t
empfile/, +data/heal/tempfile/
SQL> show parameter fal
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string heal
fal_server string healdg
--查节点2参数
SQL> show parameter log_file_name_convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_file_name_convert string
SQL> show parameter db_file_name_convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
SQL> show parameter fal
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string
fal_server string
3、解决过程
--节点2执行
SQL> create pfile='/home/oracle/pfile.ora' from spfile;
File created.
[oracle@hisdb2 ~]$ vi pfile.ora
添加如下内容:
*.db_file_name_convert='+data/healdg/datafile/','+data/heal/datafile/','+data/healdg/tempfile/','+data/heal/tempfile/'
*.log_file_name_convert='+data/healdg/tempfile/','+data/heal/tempfile/','+data/healdg/onlinelog/','+data/heal/onlinelog/','+data/healdg/controlfile/','+data/heal/controlfile/'
*.fal_server='healdg'
*.fal_client='heal'
[oracle@hisdb2 ~]$ ps -ef|grep ora_smon
oracle 59575 1 0 09:56 ? 00:00:00 ora_smon_heal2
oracle 63859 3944 0 10:51 pts/0 00:00:00 grep --color=auto ora_smon
[oracle@hisdb2 ~]$ kill -9 59575
[oracle@hisdb2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Nov 29 10:52:17 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/home/oracle/pfile.ora';
ORACLE instance started.
Total System Global Area 855982080 bytes
Fixed Size 2258040 bytes
Variable Size 352324488 bytes
Database Buffers 494927872 bytes
Redo Buffers 6471680 bytes
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch
--此时因其它参数不同造成异常,查节点1参数
SQL> show parameter db_recov
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +fra
db_recovery_file_dest_size big integer 50G
--节点2修改
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
[oracle@hisdb2 ~]$ vi pfile.ora
添加如下内容.
*.db_recovery_file_dest='+fra'
*.db_recovery_file_dest_size=50g
[oracle@hisdb2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Nov 29 11:05:47 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/home/oracle/pfile.ora';
ORACLE instance started.
Total System Global Area 855982080 bytes
Fixed Size 2258040 bytes
Variable Size 352324488 bytes
Database Buffers 494927872 bytes
Redo Buffers 6471680 bytes
SQL> alter database mount;
Database altered.
SQL> alter database open;
Database altered.
SQL> create spfile from pfile='/home/oracle/pfile.ora';
File created.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 855982080 bytes
Fixed Size 2258040 bytes
Variable Size 352324488 bytes
Database Buffers 494927872 bytes
Redo Buffers 6471680 bytes
Database mounted.
Database opened.
结论:节点2成功启动数据库.