"ORACLE" rac-adding and deleting log groups

[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 current
2 1 1 inact
3 2 1 INACTIVE
4 2 1 current

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

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

2 +data/racdb/onlinelog/group_2.262.942339581

3 +data/racdb/onlinelog/group_3.266.942339807

4 +data/racdb/onlinelog/group_4.267.942339809

[Email protected] rac1>alter database add logfile thread 1 Group 5 ' +data ' size 50M;

Database altered.

[Email protected] rac1>alter database add logfile Thread 2 Group 6 ' +data ' size 50M;

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 current
2 1 1 INACTIVE
3 2 1 INACTIVE
4 2 1 current
5 1 1 UNUSED
6 2 1 UNUSED

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

group# MEMBER

--------------  ----------------------------------------------------------------------------------------
1 +data/racdb/onlinelog/group_1.261.942339581

2 +data/racdb/onlinelog/group_2.262.942339581

3 +data/racdb/onlinelog/group_3.266.942339807

4 +data/racdb/onlinelog/group_4.267.942339809

5 +data/racdb/onlinelog/group_5.271.942452713

6 +data/racdb/onlinelog/group_6.272.942452765

6 rows selected.

Delete a log group

Note: If the status of the log group that you want to delete is current or active, make it inactive

alter system switch logfile;

Alter system checkpoint;

[Email protected] rac1>alter database drop logfile Group 5;

Database altered.

[Email protected] rac1>alter database drop logfile Group 6;

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 current
2 1 1 INACTIVE
3 2 1 INACTIVE
4 2 1 current

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

group# MEMBER

--------------  ----------------------------------------------------------------------------------------
1 +data/racdb/onlinelog/group_1.261.942339581

2 +data/racdb/onlinelog/group_2.262.942339581

3 +data/racdb/onlinelog/group_3.266.942339807

4 +data/racdb/onlinelog/group_4.267.942339809

"ORACLE" rac-adding and deleting log groups