11g Rac 添加日志组

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

    GROUP#    THREAD#	 MEMBERS STATUS
---------- ---------- ---------- ----------------
	 1	    2	       1 CURRENT
	 2	    2	       1 INACTIVE
	 5	    1	       1 CURRENT
	 6	    1	       1 INACTIVE
	 7	    1	       1 INACTIVE
	 8	    2	       1 INACTIVE


SQL> select  GROUP# , status,member from v$logfile;

    GROUP# STATUS  MEMBER
---------- ------- ------------------------------
	 1	   +DATA/devrac/onlinelog/redo_2_
		   01.log

	 2	   +DATA/devrac/onlinelog/redo_2_
		   02.log

	 5	   +DATA/devrac/onlinelog/redo_1_
		   01.log

	 6	   +DATA/devrac/onlinelog/redo_1_
		   02.log

    GROUP# STATUS  MEMBER
---------- ------- ------------------------------

	 7	   +DATA/devrac/onlinelog/redo_1_
		   03.log

	 8	   +DATA/devrac/onlinelog/redo_2_
		   03.log


6 rows selected.

添加日志组：
SQL> alter database add logfile '+DATA/devrac/onlinelog/redo_1_04.log' size 500M;



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

    GROUP#    THREAD#	 MEMBERS STATUS
---------- ---------- ---------- ----------------
	 1	    2	       1 CURRENT
	 2	    2	       1 INACTIVE
	 3	    1	       1 UNUSED
	 5	    1	       1 CURRENT
	 6	    1	       1 INACTIVE
	 7	    1	       1 INACTIVE
	 8	    2	       1 INACTIVE

7 rows selected.



SQL> select  GROUP# , status,member from v$logfile;

    GROUP# STATUS  MEMBER
---------- ------- ------------------------------
	 1	   +DATA/devrac/onlinelog/redo_2_
		   01.log

	 2	   +DATA/devrac/onlinelog/redo_2_
		   02.log

	 5	   +DATA/devrac/onlinelog/redo_1_
		   01.log

	 6	   +DATA/devrac/onlinelog/redo_1_
		   02.log

    GROUP# STATUS  MEMBER
---------- ------- ------------------------------

	 7	   +DATA/devrac/onlinelog/redo_1_
		   03.log

	 8	   +DATA/devrac/onlinelog/redo_2_
		   03.log

	 3	   +DATA/devrac/onlinelog/redo_1_
		   04.log


7 rows selected.

多出了3号日志组: 日志文件为+DATA/devrac/onlinelog/redo_1_01.log


给第2个节点加日志组:
SQL> alter database add logfile thread 2 '+DATA/devrac/onlinelog/redo_2_04.log' size 500M;

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

    GROUP#    THREAD#	 MEMBERS STATUS
---------- ---------- ---------- ----------------
	 1	    2	       1 CURRENT
	 2	    2	       1 INACTIVE
	 3	    1	       1 UNUSED
	 4	    2	       1 UNUSED
	 5	    1	       1 CURRENT
	 6	    1	       1 INACTIVE
	 7	    1	       1 INACTIVE
	 8	    2	       1 INACTIVE

8 rows selected.

SQL> select  GROUP# , status,member from v$logfile;

    GROUP# STATUS  MEMBER
---------- ------- ------------------------------
	 1	   +DATA/devrac/onlinelog/redo_2_
		   01.log

	 2	   +DATA/devrac/onlinelog/redo_2_
		   02.log

	 5	   +DATA/devrac/onlinelog/redo_1_
		   01.log

	 6	   +DATA/devrac/onlinelog/redo_1_
		   02.log

    GROUP# STATUS  MEMBER
---------- ------- ------------------------------

	 7	   +DATA/devrac/onlinelog/redo_1_
		   03.log

	 8	   +DATA/devrac/onlinelog/redo_2_
		   03.log

	 3	   +DATA/devrac/onlinelog/redo_1_
		   04.log

	 4	   +DATA/devrac/onlinelog/redo_2_

    GROUP# STATUS  MEMBER
---------- ------- ------------------------------
		   04.log


8 rows selected.