[ОТВЕТИТЬ]
Опции темы
26.11.2010 11:14  
horoshko
Instance terminated by USER, pid = 1168
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 335544320
__large_pool_size = 8388608
__java_pool_size = 8388608
__streams_pool_size = 0
sga_target = 1342177280
control_files = D:\ORACLE\ORADATA\MORO05\CONTROL01.CTL, D:\ORACLE\ORADATA\MORO05\CONTROL02.CTL, D:\ORACLE\ORADATA\MORO05\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 981467136
compatible = 10.2.0.3.0
db_file_multiblock_read_count= 16
undo_management = AUTO
undo_tablespace = UNDOTBS1
O7_DICTIONARY_ACCESSIBILITY= TRUE
remote_login_passwordfile= EXCLUSIVE
db_domain =
job_queue_processes = 10
audit_file_dest = D:\ORACLE\ADMIN\MORO05\ADUMP
background_dump_dest = D:\ORACLE\ADMIN\MORO05\BDUMP
user_dump_dest = D:\ORACLE\ADMIN\MORO05\UDUMP
core_dump_dest = D:\ORACLE\ADMIN\MORO05\CDUMP
db_name = moro05
open_cursors = 300
pga_aggregate_target = 445644800
PMON started with pid=2, OS id=3224
PSP0 started with pid=3, OS id=4088
MMAN started with pid=4, OS id=532
DBW0 started with pid=5, OS id=3884
LGWR started with pid=6, OS id=2296
CKPT started with pid=7, OS id=1864
SMON started with pid=8, OS id=2584
RECO started with pid=9, OS id=3016
CJQ0 started with pid=10, OS id=1288
MMON started with pid=11, OS id=2924
MMNL started with pid=12, OS id=4016
Fri Nov 26 03:32:47 2010
alter database mount exclusive
Fri Nov 26 03:32:51 2010
Setting recovery target incarnation to 1
Fri Nov 26 03:32:51 2010
Successful mount of redo thread 1, with mount id 1247362591
Fri Nov 26 03:32:51 2010
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri Nov 26 03:32:51 2010
alter database open
Fri Nov 26 03:32:51 2010
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Fri Nov 26 03:32:51 2010
Started redo scan
Fri Nov 26 03:32:52 2010
Completed redo scan
9955 redo blocks read, 617 data blocks need recovery
Fri Nov 26 03:32:52 2010
Started redo application at
Thread 1: logseq 135, block 76639
Fri Nov 26 03:32:53 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 135 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\MORO05\REDO03.LOG
Fri Nov 26 03:32:53 2010
Completed redo application
Fri Nov 26 03:32:53 2010
Completed crash recovery at
Thread 1: logseq 135, block 86594, scn 4637077
617 data blocks read, 616 data blocks written, 9955 redo blocks read
Fri Nov 26 03:32:54 2010
Thread 1 advanced to log sequence 136 (thread open)
Thread 1 opened at log sequence 136
Current log# 1 seq# 136 mem# 0: D:\ORACLE\ORADATA\MORO05\REDO01.LOG
Successful open of redo thread 1
Fri Nov 26 03:32:54 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Nov 26 03:32:54 2010
SMON: enabling cache recovery
Fri Nov 26 03:32:55 2010
Successfully onlined Undo Tablespace 1.
Fri Nov 26 03:32:55 2010
SMON: enabling tx recovery
Fri Nov 26 03:32:55 2010
Database Characterset is CL8MSWIN1251
Fri Nov 26 03:32:56 2010
Errors in file d:\oracle\admin\moro05\bdump\moro05_smon_2584.trc:
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []

Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 8
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=21, OS id=3760
Fri Nov 26 03:32:58 2010
Errors in file d:\oracle\admin\moro05\bdump\moro05_smon_2584.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kghstack_err+104] [PC:0x3FC0120] [ADDR:0xFFFFFFF0] [UNABLE_TO_READ] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []

Fri Nov 26 03:33:01 2010
Completed: alter database open
Fri Nov 26 03:33:02 2010
Errors in file d:\oracle\admin\moro05\bdump\moro05_pmon_3224.trc:
ORA-00474: SMON process terminated with error

Fri Nov 26 03:33:02 2010
Errors in file d:\oracle\admin\moro05\bdump\moro05_lgwr_2296.trc:
ORA-00474: SMON process terminated with error

Fri Nov 26 03:33:02 2010
PMON: terminating instance due to error 474
Fri Nov 26 03:33:02 2010
Errors in file d:\oracle\admin\moro05\bdump\moro05_mman_532.trc:
ORA-00474: SMON process terminated with error

Fri Nov 26 03:33:02 2010
Errors in file d:\oracle\admin\moro05\bdump\moro05_psp0_4088.trc:
ORA-00474: SMON process terminated with error

Fri Nov 26 03:33:02 2010
Errors in file d:\oracle\admin\moro05\bdump\moro05_dbw0_3884.trc:
ORA-00474: SMON process terminated with error

Fri Nov 26 03:33:02 2010
Errors in file d:\oracle\admin\moro05\bdump\moro05_ckpt_1864.trc:
ORA-00474: SMON process terminated with error

Fri Nov 26 03:33:03 2010
Errors in file d:\oracle\admin\moro05\bdump\moro05_reco_3016.trc:
ORA-00474: SMON process terminated with error

Instance terminated by PMON, pid = 3224
 
26.11.2010 11:33  
Mtirt
Что содержится в указанных тобой трейсах?
 
26.11.2010 12:02  
horoshko
Dump file d:\oracle\admin\moro05\bdump\moro05_smon_2584.trc
Fri Nov 26 03:32:55 2010
ORACLE V10.2.0.4.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows Server 2003 Version V5.2 Service Pack 1
CPU : 8 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2732M/3547M, Ph+PgF:3379M/5439M, VA:576M/2047M
Instance name: moro05

Redo thread mounted by this instance: 1

Oracle process number: 8

Windows thread id: 2584, image: ORACLE.EXE (SMON)


*** SERVICE NAME:() 2010-11-26 03:32:55.953
*** SESSION ID:(164.1) 2010-11-26 03:32:55.953
Corrupted stack chunk header at location 07785FBC
***** Dump of memory around addr 07785FBC:
7784FB0 6C626173 [sabl]
7784FC0 142E6465 4E020101 0100044F 414F4E0C [ed.....NO....NOA]
7784FD0 49484352 4F4C4556 01000447 45504F04 [RCHIVELOG....OPE]
7784FE0 0100044E 6C6F6316 7463656C 6920726F [N....collector i]
7784FF0 69642073 6C626173 142E6465 4E020101 [s disabled.....N]
7785000 0100044F 414F4E0C 49484352 4F4C4556 [O....NOARCHIVELO]
7785010 01000447 3262640D 2C303030 6F726F6D [G....db2000,moro]
7785020 00043530 464F0301 01000446 3A4E4F1B [05....OFF....ON:]
7785030 636F4C20 4F206C61 75412053 6E656874 [ Local OS Authen]
7785040 61636974 6E6F6974 03010004 0466666F [tication....off.]
7785050 30140100 4F4E2D31 30322D56 31203031 [...01-NOV-2010 1]
7785060 37333A35 0431303A 310A0100 2E322E30 [5:37:01....10.2.]
7785070 2E342E30 01000430 53494C08 454E4554 [0.4.0....LISTENE]
7785080 01000452 44412832 53455244 50283D53 [R...2(ADDRESS=(P]
7785090 4F544F52 3D4C4F43 29504354 534F4828 [ROTOCOL=TCP)(HOS]
77850A0 6D733D54 76726573 28297265 54524F50 [T=smserver)(PORT]
77850B0 3235313D 04292931 441C0100 524F5C3A [=1521))....D:\OR]
77850C0 454C4341 4D44415C 4D5C4E49 304F524F [ACLE\ADMIN\MORO0]
77850D0 44555C35 04504D55 441C0100 524F5C3A [5\UDUMP....D:\OR]
77850E0 454C4341 4D44415C 4D5C4E49 304F524F [ACLE\ADMIN\MORO0]
77850F0 44435C35 04504D55 441C0100 524F5C3A [5\CDUMP....D:\OR]
7785100 454C4341 4D44415C 4D5C4E49 304F524F [ACLE\ADMIN\MORO0]
 
26.11.2010 12:03  
horoshko
Dump file d:\oracle\admin\moro05\bdump\moro05_pmon_3224.trc
Fri Nov 26 03:33:02 2010
ORACLE V10.2.0.4.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows Server 2003 Version V5.2 Service Pack 1
CPU : 8 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2718M/3547M, Ph+PgF:3374M/5439M, VA:568M/2047M
Instance name: moro05

Redo thread mounted by this instance: 1

Oracle process number: 2

Windows thread id: 3224, image: ORACLE.EXE (PMON)


*** 2010-11-26 03:33:02.078
*** SERVICE NAME:(SYS$BACKGROUND) 2010-11-26 03:33:01.968
*** SESSION ID:(170.1) 2010-11-26 03:33:01.968
Background process SMON found dead
Oracle pid = 8
OS pid (from detached process) = 2584
OS pid (from process state) = 2584
dtp = 03E51930, proc = 5FA84F84
Dump of memory from 0x03E51930 to 0x03E51978
3E51930 0000007C 5FA84F84 00000000 00000000 [|....O._........]
3E51940 4E4F4D53 00000200 00000844 00000334 [SMON....D...4...]
3E51950 00000A18 D4ACAF20 01CB8D09 4E4F4D53 [.... .......SMON]
3E51960 00000000 00000000 00000330 00000001 [........0.......]
3E51970 00566CF6 00040081 [.lV.....]
Dump of memory from 0x5FA84F84 to 0x5FA8557C
5FA84F80 00000102 00000000 00000000 [............]
5FA84F90 00000000 00000000 5FCBFEA8 5E922F3C [..........._</.^]
5FA84FA0 5FBA5EF4 5E92203C 00000000 5E9220C0 [.^._< .^..... .^]
5FA84FB0 5E9220C0 5E922F30 00001601 00000000 [. .^0/.^........]
5FA84FC0 5FB8C2AC 5FBA4614 00000008 00000000 [..._.F._........]
5FA84FD0 5FBA6090 00000000 5FCBEDF8 5FCBFEC0 [.`._......._..._]
5FA84FE0 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
5FA85020 00000000 000C0000 00000000 000E0000 [................]
5FA85030 00000000 000B0000 00000000 000F0000 [................]
5FA85040 5E4CDF00 000C0000 00000000 000E0000 [..L^............]
5FA85050 00000000 000E0000 00000000 000C0000 [................]
5FA85060 00000000 000F0000 00000000 000B0000 [................]
5FA85070 00000000 00100000 00000000 00000000 [................]
5FA85080 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
5FA850A0 4CEF0E3E 00000000 00000000 00000000 [>..L............]
5FA850B0 00000000 00000010 00000000 5FA850BC [.............P._]
5FA850C0 5FA850BC 00000000 00000000 00000000 [.P._............]
5FA850D0 5FA850D0 5FA850D0 00000000 00000000 [.P._.P._........]
5FA850E0 00000000 00000000 00000000 00000000 [................]
5FA850F0 00000000 00000000 00000099 00000021 [............!...]
5FA85100 00000004 00000008 5FA86D5C 5FA84F84 [........\m._.O._]
5FA85110 00010000 00000000 00000000 00000000 [................]
5FA85120 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
5FA85140 00000A18 00000000 00000000 00000000 [................]
5FA85150 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
5FA85180 5FA84F84 00000000 00000000 00000000 [.O._............]
5FA85190 00000000 00000000 00000000 00000000 [................]
Repeat 4 times
5FA851E0 00000001 00000000 00000000 00000000 [................]
5FA851F0 00000000 00000000 4CEF0E3E 5FA851FC [........>..L.Q._]
5FA85200 5FA851FC 00000000 00000000 00000001 [.Q._............]
5FA85210 00000000 00000330 00000844 00000334 [....0...D...4...]
5FA85220 00000A18 D4ACAF20 01CB8D09 4E4F4D53 [.... .......SMON]
5FA85230 00000000 00000000 00000330 00000000 [........0.......]
5FA85240 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
5FA85260 00000000 00000000 0000000B FFFFFFFF [................]
5FA85270 00000000 00000000 00000000 00000000 [................]
Repeat 7 times
5FA852F0 00000000 00000000 54535953 00004D45 [........SYSTEM..]
5FA85300 00000000 00000000 00000000 00000000 [................]
5FA85310 00000000 00000000 00000006 45534D53 [............SMSE]
5FA85320 52455652 00000000 00000000 00000000 [RVER............]
5FA85330 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
5FA85350 00000000 00000000 00000000 00000008 [................]
5FA85360 45534D53 52455652 00000000 00000000 [SMSERVER........]
5FA85370 00000008 34383532 00000000 00000000 [....2584........]
5FA85380 00000000 00000000 00000000 00000004 [................]
5FA85390 4341524F 452E454C 28204558 4E4F4D53 [ORACLE.EXE (SMON]
5FA853A0 00000029 00000000 00000000 00000000 [)...............]
5FA853B0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
5FA853D0 00000011 00000002 00000000 00000000 [................]
5FA853E0 00000000 00000000 00000000 00000000 [................]
Repeat 8 times
5FA85470 00000000 00000000 00000000 00000200 [................]
5FA85480 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
5FA854A0 00000000 00000000 00000000 5FABAE28 [............(.._]
5FA854B0 5FA85AA8 5FA84EB8 00000000 5FC959EC [.Z._.N._.....Y._]
5FA854C0 00000000 00000000 00000000 00000000 [................]
5FA854D0 00000000 00000000 00000000 5FA854DC [.............T._]
5FA854E0 5FA854DC 00050000 00000000 000289E5 [.T._............]
5FA854F0 0004DC55 000789E5 00000000 00006CDC [U............l..]
5FA85500 00000000 00003528 00000000 0000BD24 [....(5......$...]
5FA85510 00000000 00000814 00000000 00000088 [................]
5FA85520 00000000 00000814 00000000 00000000 [................]
5FA85530 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
5FA85570 00000000 00000003 00000000 [............]
error 474 detected in background process
ORA-00474: SMON process terminated with error
 
26.11.2010 12:47  
John Doe
Bug 7662491 - Array Update can corrupt a row. Errors OERI[kghstack_free1] or OERI[kddummy_blkchk][6110] [ID 7662491.8]
Исправлено в 10.2.0.5, хотя мне кажется, что это не то, но другого не предлагается.
Архивлог? Я бы попробовал сделать бекап и открыть с RESETLOGS.
 
01.12.2010 11:14  
horoshko
Ошибки начали появляться гораздо раньше, вот ссылка на лог и трэйсы
 
01.12.2010 13:16  
OlegON
База открылась в итоге? Или народ курит?
 
01.12.2010 16:15  
horoshko
нет не открылась, отправляю сервер в Сервис+
 
02.12.2010 15:44  
horoshko
совсем не знаю oracle? подскажите а как открыть базу с RESETLOGS
 
02.12.2010 16:38  
OlegON
Цитата:
alter database open resetlogs;
если совсем-совсем "не знаю", то лучше отдать тем, кто знает. А то еще существующее угробишь и есть вероятность угробить что-то еще, не заметив. Прежде чем пробовать - сделай бекап всех файлов базы.
 
 


Опции темы



Часовой пояс GMT +3, время: 13:02.

Все в прочитанное - Календарь - RSS - - Карта - Вверх 👫 Яндекс.Метрика
Форум сделан на основе vBulletin®
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Перевод: zCarot и OlegON
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.