数据库挂起了。。。。。。

oracle-plus

哦，那也就是用oradebug來看就最直接了，可以直接在trace文件裡面看到
*** SESSION ID3.1) 2005-02-01 10:18:43.000
Archiving is disabled
的字樣，對吧？

oracle-plus

我剛才試了一下，把 #log_archive_start = true mark掉了，然後重啟數據庫.
在做幾次alter system switch logfile;之後，就停住了。
然後在另外一個session裡面用
SQL> connect sys/sys@ora817 as sysdba
Connected.
SQL> oradebug hanganalyze 3;
Hang Analysis in D:\oracle\admin\oraplus\udump\ORA04680.TRC.
然後看到的trace文件如下：
Dump file D:\oracle\admin\oraplus\udump\ORA04680.TRC
Wed Feb 02 10:15:11 2005
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.1 Service Pack 1, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.1 Service Pack 1, CPU type 586
Instance name: ora817

Redo thread mounted by this instance: 1

Oracle process number: 9

Windows thread id: 5848, image: ORACLE.EXE


*** SESSION ID8.10) 2005-02-02 10:15:11.875
*** 2005-02-02 10:15:11.875
==============
HANG ANALYSIS:
==============
Open chains found:
Chain 1 : <sid/sess_srno/proc_ptr/ospid/wait_event> :
    <7/1/0x22dde6c/3028/switch logfile command>
Chain 2 : <sid/sess_srno/proc_ptr/ospid/wait_event> :
    <8/10/0x22de194/5848/No Wait>
Other chains found:
Extra information that will be dumped at higher levels:
[level  4] :   2 node dumps -- [LEAF] [LEAF_NW] [IGN_DMP]
[level 10] :   6 node dumps -- [IGN]

State of nodes
([nodenum]/sid/sess_srno/session/state/start/finish/[adjlist]/predecessor):
[0]/1/1/0x22fd938/IGN/1/2//none
[1]/2/1/0x22fe1a4/IGN/3/4//none
[2]/3/1/0x22fea10/IGN/5/6//none
[3]/4/1/0x22ff27c/IGN/7/8//none
[4]/5/1/0x22ffae8/IGN/9/10//none
[5]/6/1/0x2300354/IGN/11/12//none
[6]/7/1/0x2300bc0/LEAF/13/14//none
[7]/8/10/0x230142c/LEAF_NW/15/16//none
*** WARNING: no system state dumped ***
====================
END OF HANG ANALYSIS
====================

怎麼就沒有看到Archiving is disabled的字樣的？

biti_rainy

Archiving is disabled

----  是 bdump 下的！

oracle-plus

看到了！