1 /home/oracle/app/oracle/oradata/orcl/redo01.log 50 INACTIVE YES
4 /home/oracle/app/oracle/oradata/orcl/redo04_01.log 100 INACTIVE YES
4 /home/oracle/app/oracle/oradata/orcl/redo04_02.log 100 INACTIVE YES
4 /home/oracle/app/oracle/oradata/orcl/redo04_04.log 100 INACTIVE YES
SQL> alter database drop logfile member '/home/oracle/app/oracle/oradata/orcl/redo04_01.log';
Database altered.
[oracle@localhost orcl]$ ls -ls|grep redo
51260 -rw-r----- 1 oracle oinstall 52429312 12-10 14:16 redo01.log
51260 -rw-r----- 1 oracle oinstall 52429312 12-10 14:19 redo02.log
51260 -rw-r----- 1 oracle oinstall 52429312 12-10 14:11 redo03.log
102508 -rw-r----- 1 oracle oinstall 104858112 12-10 14:16 redo04_01.log
102508 -rw-r----- 1 oracle oinstall 104858112 12-10 14:16 redo04_02.log
102508 -rw-r----- 1 oracle oinstall 104858112 12-10 13:29 redo04_03.log
102508 -rw-r----- 1 oracle oinstall 104858112 12-10 14:16 redo04_04.log
需要手动删除物理文件哦！
rm -rf /home/oracle/app/oracle/oradata/orcl/redo04_01.log
6.删除重做日志组
一个实例必须要两组重做日志，如果重做日志组只有两组，不能被删除
删除重做日志组，需要手动删除物理文件（非OMF）
重做日志组内有重做日志文件处于current或者active状态，不能删除重做日志组
如果重做日志组内重做日志文件有null状态和inavtive状态并存，只能删除重做日志文件状态是inactive文件
语法：
alter database drop logfile group 组序号
重做日志组内有重做日志文件处于current或者active状态，不能删除重做日志组
SQL> select a.group#,a.member,b.bytes/1024/1024 "M", b.status,b.archived
from v$logfile a,v$log b
where a.group#=b.group#;
GROUP# MEMBER M STATUS ARC
---------- -------------------------------------------------- ---------- ---------------- ---
3 /home/oracle/app/oracle/oradata/orcl/redo03.log 50 INACTIVE YES
2 /home/oracle/app/oracle/oradata/orcl/redo02.log 50 CURRENT NO
1 /home/oracle/app/oracle/oradata/orcl/redo01.log 50 INACTIVE YES
4 /home/oracle/app/oracle/oradata/orcl/redo04_02.log 100 INACTIVE YES
4 /home/oracle/app/oracle/oradata/orcl/redo04_04.log 100 INACTIVE YES
SQL> alter database drop logfile group 2;
alter database drop logfile group 2
*
ERROR at line 1:
ORA-01623: log 2 is current log for instance orcl (thread 1) - cannot drop
ORA-00312: online log 2 thread 1: '/home/oracle/app/oracle/oradata/orcl/redo02.log'
删除重做日志组，需要手动删除物理文件（非OMF）
SQL> select a.group#,a.member,b.bytes/1024/1024 "M", b.status,b.archived
from v$logfile a,v$log b
where a.group#=b.group#;
GROUP# MEMBER M STATUS ARC
---------- -------------------------------------------------- ---------- ---------------- ---
3 /home/oracle/app/oracle/oradata/orcl/redo03.log 50 INACTIVE YES
2 /home/oracle/app/oracle/oradata/orcl/redo02.log 50 CURRENT NO
1 /home/oracle/app/oracle/oradata/orcl/redo01.log 50 INACTIVE YES
4 /home/oracle/app/oracle/oradata/orcl/redo04_02.log 100 INACTIVE YES
4 /home/oracle/app/oracle/oradata/orcl/redo04_04.log 100 INACTIVE YES
SQL> alter database drop logfile group 4 ;
Database altered.
需要手动删除物理文件哦
[oracle@localhost orcl]$ ls -ls|grep redo
51260 -rw-r----- 1 oracle oinstall 52429312 12-10 14:16 redo01.log
51260 -rw-r----- 1 oracle oinstall 52429312 12-10 14:32 redo02.log
51260 -rw-r----- 1 oracle oinstall 52429312 12-10 14:11 redo03.log
102508 -rw-r----- 1 oracle oinstall 104858112 12-10 14:16 redo04_02.log
102508 -rw-r----- 1 oracle oinstall 104858112 12-10 14:16 redo04_04.log
一个实例必须要两组重做日志
SQL> select a.group#,a.member,b.bytes/1024