在线更改redo路径和大小

在线更改redo路径和大小

1. 查看状态是否是active
   select group#,status from v$log;
   select * from v$logfile;

2. 创建新的redo文件
   alter database add logfile group 4 ‘E:\ORACLE\ORADATA\ORCL\REDO004.LOG’ size 50m;
   alter database add logfile group 5 ‘E:\ORACLE\ORADATA\ORCL\REDO005.LOG’ size 50m;
   alter database add logfile group 6 ‘E:\ORACLE\ORADATA\ORCL\REDO006.LOG’ size 50m;

3. 切换日志，当状态变成inactive才可以删除
   alter system switch logfile;
   alter system checkpoint;
   状态变成inactive

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

alter database add logfile group 1 ‘E:\ORACLE\ORADATA\ORCL\REDO001.LOG’ size 50m;
alter database add logfile group 2 ‘E:\ORACLE\ORADATA\ORCL\REDO002.LOG’ size 50m;
alter database add logfile group 3 ‘E:\ORACLE\ORADATA\ORCL\REDO003.LOG’ size 50m;

4. 删除新增的redo文件
   alter database drop logfile group 4;
   alter database drop logfile group 5;
   alter database drop logfile group 6;
   alter system switch logfile;
   alter system checkpoint;