« Site Log | Main | 分配IP地址--朝阳提出的问题 »

redo log file

SQL> alter system switch logfile;

一直hang在那里,看log什么纪录也没有。傻了。想了好久,然后查看V$log:SQL> select group#,archived,status from v$log;    GROUP# ARC STATUS---------- --- ----------------         1 NO  ACTIVE         2 NO  CURRENT         3 NO  INACTIVE

SQL> alter system archive log all;System altered.

唉,解决,现在反应越来越慢了Glurps


作者: sopher | 可以转载, 转载时务必以超链接形式标明文章原始出处和作者信息及版权声明

网址: http://www.color-cc.com/2006/05/redo_log_file.html

Posted on May 29, 2006 10:05 AM Under Database. Tags :. RSS-Feed. TrackBack URL for this entry:
http://www.color-cc.com/mt/mt-tb.cgi/280.

Comments (1)

1 (Web)
Posted on May 29, 2006 10:05

AUTHOR:
EMAIL:
IP:
URL:
DATE: 05/29/2006 10:05:16 AM
AUTHOR:
EMAIL:
URL:
IP:
DATE: 05/29/2006 10:05:16 AM

Post a comment