|
|
我剛才試了一下，把 #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 ID 8.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的字樣的？ |
|
楼主: ghost_zy1979
IP卡
狗仔卡
发表于 2005-2-2 10:15
显身卡
发表于 2005-2-2 10:57