重做oracle日志扩容

查看当前日志组的状态

select group#,members,bytes/1024/1024,status from v$log;

查看在线日志组的位置

select MEMBER from v$logfile;

新增group 4-6日志组，大小为512M

alter database add logfile group 4 ('/opt/app/oracle/oradata/orcl/redo04.log') size 512M;
alter database add logfile group 5 ('/opt/app/oracle/oradata/orcl/redo05.log') size 512M;
alter database add logfile group 6 ('/opt/app/oracle/oradata/orcl/redo06.log') size 512M;

切换当前日志到新的日志组

alter system switch logfile;   
alter system switch logfile;

inactive在线日志组

alter system checkpoint;

删除旧的日志组

alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;

查看修改后的日志组的状态信息：

select group#,members,bytes/1024/1024,status from v$log;