从数据库后台alert日志查看，有大量的redo
log切换信息，影响数据库的运行效率，可把相应的设置调大。
Tue Feb 5 10:22:22 2013
Thread 1 advanced to log sequence 4593
Current log# 3 seq# 4593 mem# 0: /arp/oraarp/oradata/arpdb/redo03.log
Thread 1 advanced to log sequence 4594
Current log# 2 seq# 4594 mem# 0: /arp/oraarp/oradata/arpdb/redo02.log
Tue Feb 5 10:22:37 2013
Thread 1 cannot allocate new log, sequence 4595
Checkpoint not complete
Current log# 2 seq# 4594 mem# 0: /arp/oraarp/oradata/arpdb/redo02.log
Thread 1 advanced to log sequence 4595
Current log# 1 seq# 4595 mem# 0: /arp/oraarp/oradata/arpdb/redo01.log
解决方法：ERP
[oraprod@arpinfo proddata]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.3.0 - Production on Sun Jan 6 20:30:45
2013
Copyright (c) 1982, 2002, Oracle Corporation.
All rights reserved.
SQL> conn / as sysdba
SQL> alter database add logfile
group 4 ('/arp/oraarp/oradata/arpdb/redo04.log') size
100M;
SQL> alter database add logfile group
3 ('/ora1159/prod/proddata/log03a.dbf') size 100M;
SQL> select group#,sequence#,bytes,members,status from
v$log;
GROUP#
SEQUENCE#
BYTES
MEMBERS STATUS
---------- ---------- ---------- ----------
--------------------------------
1
8147
52428800
1 INACTIVE
2
8149
52428800
1 CURRENT
3
8148
52428800
1 INACTIVE
SQL> alter database add logfile group
4 ('/arp/oraarp/oradata/arpdb/redo04.log') size 100M;
Database altered.
SQL> select group#,sequence#,bytes,members,status from
v$log;
GROUP#
SEQUENCE#
BYTES
MEMBERS STATUS
---------- ---------- ---------- ----------
--------------------------------
1
8147
52428800
1 INACTIVE
2
8149
52428800
1 CURRENT
3
8148
52428800
1 INACTIVE
4
0 104857600
1 UNUSED
SQL> alter system switch logfile;
（alter
system archive log curren）
System altered.
--------------------------------------------------------------------
参考自：http://blog.csdn.net/zonelan/article/details/7613519
增加日志组：
1、select
group#,sequence#,bytes,members,status from v$log;
查看每组日志的状态
GROUP# SEQUENCE#
BYTES
MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
1
16946
52428800
1 INACTIVE
## 空闲的
2
16947
52428800
1 INACTIVE
## 空闲的
3
16948
52428800
1 CURRENT
##正在使用的
2、alter database add logfile group 4
('/opt/oradata/orclbj/redo04.log') size 200M;
增加1组日志组 视情况而定增加日志组的大小。
alter database add logfile group 5
('/opt/oradata/orclbj/redo05.log') size 200M;
alter database add logfile group 6
('/opt/oradata/orclbj/redo06.log') size 200M;
3、alter system switch logfile;
切换日志组
4、alter database drop logfile group
1; 删除日志组1 在线增加日志组的时候，删除日志组的时候只能删除
日志组状态为 INACTIVE
的日志组。
加载中，请稍候......
加载中…
喜欢