s****y
发帖数: 581 | 1 SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 120943 52428800 1 NO ACTIVE
1883406504 01-MAY-12
2 1 120944 52428800 1 NO CURRENT
1883406711 01-MAY-12
3 1 120942 52428800 1 NO ACTIVE
1883402221 01-MAY-12
大家说说我的log group switch的正常吗？俺脚得一般至少应该
有一个马上要current的应该是INACTIVE吧？
是不是要多加一个log group？ | b*****r
发帖数: 239 | 2 Yes, try to add more log groups. | c*****d
发帖数: 6045 | 3 应该是log产生的太快了
可以查询一下v$log_history
select sequence#, to_char(first_time, 'yyyy-mm-dd hh24:mi')
from v$log_history |
|
