作者:jzcpojwmds_652 | 来源:互联网 | 2023-09-14 16:12
主机蓝屏后,虚拟机里的数据库启动不了。
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-03113: 通信通道的文件结尾
进程 ID: 2348
会话 ID: 1 序列号: 5
SQL> select status from v$instance;
ERROR:
ORA-03114: 未连接到 ORACLE
Trace file E:\ORCL11\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_2348.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 : 1 - type 8664, 1 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:2579M/4410M, Ph+PgF:5562M/8819M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 19
Windows thread id: 2348, image: ORACLE.EXE (SHAD)
* 2015-10-29 19:01:34.584
* SESSION ID:(1.5) 2015-10-29 19:01:34.584
* CLIENT ID:() 2015-10-29 19:01:34.584
* SERVICE NAME:() 2015-10-29 19:01:34.584
* MODULE NAME:(sqlplus.exe) 2015-10-29 19:01:34.584
* ACTION NAME:() 2015-10-29 19:01:34.584
Thread 1 checkpoint: logseq 10, block 2, scn 2656402
cache-low rba: logseq 10, block 3
1
| on-disk rba: logseq 10, block 102, scn 2656497 |
start recovery at logseq 10, block 3, scn 0
* 2015-10-29 19:01:34.974
Started writing zeroblks thread 1 seq 10 blocks 124-131
* 2015-10-29 19:01:34.990
Completed writing zeroblks thread 1 seq 10
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 4096Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 60Kb in 0.82s => 0.07 Mb/sec
Longest record: 2Kb, moves: 0/116 (0%)
Longest LWN: 16Kb, moves: 0/38 (0%), moved: 0Mb
Last redo scn: 0x0000.00288906 (2656518)
----- Recovery Hash Table Statistics ---------
Hash table buckets = 262144
Longest hash chain = 1
Average hash chain = 28/28 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 211/239 = 0.9
* 2015-10-29 19:01:35.412
KCRA: start recovery claims for 28 data blocks
* 2015-10-29 19:01:35.427
KCRA: blocks processed = 28/28, claimed = 28, eliminated = 0
* 2015-10-29 19:01:35.474
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10 Reading mem 0
* 2015-10-29 19:01:35.771
Completed redo application of 0.04MB
* 2015-10-29 19:01:36.021
Completed recovery checkpoint
----- Recovery Hash Table Statistics ---------
Hash table buckets = 262144
Longest hash chain = 1
Average hash chain = 28/28 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 239/239 = 1.0
Recovery sets nab of thread 1 seq 10 to 124 with 8 zeroblks
* 2015-10-29 19:01:37.287
kwqmnich: current time:: 11: 1: 36: 0
kwqmnich: instance no 0 repartition flag 1
kwqmnich: initialized job cache structure
kwqinfy: Call kwqrNondurSubInstTsk
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x44FDFF14] [PC:0xF345FE, kgegpa()+38]
DDE previous invocation failed before phase II
DDE was called in a 'No Invocation Mode'
----- Start Diag Diagnostic Dump -----
Diag diagnostic dump is performed due to an error in the diagfw code during error handling.
DDE is switched to protected mode during the diagnostic dump to prevent recursive errors in the error hadnling code.
Dump error and call stack for the diagnostic dump:
* 2015-10-29 19:01:37.943
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=1, mask=0x0)
----- Error Stack Dump -----
Dump file e:\orcl11\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_2348.trc
Thu Oct 29 19:01:37 2015
ORACLE V11.2.0.3.0 - 64bit Production vsnsta=0
vsnsql=16 vsnxtr=3
Dumping diagnostics for abrupt exit from ksedmp
ksedmp exception at address PC:0xF345FE
ksedmp exception at kgegpa()
Dumping initial exception call-stack
------------------- Call Stack Trace ---------------------
Frameptr RetAddr Param#1 Param#2 Param#3 Param#4 Function Name
0000000000F345FE 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 kgegpa()+38
0000000000F35507 0000000000F345D8 0000000000000001 0000000000F35465 000000000CC61640 0000000000000001 kgeprm()+89
0000000000CE2E13 0000000000F354AE 000000000431FB50 000000014015BD85 0000000000002000 000007FF6287E608 dbgexPopulateErrorKGEFrame
0000000000CE2D22 0000000000CE2DF1 0000000000000008 000000000058AEEC 0000000000000001 0000000100002000 dbgexPopulateErrorKGE()+94
0000000000C916AF 0000000000CE2CC4 0000000011CDBD50 0000000000B23BB9 000000000CC61640 0000000000000001 dbgePostErrorKGE()+2213
0000000140C734D7 0000000000C90E0A 0000000011CDC310 0000000005261168 0000000000000258 0000122B4FEEF1F9 dbkePostKGE_kgsf()+77
0000000000F337F1 0000000140C7348A 0000000000000000 0000000000000000 00000001FFFFFFFF 0000027F00000000 kgeade()+563
0000000000F2FDE7 0000000000F335BE 0000000000000000 00000000135C23E8 0000000011CDBD50 00000000135C23A0 kgeriv_int()+139
0000000000F320BF 0000000000F2FD5C 0000000000000000 00000000135C0D50 0000000000024258 00000000135C0D50 kgeriv()+29
000000014001B647 0000000000F320A2 0000000000000000 0000000000C92D42 0000000011C89370 000007FF6284CED4 kseric2()+111
0000000142C9081D 000000014001B5D8 0000000000001062 0000000000000009 0000000000000017 000007FF3E854014 kturdb()+1671
00000001411E5D7C 0000000142C90196 0000000011CDC310 000000000000004E 000007FF00000055 000007FF6192D710 kco_issue_callback()+196
00000001411E74A6 00000001411E5CB8 00000001477A1980 0000000011CDC310 00000000018EEA90 0000000000FAB999 kcoapl()+746
00000001406ABE13 00000001411E71BC 00000000135C2310 000007FF3E854000 000007FF00000001 000000007FFFFFFF kcbapl()+241
00000001412D3C7B 00000001406ABD22 000000000431FB50 00000000FFFFFF00 0000000000000000 000000000025AD35 kcrfw_redo_gen()+3821
00000001406A3C21 00000001412D2D8E 000007FF5FF10838 0000001500000002 0000008000000007 0000000000000000 kcbchg1_main()+4607
00000001406A251B 00000001406A2A22 0000000000000001 00000000005D8D5E 000000000CC61640 0000000100000500 kcbchg1()+299
00000001408236D4 00000001406A23F0 0000000000000000 0000000100000002 0000000000000000 00000000135C2478 ktubgn()+1654
0000000140657A22 000000014082305E 000007FF61FD5FC8 000000000073CC38 0000000005270118 000000000527FD78 krvgfci_GatherFixedCommonI
000000014064EF8C 00000001406579AE 0000000011CDC010 0000000000B7DF50 0000000005250F05 0000000000000064 krvgrgd()+354
00000001441AC499 000000014064EE2A 0000000000000000 0000000000000000 0000000000000000 0000000000000000 knldcddl()+977
0000000142F8A216 00000001441AC0C8 0000000100000001 0000000000000000 5C6C637200000000 656C615C00000000 adbdrv()+742
0000000143473679 0000000142F89F30 000007FF00000023 000007FF00000003 0000000000000000 00000000135CA0E0 opiexe()+21501
00000001453602AA 000000014346E27C 000007FF00000004 0000000100000000 00000000135CA7C0 000007FF61930F60 opiosq0()+5150
00000001432CEA55 000000014535EE8C 0000000000000003 000000000000000E 00000000135C#0 00000000000000A4 kpooprx()+365
00000001432CD185 00000001432CE8E8 00000000135CAA30 00000000135CAA80 0000000011C89370 0000000000000001 kpoal8()+8619
0000000140C89322 00000001432CAFDA 000000000000005E 000000000000001C 00000000135CE080 0000000005193128 opiodr()+1644
00000000009434D3 0000000140C88CB6 000000000000005E 000000000000001C 00000000135CE080 0000000000000000 ttcpip()+1325
0000000140C85ABA 0000000000942FA6 0000000011CF8550 0000000000000000 0000000000000000 0000000000000000 opitsk()+2092
0000000143584C74 0000000140C8528E 000000000000001E 0000000000000000 0000000100000000 00000000006FCD8D opiino()+1246
0000000140C89322 0000000143584796 000000000000003C 0000000000000004 00000000135CFAB0 0000000000000000 opiodr()+1644
00000001400BD19C 0000000140C88CB6 000000000000003C 0000000000000004 00000000135CFAB0 4F5C3A4500000000 opidrv()+862
00000001400BE250 00000001400BCED4 000000000000003C 0000000000000004 00000000135CFAB0 0000000000000000 sou2o()+98
000000014000126C 00000001400BE1EE 01D11237445A2E97 0000000000000000 0012001D000A07DF 000403CB0036002F opimai_real()+158
00000001400010CD 00000001400011CE 0000000000000000 00000000135CFC68 0000000011C89370 00000000135CFC68 opimai()+191
0000000140002244 000000014000100E 0000000000000000 00000001476B9510 00000000000000E8 0000000000000644 OracleThreadStart()+724
000000007744652D 0000000140001F70 0000000013ACFF18 0000000000000000 0000000000000000 0000000000000000 000000007744652D
000000007757C521 0000000077446520 0000000000000000 0000000000000000 0000000000000000 0000000000000000 000000007757C521
---------------- End of Call Stack Trace -----------------
sss_xcpt_EvalFilterEx: setmav: Unable to convert access violation to OER(602)
retval is 1, InSXE is 1, kge data OK 0, setmav_allowed 1