powered by simpleCommunicator - 2.0.61     © 2026 Programmizd 02
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Форумы / Oracle [игнор отключен] [закрыт для гостей] / База восстанавливается и сразу падает
8 сообщений из 8, страница 1 из 1
База восстанавливается и сразу падает
    #39361873
freesteel
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
Starting background process CJQ0
Wed Dec 07 16:00:10 2016
CJQ0 started with pid=27, OS id=5324
Wed Dec 07 16:00:12 2016
db_recovery_file_dest_size of 3852 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Dec 07 16:00:16 2016
Sweep [inc][547379]: completed
Sweep [inc2][547379]: completed
Wed Dec 07 16:00:19 2016
Errors in file c:\oracle\diag\rdbms\BDSOL\BDSOL\trace\BDSOL_j002_5508.trc (incident=547467):
ORA-00600: internal error code, arguments: [4193], [], [
Incident details in: c:\oracle\diag\rdbms\BDSOL\BDSOL\incident\incdir_547467\BDSOL_j002_5508_i547467.trc
Wed Dec 07 16:00:27 2016
Trace dumping is performing id=[cdmp_20161207160027]
Wed Dec 07 16:00:34 2016
Doing block recovery for file 3 block 2870
Resuming block recovery (PMON) for file 3 block 2870
Block recovery from logseq 2, block 63 to scn 103670612
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
Mem# 0: C:\ORACLE\ORADATA\BDSOL\REDO02.LOG
Block recovery completed at rba 2.68.16, scn 0.103670614
Doing block recovery for file 3 block 160
Resuming block recovery (PMON) for file 3 block 160
Block recovery from logseq 2, block 63 to scn 103670713
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
Mem# 0: C:\ORACLE\ORADATA\BDSOL\REDO02.LOG
Block recovery completed at rba 2.194.16, scn 0.103670714
Errors in file c:\oracle\diag\rdbms\BDSOL\BDSOL\trace\BDSOL_j002_5508.trc (incident=547468):
ORA-00600: internal error code, arguments: [600], [ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], [], []
Incident details in: c:\oracle\diag\rdbms\BDSOL\BDSOL\incident\incdir_547468\BDSOL_j002_5508_i547468.trc
Errors in file c:\oracle\diag\rdbms\BDSOL\BDSOL\trace\BDSOL_j002_5508.trc:
ORA-00600: internal error code, arguments: [600], [ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], [], []
Wed Dec 07 16:00:39 2016
Trace dumping is performing id=[cdmp_20161207160039]
Wed Dec 07 16:00:44 2016
Errors in file c:\oracle\diag\rdbms\BDSOL\BDSOL\trace\BDSOL_j000_5488.trc (incident=547427):
ORA-00600: internal error code, arguments: [4193], [], [
Incident details in: c:\oracle\diag\rdbms\BDSOL\BDSOL\incident\incdir_547427\BDSOL_j000_5488_i547427.trc
Trace dumping is performing id=[cdmp_20161207160048]
Doing block recovery for file 3 block 2870
Resuming block recovery (PMON) for file 3 block 2870
Block recovery from logseq 2, block 63 to scn 103670612
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
Mem# 0: C:\ORACLE\ORADATA\BDSOL\REDO02.LOG
Block recovery completed at rba 2.68.16, scn 0.103670614
Doing block recovery for file 3 block 160
Resuming block recovery (PMON) for file 3 block 160
Block recovery from logseq 2, block 63 to scn 103670801
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
Mem# 0: C:\ORACLE\ORADATA\BDSOL\REDO02.LOG
Block recovery completed at rba 2.375.16, scn 0.103670804
Errors in file c:\oracle\diag\rdbms\BDSOL\BDSOL\trace\BDSOL_j000_5488.trc:
ORA-12012: error on auto execute of job 4895
ORA-12048: error encountered while refreshing materialized view "VOSHOD"."VI_OBSHOB"
ORA-00600: internal error code, arguments: [4193], [], [
...
Рейтинг: 0 / 0
База восстанавливается и сразу падает
    #39361881
поисковик.
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
freesteel, google не работает?
...
Рейтинг: 0 / 0
База восстанавливается и сразу падает
    #39361883
freesteel
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
Completed: alter database open resetlogs
Mem# 0: C:\ORACLE\ORADATA\BDSOL\REDO01.LOG
Block recovery completed at rba 1.103.16, scn 0.103671249
Errors in file c:\oracle\diag\rdbms\BDSOL\BDSOL\trace\BDSOL_mmon_4476.trc (incident=548608):
ORA-00600: internal error code, arguments: [kewrose_1], [600], [ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Incident details in: c:\oracle\diag\rdbms\BDSOL\BDSOL\incident\incdir_548608\BDSOL_mmon_4476_i548608.trc
Trace dumping is performing id=[cdmp_20161207161038]
Wed Dec 07 16:10:40 2016
db_recovery_file_dest_size of 3852 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x4AAB0E0B] [PC:0x6D11343, 06D11343]
Dump file c:\oracle\diag\rdbms\BDSOL\BDSOL\trace\alert_BDSOL.log
Wed Dec 07 16:10:40 2016
ORACLE V11.2.0.1.0 - Production vsnsta=0
vsnsql=16 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU : 4 - type 586, 4 Physical Cores
Process Affinity : 0x0x00000000
Memory (Avail/Total): Ph:1036M/2986M, Ph+PgF:2938M/7080M, VA:821M/2047M
Wed Dec 07 16:10:40 2016
Errors in file
ORA-07445: caught exception [ACCESS_VIOLATION] at [06D11343] [0x06D11343]
space available in the underlying filesystem or ASM diskgroup.
Wed Dec 07 16:10:49 2016
Doing block recovery for file 3 block 2870
Resuming block recovery (PMON) for file 3 block 2870
Block recovery from logseq 1, block 75 to scn 103671224
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
Mem# 0: C:\ORACLE\ORADATA\BDSOL\REDO01.LOG
...
Рейтинг: 0 / 0
База восстанавливается и сразу падает
    #39361885
freesteel
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
Block recovery completed at rba 1.81.16, scn 0.103671225
Doing block recovery for file 3 block 160
Resuming block recovery (PMON) for file 3 block 160
Block recovery from logseq 1, block 75 to scn 103671278
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
Mem# 0: C:\ORACLE\ORADATA\BDSOL\REDO01.LOG
Block recovery completed at rba 1.148.16, scn 0.103671279
Restarting dead background process MMON
Wed Dec 07 16:10:51 2016
MMON started with pid=15, OS id=5868
Wed Dec 07 16:11:33 2016
Sweep [inc][548608]: completed
Sweep [inc][548607]: completed
Sweep [inc2][548608]: completed
Sweep [inc2][548607]: completed
Wed Dec 07 16:12:30 2016
Errors in file c:\oracle\diag\rdbms\BDSOL\BDSOL\trace\BDSOL_ora_3060.trc (incident=548671):
ORA-00600: internal error code, arguments: [4193], [], [
Incident details in: c:\oracle\diag\rdbms\BDSOL\BDSOL\incident\incdir_548671\BDSOL_ora_3060_i548671.trc
Doing block recovery for file 3 block 2870
Resuming block recovery (PMON) for file 3 block 2870
Block recovery from logseq 1, block 75 to scn 103671224
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
Mem# 0: C:\ORACLE\ORADATA\BDSOL\REDO01.LOG
Block recovery completed at rba 1.81.16, scn 0.103671225
Doing block recovery for file 3 block 160
Resuming block recovery (PMON) for file 3 block 160
Block recovery from logseq 1, block 75 to scn 103671333
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
Mem# 0: C:\ORACLE\ORADATA\BDSOL\REDO01.LOG
Wed Dec 07 16:12:33 2016
Trace dumping is performing id=[cdmp_20161207161233]
Block recovery completed at rba 1.184.16, scn 0.103671334
Wed Dec 07 16:12:34 2016
Sweep [inc][548671]: completed
Sweep [inc2][548671]: completed
Wed Dec 07 16:12:50 2016
Errors in file c:\oracle\diag\rdbms\BDSOL\BDSOL\trace\BDSOL_ora_4928.trc (incident=548672):
ORA-00600: internal error code, arguments: [4193], [], [
Incident details in: c:\oracle\diag\rdbms\BDSOL\BDSOL\incident\incdir_548672\BDSOL_ora_4928_i548672.trc
Doing block recovery for file 3 block 2870
Resuming block recovery (PMON) for file 3 block 2870
Wed Dec 07 16:12:51 2016
Trace dumping is performing id=[cdmp_20161207161251]
Block recovery from logseq 1, block 75 to scn 103671224
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
Mem# 0: C:\ORACLE\ORADATA\BDSOL\REDO01.LOG
Block recovery completed at rba 1.81.16, scn 0.103671225
Doing block recovery for file 3 block 160
...
Рейтинг: 0 / 0
База восстанавливается и сразу падает
    #39361891
freesteel
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
Block recovery from logseq 1, block 75 to scn 103671350
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
Mem# 0: C:\ORACLE\ORADATA\BDSOL\REDO01.LOG
Block recovery completed at rba 1.201.16, scn 0.103671351
Wed Dec 07 16:13:34 2016
Sweep [inc][548672]: completed
Sweep [inc2][548672]: completed
Wed Dec 07 16:13:40 2016
Starting background process CJQ0
Wed Dec 07 16:13:40 2016
CJQ0 started with pid=23, OS id=5544
Wed Dec 07 16:13:43 2016
Errors in file c:\oracle\diag\rdbms\BDSOL\BDSOL\trace\BDSOL_j006_2856.trc (incident=548727):
ORA-00600: internal error code, arguments: [4193], [], [
Incident details in: c:\oracle\diag\rdbms\BDSOL\BDSOL\incident\incdir_548727\BDSOL_j006_2856_i548727.trc
Wed Dec 07 16:13:45 2016
Doing block recovery for file 3 block 2870
Resuming block recovery (PMON) for file 3 block 2870
Block recovery from logseq 1, block 75 to scn 103671224
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
Mem# 0: C:\ORACLE\ORADATA\BDSOL\REDO01.LOG
Wed Dec 07 16:13:45 2016
Trace dumping is performing id=[cdmp_20161207161345]
Block recovery completed at rba 1.81.16, scn 0.103671225
Errors in file c:\oracle\diag\rdbms\BDSOL\BDSOL\trace\BDSOL_j009_3044.trc (incident=548751):
ORA-00600: internal error code, arguments: [4193], [], [
Errors in file c:\oracle\diag\rdbms\BDSOL\BDSOL\trace\BDSOL_j009_3044.trc:
ORA-00600: internal error code, arguments: [4193], [], [
...
Рейтинг: 0 / 0
База восстанавливается и сразу падает
    #39361893
freesteel
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
вот что нашел ORA-00600: internal error code, arguments: [4193], [a], [b]

Аргументы:

[a] – Номер изменения (SCN) записи в серменте отката (Undo), [b] SCN записи в журнале повторного выполнения (Redo)

Последствия:

Сбой процесса, возможное повреждение сегмента отката, невозможность продолжения наката журналов на STANDBY.
Причины возникновения:

Было обнаружено несоответствие между журнальной записью и записью в сегменте отката.

Действия:

Перейти на новую версию Oracle (10.2.0.5, 11.2.0.1); Восстановить экземпляр из резервной копии. происходит в 11ой версии
...
Рейтинг: 0 / 0
База восстанавливается и сразу падает
    #39361897
Фотография env
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
freesteelORA-00600

С этим прямой путь на заведение SR в рамках оплаченной вами поддержки вендором.
...
Рейтинг: 0 / 0
База восстанавливается и сразу падает
    #39362037
Фотография Rinka777
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
авторDoing block recovery for file 3

я одна это вижу?
...
Рейтинг: 0 / 0
8 сообщений из 8, страница 1 из 1
Форумы / Oracle [игнор отключен] [закрыт для гостей] / База восстанавливается и сразу падает
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]