日志组增加成员

最新推荐文章于 2023-02-07 17:57:08 发布

Joycesjr

最新推荐文章于 2023-02-07 17:57:08 发布

阅读量627

点赞数

本文链接：https://blog.csdn.net/ljsjr/article/details/38453625

版权

SQL>  select group#,sequence#,bytes,members,status from v$log;

    GROUP#  SEQUENCE#	   BYTES    MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
	 1	   34  134217728	  2 CURRENT
	 2	   32  134217728	  2 INACTIVE
	 3	    4  134217728	  <span style="color:#ff0000;">1</span> INACTIVE
	 4	    5  134217728	  <span style="color:#ff0000;">1 </span>CURRENT
	 5	   33  134217728	  2 INACTIVE
	 6	    3  134217728	 <span style="color:#ff0000;"> 1</span> INACTIVE

6 rows selected.

节点一上2个成员，节点2个1个成员，添加成员。

SQL> alter database add logfile member '+DATA' to group 3;

Database altered.

SQL> alter database add logfile member '+DATA' to group 4;

Database altered.

SQL> alter database add logfile member '+DATA' to group 6;

Database altered.

SQL> select group#,sequence#,bytes,members,status from v$log;                                                             
    GROUP#  SEQUENCE#	   BYTES    MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
	 1	   34  134217728	  2 CURRENT
	 2	   32  134217728	  2 INACTIVE
	 3	    4  134217728	  2 INACTIVE
	 4	    5  134217728	  2 CURRENT
	 5	   33  134217728	  2 INACTIVE
	 6	    3  134217728	  2 INACTIVE

6 rows selected.

SQL>