修改REDO LOG大小

最新推荐文章于 2026-01-01 22:38:21 发布

转载最新推荐文章于 2026-01-01 22:38:21 发布 · 58 阅读

文章标签：

#数据库

本文介绍在单机与Oracle RAC环境中调整Redo Log文件大小的方法，包括添加新的Redo Log组及删除旧的Redo Log组，并提供具体的SQL指令示例。

单机需要更改redo log大小，如何加入：

ALTER DATABASE ADD LOGFILE GROUP 4 ('/u01/product/mxdell/redo04a.log')   SIZE 100m;
ALTER DATABASE ADD LOGFILE GROUP 5 ('/u01/product/mxdell/redo05a.log')   SIZE 100m;
ALTER DATABASE ADD LOGFILE GROUP 6 ('/u01/product/mxdell/redo06a.log')   SIZE 100m;
ALTER DATABASE ADD LOGFILE GROUP 7 ('/u01/product/mxdell/redo07a.log')   SIZE 100m;
ALTER DATABASE ADD LOGFILE GROUP 8 ('/u01/product/mxdell/redo08a.log')   SIZE 100m;
ALTER DATABASE ADD LOGFILE GROUP 9 ('/u01/product/mxdell/redo09a.log')   SIZE 100m;

ALTER system switch logfile;
ALTER system switch logfile;
ALTER system switch logfile;
ALTER system switch logfile;

ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE DROP LOGFILE GROUP 2;
ALTER DATABASE DROP LOGFILE GROUP 3;

Oracle RAC系统需要更改redo log大小，需要区分不同节点thread ，比如更改节点2的redo log大小：

SQL> alter database add logfile thread 2
     group 4   (‘/oradata1/rac/redo04.log’) size 102400k ,
     group 5   (‘/oradata1/rac/redo05.log’) size 102400k ,
     group 6   (‘/oradata1/rac/redo06.log’) size 102400k ;

SQL>alter database open ;

SQL>alter database enable public thread 2 ;

ALTER system switch logfile;
ALTER system switch logfile;
ALTER system switch logfile;
ALTER system switch logfile;

ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE DROP LOGFILE GROUP 2;
ALTER DATABASE DROP LOGFILE GROUP 3;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-620192/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-620192/