Oracle11g redo log 创建、添加、删除（重做日志组，重做日志文件）

select group#, sequence#, members, bytes, status, archived from v$log;
select group#, status, type, member from v$logfile;
添加redo组
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo04a.log','/u01/app/oracle/oradata/dagl/redo04b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo05a.log','/u01/app/oracle/oradata/dagl/redo05b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo06a.log','/u01/app/oracle/oradata/dagl/redo06b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo07a.log','/u01/app/oracle/oradata/dagl/redo07b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo08a.log','/u01/app/oracle/oradata/dagl/redo08b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo09a.log','/u01/app/oracle/oradata/dagl/redo09b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo01a.log','/u01/app/oracle/oradata/dagl/redo01b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo02a.log','/u01/app/oracle/oradata/dagl/redo02b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo03a.log','/u01/app/oracle/oradata/dagl/redo03b.log') size 500M;

alter database add logfile member '/u01/app/oracle/oradata/dagl/redo04b.log' to group 4;

删除redo logfile
alter database drop logfile member'/u01/app/oracle/oradata/orcl/redo09b.log';
删除redo log
alter database drop logfile group 2;