oracle扩容redo log

步骤：

1、增加新日志组

2、切换日志，并完成归档alter system switch logfile;

3、删除group 1 2 3 ……

4、增加group 1 2 3 ……

 

实际操作:

--查看在用的redo log有哪些，路径

SQL> select member from v$logfile;  

--新增log组

alter database add logfile group 4('/oradata/ORCL/redo04.log') size 2G;

alter database add logfile group 5('/oradata/ORCL/redo05.log') size 2G;

alter database add logfile group 6('/oradata/ORCL/redo06.log') size 2G;

alter database add logfile group 7('/oradata/ORCL/redo07.log') size 2G;

--切换log（有几组执行几次）

alter system switch logfile;
alter system switch logfile;
alter system switch logfile;

-- 确认原来的redo log已经inactive，清除
select group#,sequence#,archived,status from v$log;

清理：
SQL> alter database drop logfile group 1 
SQL> alter database drop logfile group 2 
SQL> alter database drop logfile group 3