oracle修改日志大小

相关视图

select * from v$log ;
select * from v$logfile ;

操作命令

ALTER DATABASE ADD LOGFILE GROUP 4 ('/opt/oracle/oradata/qybwt/redo04.log') SIZE 200M;

ALTER DATABASE ADD LOGFILE GROUP 5 ('/opt/oracle/oradata/qybwt/redo05.log') SIZE 200M;

ALTER DATABASE ADD LOGFILE GROUP 6 ('/opt/oracle/oradata/qybwt/redo06.log') SIZE 200M;

alter system switch logfile;
/
/

待要删除的日志组状态为  INACTIVE ，执行日志组卸载
alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;

系统中删除对应日志文件
cd /opt/oracle/oradata/qybwt/ ; rm -f redo01.log redo02.log redo03.log

增加日志组

ALTER DATABASE ADD LOGFILE GROUP 1 ('/opt/oracle/oradata/qybwt/redo01.log') SIZE 200M;

ALTER DATABASE ADD LOGFILE GROUP 2 ('/opt/oracle/oradata/qybwt/redo02.log') SIZE 200M;

ALTER DATABASE ADD LOGFILE GROUP 3 ('/opt/oracle/oradata/qybwt/redo03.log') SIZE 200M;