重做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;