|
|
|
База восстанавливается и сразу падает
|
|||
|---|---|---|---|
|
#18+
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], [], [ ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.12.2016, 15:05 |
|
||
|
База восстанавливается и сразу падает
|
|||
|---|---|---|---|
|
#18+
freesteel, google не работает? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.12.2016, 15:11 |
|
||
|
База восстанавливается и сразу падает
|
|||
|---|---|---|---|
|
#18+
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 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.12.2016, 15:15 |
|
||
|
База восстанавливается и сразу падает
|
|||
|---|---|---|---|
|
#18+
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 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.12.2016, 15:16 |
|
||
|
База восстанавливается и сразу падает
|
|||
|---|---|---|---|
|
#18+
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], [], [ ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.12.2016, 15:18 |
|
||
|
База восстанавливается и сразу падает
|
|||
|---|---|---|---|
|
#18+
вот что нашел 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ой версии ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.12.2016, 15:20 |
|
||
|
База восстанавливается и сразу падает
|
|||
|---|---|---|---|
|
#18+
freesteelORA-00600 С этим прямой путь на заведение SR в рамках оплаченной вами поддержки вендором. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 07.12.2016, 15:22 |
|
||
|
|

start [/forum/topic.php?fid=52&fpage=186&tid=1886873]: |
0ms |
get settings: |
7ms |
get forum list: |
18ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
60ms |
get topic data: |
23ms |
get forum data: |
3ms |
get page messages: |
62ms |
get tp. blocked users: |
2ms |
| others: | 207ms |
| total: | 388ms |

| 0 / 0 |
