RAC环境ORA-01105、ORA-01677错误
Aug142015
RAC环境在修改参数后,重启一个节点遇到ORA-01105和ORA-01677错误。数据库版本11.2.0.4。具体操作如下,以下操作在节点1。
SQL> alter system set db_file_name_convert='+DATA/erpdb/datafile/','/u01/app/oracle/oradata/erpdb/','+DATA/erpdb/tempfile/','/u01/app/oracle/oradata/erpdb/' scope=spfile sid='*'; System altered. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 7.0283E+10 bytes Fixed Size 2260368 bytes Variable Size 1.5032E+10 bytes Database Buffers 5.5029E+10 bytes Redo Buffers 219426816 bytes ORA-01105: mount is incompatible with mounts by other instances ORA-01677: standby file name convert parameters differ from other instance
这是因为节点1重启后,新修改的参数已经生效,而节点2此时没有重启,使用的还是旧的参数,两边不一致。关闭或重启节点2,节点1可以成功启动。
[oracle@SL010M6-DB-ERPDB2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 11 10:26:59 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 7.0283E+10 bytes Fixed Size 2260368 bytes Variable Size 1.5301E+10 bytes Database Buffers 5.4761E+10 bytes Redo Buffers 219426816 bytes Database mounted. Database opened.
节点2关闭或重启后,节点1可正常启动。
SQL> alter database mount; Database altered. SQL> alter database open; Database altered.