在线扩大redo日志大小

#查看日志组状态
SQL> select group#,members,bytes/1024/1024,status from v$log;
#查看当前日志组成员
SQL> select member from v$logfile;
#创建2个新的过渡日志组
SQL> alter database add logfile group 4('/data/u01/app/oracle/oradata/orcly/redo04.log') size 500M;
SQL> alter database add logfile group 5('/data/u01/app/oracle/oradata/orcly/redo05.log') size 500M;
#切换日志并做检查点，确定123组日志处于inactive状态
SQL> alter system switch logfile;
SQL> alter system checkpoint;
SQL> select group#,members,bytes/1024/1024,status from v$log;


    GROUP#    MEMBERS BYTES/1024/1024 STATUS
---------- ---------- --------------- ----------------
         1          1              50 INACTIVE
         2          1              50 INACTIVE
         3          1              50 INACTIVE
         4          1             500 ACTIVE
         5          1             500 CURRENT
#数据库删除123组日志
SQL> alter database drop logfile group 1
SQL> alter database drop logfile group 2
SQL> alter database drop logfile group 3
#OS删除文件
$rm redo01.log redo02.log redo03.log
#数据库添加123组日志
SQL> alter database add logfile group 1('/data/u01/app/oracle/oradata/orcly/redo01.log') size 2048M;
SQL> alter database add logfile group 2('/data/u01/app/oracle/oradata/orcly/redo02.log') size 2048M;
SQL> alter database add logfile group 3('/data/u01/app/oracle/oradata/orcly/redo03.log') size 2048M;


同上删除4、5组日志即可