创建过渡redo
alter database add logfile group 4 '/home/oracle/app/oracle/oradata/soc/redo04.log' size 500M;
alter database add logfile group 5 '/home/oracle/app/oracle/oradata/soc/redo05.log' size 500M;
alter database add logfile group 6 '/home/oracle/app/oracle/oradata/soc/redo06.log' size 500M;
alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;
通过
alter database add logfile group 4 '/home/oracle/app/oracle/oradata/soc/redo04.log' size 500M;
alter database add logfile group 5 '/home/oracle/app/oracle/oradata/soc/redo05.log' size 500M;
alter database add logfile group 6 '/home/oracle/app/oracle/oradata/soc/redo06.log' size 500M;
切换到过渡redo
alter system switch logfile;
查看是否切换到过渡的redo
select group#,bytes/1024/1024,status from v$log;
alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;
通过