"ORACLE" rac-adding and deleting log Group members

[Email protected] rac1>select Group#,member,status from V$logfile order by 2;

group# MEMBER STATUS
---------- --------------------------------------------------------------------------- -----------
1 +data/racdb/onlinelog/group_1.261.942339581

1 +data/racdb/onlinelog/group_1.272.942466389 INVALID

2 +data/racdb/onlinelog/group_2.262.942339581

2 +data/racdb/onlinelog/group_2.271.942466411

3 +data/racdb/onlinelog/group_3.266.942339807

3 +data/racdb/onlinelog/group_3.273.942466441

4 +data/racdb/onlinelog/group_4.267.942339809

4 +data/racdb/onlinelog/group_4.274.942466783

8 rows selected.

[Email protected] rac1>select group#,thread#,members,status,bytes/1024/1024 as size_m from V$log;

group# thread# members STATUS size_m
---------- ------------ ------------  ------------------ ----------
1 1 2 INACTIVE
2 1 2 CUR
3 2 2 INACTIVE
4 2 2 CUR

[Email protected] rac1>alter database drop logfile member ' +data/racdb/onlinelog/group_1.272.942466389 ';

Database altered.

[Email protected] rac1>select group#,thread#,members,status,bytes/1024/1024 as size_m from V$log;

group# thread# members STATUS size_m
---------- ------------- -----------  ------------------ ----------
1 1 1 INACTIVE
2 1 2 currrent
3 2 1 INACTIVE
4 2 2 currrent

[Email protected] rac1>select Group#,member,status from V$logfile order by 2;

group# MEMBER STATUS
---------- --------------------------------------------------------------------------- -----------
1 +data/racdb/onlinelog/group_1.261.942339581

2 +data/racdb/onlinelog/group_2.262.942339581

2 +data/racdb/onlinelog/group_2.271.942466411

3 +data/racdb/onlinelog/group_3.266.942339807

4 +data/racdb/onlinelog/group_4.267.942339809

4 +data/racdb/onlinelog/group_4.274.942466783

6 rows selected.

[Email protected] rac1>alter system switch logfile;

group# thread# members STATUS size_m
---------- ------------- -----------  ------------------ ----------
1 1 1 currrent
2 1 2 INACTIVE
3 2 1 currrent
4 2 2 INACTIVE

[Email protected] rac1>alter database drop logfile member ' +data/racdb/onlinelog/group_2.271.942466411 ';

Database altered.

[Email protected] rac1>alter database drop logfile member ' +data/racdb/onlinelog/group_4.274.942466783 ';

Database altered.

[Email protected] rac1>alter system switch logfile;

group# thread# members STATUS size_m
---------- ------------- -----------  ------------------ ----------
1 1 1 currrent
2 1 1 INACTIVE
3 2 1 currrent
4 2 1 INACTIVE

"ORACLE" rac-adding and deleting log Group members