当前位置: 首页 > Oracle, oracle 10g, oracle 11g > 正文

RAC环境ORA-01105、ORA-01677错误

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.

 

本文固定链接: https://www.dbdream.com.cn/2015/08/rac%e7%8e%af%e5%a2%83ora-01105%e3%80%81ora-01677%e9%94%99%e8%af%af/ | 信春哥,系统稳,闭眼上线不回滚!

该日志由 dbdream 于2015年08月14日发表在 Oracle, oracle 10g, oracle 11g 分类下, 你可以发表评论,并在保留原文地址及作者的情况下引用到你的网站或博客。
原创文章转载请注明: RAC环境ORA-01105、ORA-01677错误 | 信春哥,系统稳,闭眼上线不回滚!
关键字: , , , ,

RAC环境ORA-01105、ORA-01677错误:等您坐沙发呢!

发表评论

快捷键:Ctrl+Enter