---------- --------------- ------------------------------------------------
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