如果日志频繁切换，就需要增加日志文件的大小

SYS@hzh >select GROUP#,STATUS,MEMBER from v$logfile;
GROUP# STATUS MEMBER
---------- ------- --------------------------------------------------
3 STALE /u01/app/oracle/oradata/hzh/redo03.log
2 STALE /u01/app/oracle/oradata/hzh/redo02.log
1 /u01/app/oracle/oradata/hzh/redo01.log
SYS@hzh >select GROUP#,MEMBERS,STATUS,ARCHIVED,BYTES/1024/1024||'M' bt from v$log;
GROUP# MEMBERS STATUS ARC BT
---------- ---------- ---------------- --- ----------
1 1 CURRENT NO 50M
2 1 INACTIVE YES 50M
3 1 INACTIVE YES 50M
SYS@hzh >alter database add logfile group 4 ('/u01/app/oracle/oradata/hzh/redo04.log','/u01/app/oracle/oradata/hzh/redo04b.log') size 200M;
SYS@hzh >select GROUP#,MEMBERS,STATUS,ARCHIVED,BYTES/1024/1024||'M' bt from v$log;
GROUP# MEMBERS STATUS ARC BT
---------- ---------- ---------------- --- ----------
1 1 CURRENT NO 50M
2 1 INACTIVE YES 50M
3 1 INACTIVE YES 50M
4 2 UNUSED YES 200M
SYS@hzh >alter database drop logfile group 2;
Database altered.
SYS@hzh >alter database drop logfile group 3;
Database altered.
SYS@hzh >alter system switch logfile;
System altered.
SYS@hzh >select GROUP#,MEMBERS,STATUS,ARCHIVED,BYTES/1024/1024||'M' bt from v$log;
GROUP# MEMBERS STATUS ARC BT
---------- ---------- ---------------- --- ----------
1 1 ACTIVE YES 50M
4 2 CURRENT NO 200M
[oracle@hong ~]$ cd /u01/app/oracle/oradata/hzh/
[oracle@hong hzh]$ rm redo02* redo03*
SYS@hzh >alter database add logfile group 2 ('/u01/app/oracle/oradata/hzh/redo02.log','/u01/app/oracle/oradata/hzh/redo02b.log') size 200M;
Database altered.
SYS@hzh >alter database add logfile group 3 ('/u01/app/oracle/oradata/hzh/redo03.log','/u01/app/oracle/oradata/hzh/redo03b.log') size 200M;
Database altered.
SYS@hzh >select GROUP#,MEMBERS,STATUS,ARCHIVED,BYTES/1024/1024||'M' bt from v$log;
GROUP# MEMBERS STATUS ARC BT
---------- ---------- ---------------- --- ----------
1 1 INACTIVE YES 50M
2 2 UNUSED YES 200M
3 2 UNUSED YES 200M
4 2 CURRENT NO 200M
SYS@hzh >alter database drop logfile group 1;
Database altered.
[oracle@hong hzh]$ rm redo01.log
SYS@hzh >alter database add logfile group 1 ('/u01/app/oracle/oradata/hzh/redo01.log','/u01/app/oracle/oradata/hzh/redo01b.log') size 200M;
Database altered.
SYS@hzh >select GROUP#,MEMBERS,STATUS,ARCHIVED,BYTES/1024/1024||'M' bt from v$log;
GROUP# MEMBERS STATUS ARC BT
---------- ---------- ---------------- --- ----------
1 2 UNUSED YES 200M
2 2 UNUSED YES 200M
3 2 UNUSED YES 200M
4 2 CURRENT NO 200M
SYS@hzh >alter system switch logfile;
System altered.
SYS@hzh >select GROUP#,MEMBERS,STATUS,ARCHIVED,BYTES/1024/1024||'M' bt from v$log;
GROUP# MEMBERS STATUS ARC BT
---------- ---------- ---------------- --- ----------
1 2 CURRENT NO 200M
2 2 UNUSED YES 200M
3 2 UNUSED YES 200M
4 2 ACTIVE YES 200M
SYS@hzh >alter system switch logfile;
System altered.
SYS@hzh >select GROUP#,MEMBERS,STATUS,ARCHIVED,BYTES/1024/1024||'M' bt from v$log;
GROUP# MEMBERS STATUS ARC BT
---------- ---------- ---------------- --- ----------
1 2 ACTIVE YES 200M
2 2 CURRENT NO 200M
3 2 UNUSED YES 200M
4 2 INACTIVE YES 200M
到此，已经修改完了，后面的步骤，纯属个人洁癖
SYS@hzh >alter database drop logfile group 4;
Database altered.
SYS@hzh >select GROUP#,MEMBERS,STATUS,ARCHIVED,BYTES/1024/1024||'M' bt from v$log;
GROUP# MEMBERS STATUS ARC BT
---------- ---------- ---------------- --- ----------
1 2 ACTIVE YES 200M
2 2 CURRENT NO 200M
3 2 UNUSED YES 200M
[oracle@hong hzh]$ rm redo04*

kingsql作品
如有建议请回帖或发电子邮件至hongzhuohui@kingsql.com
★希望向高手学习、同时帮助新手★

ITPub博客

kingsql 如何修改Oralce日志文件大小

最新文章