同事搭一个测试RAC说节点2发现idle了，报ORA-00304

---------- --------------- ------------------------------------------------
1 1 testrac1
SQL> select GROUP#,THREAD# from v$log;

GROUP# THREAD#
---------- ----------
1 1
2 1
3 1

SQL> select MEMBER from v$logfile;

MEMBER
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATADG/testrac/onlinelog/group_1.257.995827307
+DATADG/testrac/onlinelog/group_2.258.995827307
+DATADG/testrac/onlinelog/group_3.259.995827309

SQL> alter database add logfile thread 2 ('+datadg','+datadg') size 100m;

Database altered.

SQL> alter database add logfile thread 2 ('+datadg','+datadg') size 100m;

Database altered.

SQL> alter database add logfile thread 2 ('+datadg','+datadg') size 100m;

Database altered.

SQL> select GROUP#,THREAD# from v$log;

GROUP# THREAD#
---------- ----------
1 1
2 1
3 1
4 2
5 2
6 2

6 rows selected.

SQL> alter database enable thread 2;

Database altered.

难道安装时候没勾选节点2，他说从节点1拷贝了一个参数文件，下面的3个参数也没改。。。能启动才怪
#testrac2.instance_number=1
testrac2.instance_number=2
*.open_cursors=300
*.pga_aggregate_target=1649410048
*.processes=150
*.remote_listener='racscanip:1521'
*.remote_login_passwordfile='exclusive'
*.sga_target=4949278720
#testrac2.thread=1
testrac2.thread=2
#testrac2.undo_tablespace='UNDOTBS1'
testrac2.undo_tablespace='UNDOTBS2'

[oracle@testrac2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 16 19:34:42 2019

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup pfile='/u01/app/oracle/11204/dbs/inittestrac2.ora';
ORACLE instance started.

Total System Global Area 4927172608 bytes
Fixed Size 2261648 bytes
Variable Size 1090522480 bytes
Database Buffers 3825205248 bytes
Redo Buffers 9183232 bytes
Database mounted.
Database opened.
SQL> select status from v$instance;

STATUS
------------------------------------
OPEN

SQL> select INST_ID ,INSTANCE_NUMBER ,INSTANCE_NAME from gv$instance;

INST_ID INSTANCE_NUMBER INSTANCE_NAME
---------- --------------- ------------------------------------------------
2 2 testrac2
1 1 testrac1

SQL> 
可以了正常了。。。

作者：ritchy

原文链接：https://www.cnblogs.com/ritchy/p/10279060.html