oracle数据库mount时提示LGWR (ospid: 125156): terminating the instance 无法启动数据库
Trace file D:\ORACLE11G\diag\rdbms\mis\mis\trace\cdmp_20180228120943\mis_diag_49496_bucket.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 8 - type 8664, 8 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:5925M/8191M, Ph+PgF:11523M/16381M
VM name : VMWare Version (6)
Instance name: mis
Redo thread mounted by this instance: 1
Oracle process number: 6
Windows thread id: 49496, image: ORACLE.EXE (DIAG)
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 8 - type 8664, 8 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:5925M/8191M, Ph+PgF:11523M/16381M
VM name : VMWare Version (6)
Instance name: mis
Redo thread mounted by this instance: 1
Oracle process number: 6
Windows thread id: 49496, image: ORACLE.EXE (DIAG)
*** 2018-02-28 12:09:43.226
*** SESSION ID:(187.1) 2018-02-28 12:09:43.226
*** CLIENT ID:() 2018-02-28 12:09:43.226
*** SERVICE NAME:() 2018-02-28 12:09:43.226
*** MODULE NAME:() 2018-02-28 12:09:43.226
*** ACTION NAME:() 2018-02-28 12:09:43.226
*** SESSION ID:(187.1) 2018-02-28 12:09:43.226
*** 2018-02-28 12:09:43.226
Process diagnostic dump for ORACLE.EXE (DIAG), OS id=49496,
pid: 6, proc_ser: 1, sid: 187, sess_ser: 1
-------------------------------------------------------------------------------
current sql: <none>
Current Wait Stack:
1: waiting for 'process diagnostic dump'
=0x0, =0x0, =0x0
wait_id=10 seq_num=15 snap_id=1
wait times: snap=0.000016 sec, exc=0.000016 sec, total=0.000016 sec
wait times: max=30.000000 sec, heur=0.014025 sec
wait counts: calls=0 os=0
in_wait=1 iflags=0x520
0: waiting for 'DIAG idle wait'
component=0x5, where=0x1, wait time(millisec)=0x3e8
wait_id=5 seq_num=14 snap_id=5
wait times: snap=0.000000 sec, exc=1.078005 sec, total=1.080948 sec
wait times: max=1.000000 sec, heur=6.149839 sec
wait counts: calls=1 os=1
in_wait=1 iflags=0x15a8
Wait State:
fixed_waits=0 flags=0x22 boundary=0x0000000000000000/-1
Session Wait History:
elapsed time of 0.000000 sec since current wait
0: waited for 'DIAG idle wait'
component=0x5, where=0x1, wait time(millisec)=0x3e8
wait_id=5 seq_num=14 snap_id=5
wait times: snap=0.002074 sec, exc=1.078005 sec, total=1.080932 sec
wait times: max=1.000000 sec
wait counts: calls=1 os=1
occurred after 0.000000 sec of elapsed time
1: waited for 'process diagnostic dump'
=0x0, =0x0, =0x0
wait_id=9 seq_num=13 snap_id=1
wait times: snap=0.000581 sec, exc=0.000581 sec, total=0.000581 sec
wait times: max=30.000000 sec
wait counts: calls=0 os=0
occurred after 0.000000 sec of elapsed time
2: waited for 'DIAG idle wait'
component=0x5, where=0x1, wait time(millisec)=0x3e8
wait_id=5 seq_num=12 snap_id=4
wait times: snap=0.001893 sec, exc=1.075931 sec, total=1.078277 sec
wait times: max=1.000000 sec
wait counts: calls=1 os=1
occurred after 0.000000 sec of elapsed time
3: waited for 'process diagnostic dump'
=0x0, =0x0, =0x0
wait_id=8 seq_num=11 snap_id=1
wait times: snap=0.000678 sec, exc=0.000678 sec, total=0.000678 sec
wait times: max=30.000000 sec
wait counts: calls=0 os=0
occurred after 0.000000 sec of elapsed time
4: waited for 'DIAG idle wait'
component=0x5, where=0x1, wait time(millisec)=0x3e8
wait_id=5 seq_num=10 snap_id=3
wait times: snap=0.004625 sec, exc=1.074038 sec, total=1.075706 sec
wait times: max=1.000000 sec
wait counts: calls=1 os=1
occurred after 0.000000 sec of elapsed time
5: waited for 'process diagnostic dump'
=0x0, =0x0, =0x0
wait_id=7 seq_num=9 snap_id=1
wait times: snap=0.001054 sec, exc=0.001054 sec, total=0.001054 sec
wait times: max=30.000000 sec
wait counts: calls=0 os=0
occurred after 0.000000 sec of elapsed time
6: waited for 'DIAG idle wait'
component=0x5, where=0x1, wait time(millisec)=0x3e8
wait_id=5 seq_num=8 snap_id=2
wait times: snap=0.002490 sec, exc=1.069413 sec, total=1.070027 sec
wait times: max=1.000000 sec
wait counts: calls=1 os=1
occurred after 0.000000 sec of elapsed time
7: waited for 'process diagnostic dump'
=0x0, =0x0, =0x0
wait_id=6 seq_num=7 snap_id=1
wait times: snap=0.000614 sec, exc=0.000614 sec, total=0.000614 sec
wait times: max=30.000000 sec
wait counts: calls=0 os=0
occurred after 0.000000 sec of elapsed time
8: waited for 'DIAG idle wait'
component=0x5, where=0x1, wait time(millisec)=0x3e8
wait_id=5 seq_num=6 snap_id=1
wait times: snap=1.066923 sec, exc=1.066923 sec, total=1.066923 sec
wait times: max=1.000000 sec
wait counts: calls=1 os=1
occurred after 0.000023 sec of elapsed time
9: waited for 'DIAG idle wait'
component=0x5, where=0x1, wait time(millisec)=0x3e8
wait_id=4 seq_num=5 snap_id=1
wait times: snap=1.014037 sec, exc=1.014037 sec, total=1.014037 sec
wait times: max=1.000000 sec
wait counts: calls=1 os=1
occurred after 0.000021 sec of elapsed time
Sampled Session History of session 187 serial 1
---------------------------------------------------
The sampled session history is constructed by sampling
the target session every 1 second. The sampling process
captures at each sample if the session is in a non-idle wait,
an idle wait, or not in a wait. If the session is in a
non-idle wait then one interval is shown for all the samples
the session was in the same non-idle wait. If the
session is in an idle wait or not in a wait for
consecutive samples then one interval is shown for all
the consecutive samples. Though we display these consecutive
samples in a single interval the session may NOT be continuously
idle or not in a wait (the sampling process does not know).
The history is displayed in reverse chronological order.
sample interval: 1 sec, max history 120 sec
---------------------------------------------------
[3 samples, 12:09:41 - 12:09:43]
idle wait at each sample
-------------------------------------------------------------------------------
Process diagnostic dump actual duration=0.000000 sec
(max dump time=30.000000 sec)
Process diagnostic dump for ORACLE.EXE (DIAG), OS id=49496,
pid: 6, proc_ser: 1, sid: 187, sess_ser: 1
-------------------------------------------------------------------------------
current sql: <none>
Current Wait Stack:
1: waiting for 'process diagnostic dump'
=0x0, =0x0, =0x0
wait_id=10 seq_num=15 snap_id=1
wait times: snap=0.000016 sec, exc=0.000016 sec, total=0.000016 sec
wait times: max=30.000000 sec, heur=0.014025 sec
wait counts: calls=0 os=0
in_wait=1 iflags=0x520
0: waiting for 'DIAG idle wait'
component=0x5, where=0x1, wait time(millisec)=0x3e8
wait_id=5 seq_num=14 snap_id=5
wait times: snap=0.000000 sec, exc=1.078005 sec, total=1.080948 sec
wait times: max=1.000000 sec, heur=6.149839 sec
wait counts: calls=1 os=1
in_wait=1 iflags=0x15a8
Wait State:
fixed_waits=0 flags=0x22 boundary=0x0000000000000000/-1
Session Wait History:
elapsed time of 0.000000 sec since current wait
0: waited for 'DIAG idle wait'
component=0x5, where=0x1, wait time(millisec)=0x3e8
wait_id=5 seq_num=14 snap_id=5
wait times: snap=0.002074 sec, exc=1.078005 sec, total=1.080932 sec
wait times: max=1.000000 sec
wait counts: calls=1 os=1
occurred after 0.000000 sec of elapsed time
1: waited for 'process diagnostic dump'
=0x0, =0x0, =0x0
wait_id=9 seq_num=13 snap_id=1
wait times: snap=0.000581 sec, exc=0.000581 sec, total=0.000581 sec
wait times: max=30.000000 sec
wait counts: calls=0 os=0
occurred after 0.000000 sec of elapsed time
2: waited for 'DIAG idle wait'
component=0x5, where=0x1, wait time(millisec)=0x3e8
wait_id=5 seq_num=12 snap_id=4
wait times: snap=0.001893 sec, exc=1.075931 sec, total=1.078277 sec
wait times: max=1.000000 sec
wait counts: calls=1 os=1
occurred after 0.000000 sec of elapsed time
3: waited for 'process diagnostic dump'
=0x0, =0x0, =0x0
wait_id=8 seq_num=11 snap_id=1
wait times: snap=0.000678 sec, exc=0.000678 sec, total=0.000678 sec
wait times: max=30.000000 sec
wait counts: calls=0 os=0
occurred after 0.000000 sec of elapsed time
4: waited for 'DIAG idle wait'
component=0x5, where=0x1, wait time(millisec)=0x3e8
wait_id=5 seq_num=10 snap_id=3
wait times: snap=0.004625 sec, exc=1.074038 sec, total=1.075706 sec
wait times: max=1.000000 sec
wait counts: calls=1 os=1
occurred after 0.000000 sec of elapsed time
5: waited for 'process diagnostic dump'
=0x0, =0x0, =0x0
wait_id=7 seq_num=9 snap_id=1
wait times: snap=0.001054 sec, exc=0.001054 sec, total=0.001054 sec
wait times: max=30.000000 sec
wait counts: calls=0 os=0
occurred after 0.000000 sec of elapsed time
6: waited for 'DIAG idle wait'
component=0x5, where=0x1, wait time(millisec)=0x3e8
wait_id=5 seq_num=8 snap_id=2
wait times: snap=0.002490 sec, exc=1.069413 sec, total=1.070027 sec
wait times: max=1.000000 sec
wait counts: calls=1 os=1
occurred after 0.000000 sec of elapsed time
7: waited for 'process diagnostic dump'
=0x0, =0x0, =0x0
wait_id=6 seq_num=7 snap_id=1
wait times: snap=0.000614 sec, exc=0.000614 sec, total=0.000614 sec
wait times: max=30.000000 sec
wait counts: calls=0 os=0
occurred after 0.000000 sec of elapsed time
8: waited for 'DIAG idle wait'
component=0x5, where=0x1, wait time(millisec)=0x3e8
wait_id=5 seq_num=6 snap_id=1
wait times: snap=1.066923 sec, exc=1.066923 sec, total=1.066923 sec
wait times: max=1.000000 sec
wait counts: calls=1 os=1
occurred after 0.000023 sec of elapsed time
9: waited for 'DIAG idle wait'
component=0x5, where=0x1, wait time(millisec)=0x3e8
wait_id=4 seq_num=5 snap_id=1
wait times: snap=1.014037 sec, exc=1.014037 sec, total=1.014037 sec
wait times: max=1.000000 sec
wait counts: calls=1 os=1
occurred after 0.000021 sec of elapsed time
Sampled Session History of session 187 serial 1
---------------------------------------------------
The sampled session history is constructed by sampling
the target session every 1 second. The sampling process
captures at each sample if the session is in a non-idle wait,
an idle wait, or not in a wait. If the session is in a
non-idle wait then one interval is shown for all the samples
the session was in the same non-idle wait. If the
session is in an idle wait or not in a wait for
consecutive samples then one interval is shown for all
the consecutive samples. Though we display these consecutive
samples in a single interval the session may NOT be continuously
idle or not in a wait (the sampling process does not know).
The history is displayed in reverse chronological order.
sample interval: 1 sec, max history 120 sec
---------------------------------------------------
[3 samples, 12:09:41 - 12:09:43]
idle wait at each sample
-------------------------------------------------------------------------------
Process diagnostic dump actual duration=0.000000 sec
(max dump time=30.000000 sec)
*** 2018-02-28 12:09:43.226
-------------------------------------------------------------------------------
Trace Bucket Dump Begin: default bucket for process 6 (osid: 49496, DIAG)
TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA
-------------------------------------------------------------------------------
2018-02-28 12:09:37.074069 :80000065:db_trace:kst.c@675:kstipg(): [10280:6:0] kst: process state object created on 02-28 12:09:37.064
2018-02-28 12:09:37.074072 :80000066:db_trace:kst.c@681:kstipg(): [10280:6:0] kst: process info: ospid=49496 pso_num=6 pso_serial#=1
2018-02-28 12:09:37.074361 :80000067:db_trace:kso.c@4291:ksonfy(): [10420:6:0] kso: new process: pid=49496 osp_idx=5 osp_ver=0 osp_pg=0 (spawn #4)
2018-02-28 12:09:37.074364 :80000068:db_trace:kso.c@4297:ksonfy(): [10420:6:0] kso: new process: first_req_pid=93688 spawner_pid=122340 sga_crt_ts=x7C84E48
2018-02-28 12:09:37.074366 :80000069:db_trace:kso.c@4301:ksonfy(): [10420:6:0] kso: new process: pso_index=6 reservation=1 time=130568687
2018-02-28 12:09:37.074368 :8000006A:db_trace:kso.c@4307:ksonfy(): [10420:6:0] kso: spawn diagnostics: queue time=0 secs
2018-02-28 12:09:37.074369 :8000006B:db_trace:kso.c@4309:ksonfy(): [10420:6:0] kso: spawn diagnostics: fork time=0 secs
2018-02-28 12:09:37.074371 :8000006C:db_trace:kso.c@4311:ksonfy(): [10420:6:0] kso: spawn diagnostics: exec time=0 secs
2018-02-28 12:09:37.074373 :8000006D:db_trace:kso.c@4313:ksonfy(): [10420:6:0] kso: spawn diagnostics: pre dbkc time=0 secs
2018-02-28 12:09:37.074375 :8000006E:db_trace:kso.c@4315:ksonfy(): [10420:6:0] kso: spawn diagnostics: post dbkc time=0 secs
2018-02-28 12:09:37.074482 :8000006F:db_trace:ksl2.c@16009:ksl_update_post_stats(): [10005:6:0] KSL POST SENT postee=149 num=1 loc='kso2.h LINE:472 ID:ksoreq_reply' id1=0 id2=0 name= type=0
2018-02-28 12:09:37.074507 :80000070:db_trace:kso.c@5759:kso_spawn_diag_end(): [10420:6:0] kso: spawn diagnostics: init time=0 secs
-------------------------------------------------------------------------------
Trace Bucket Dump End: default bucket for process 6 (osid: 49496, DIAG)
-------------------------------------------------------------------------------
Trace Bucket Dump Begin: default bucket for process 6 (osid: 49496, DIAG)
TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA
-------------------------------------------------------------------------------
2018-02-28 12:09:37.074069 :80000065:db_trace:kst.c@675:kstipg(): [10280:6:0] kst: process state object created on 02-28 12:09:37.064
2018-02-28 12:09:37.074072 :80000066:db_trace:kst.c@681:kstipg(): [10280:6:0] kst: process info: ospid=49496 pso_num=6 pso_serial#=1
2018-02-28 12:09:37.074361 :80000067:db_trace:kso.c@4291:ksonfy(): [10420:6:0] kso: new process: pid=49496 osp_idx=5 osp_ver=0 osp_pg=0 (spawn #4)
2018-02-28 12:09:37.074364 :80000068:db_trace:kso.c@4297:ksonfy(): [10420:6:0] kso: new process: first_req_pid=93688 spawner_pid=122340 sga_crt_ts=x7C84E48
2018-02-28 12:09:37.074366 :80000069:db_trace:kso.c@4301:ksonfy(): [10420:6:0] kso: new process: pso_index=6 reservation=1 time=130568687
2018-02-28 12:09:37.074368 :8000006A:db_trace:kso.c@4307:ksonfy(): [10420:6:0] kso: spawn diagnostics: queue time=0 secs
2018-02-28 12:09:37.074369 :8000006B:db_trace:kso.c@4309:ksonfy(): [10420:6:0] kso: spawn diagnostics: fork time=0 secs
2018-02-28 12:09:37.074371 :8000006C:db_trace:kso.c@4311:ksonfy(): [10420:6:0] kso: spawn diagnostics: exec time=0 secs
2018-02-28 12:09:37.074373 :8000006D:db_trace:kso.c@4313:ksonfy(): [10420:6:0] kso: spawn diagnostics: pre dbkc time=0 secs
2018-02-28 12:09:37.074375 :8000006E:db_trace:kso.c@4315:ksonfy(): [10420:6:0] kso: spawn diagnostics: post dbkc time=0 secs
2018-02-28 12:09:37.074482 :8000006F:db_trace:ksl2.c@16009:ksl_update_post_stats(): [10005:6:0] KSL POST SENT postee=149 num=1 loc='kso2.h LINE:472 ID:ksoreq_reply' id1=0 id2=0 name= type=0
2018-02-28 12:09:37.074507 :80000070:db_trace:kso.c@5759:kso_spawn_diag_end(): [10420:6:0] kso: spawn diagnostics: init time=0 secs
-------------------------------------------------------------------------------
Trace Bucket Dump End: default bucket for process 6 (osid: 49496, DIAG)
求大神解答
