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.
唉,解决,现在反应越来越慢了
作者: sopher | 可以转载, 转载时务必以超链接形式标明文章原始出处和作者信息及版权声明
网址: http://www.color-cc.com/2006/05/redo_log_file.html
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