select * from v$log;
alter system switch logfile;
alter system checkpoint;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 4; -- 如果无法切换
--当日志组状态为inactive就可以删除了
alter database drop logfile group 1;
ALTER DATABASE ADD LOGFILE GROUP 1('/data/GZBUS/redo001.log') SIZE 2G;
alter database drop logfile group 2;
ALTER DATABASE ADD LOGFILE GROUP 2('/data/GZBUS/redo002.log') SIZE 2G;
alter database drop logfile group 3;
ALTER DATABASE ADD LOGFILE GROUP 3('/data/GZBUS/redo03.log') SIZE 2G;