Форум OlegON > Компьютеры и Программное обеспечение > Операционные системы и программное обеспечение > Oracle

ORA-00600: ??? ?????. ??????, ?????????: [ktpridestroy2], [], [], [], [], [], [], [] : Oracle

28.03.2024 17:29


16.02.2021 17:56
Nik_75
 
Доброго времени суток. После внезапного отключения сервера не запускается БД, с ошибкой:

ORA-00600: ??? ?????. ??????, ?????????: [ktpridestroy2], [], [], [], [], [], [], []
Погуглив инет, нашел решение установив параметр:
Alter system set fast_start_parallel_rollback = false;
База открывается но не надолго. Валится с ошибкой:
ORA-00600: код внутр. ошибки, аргументы: [4137], [], [], [], [], [], [], []

Прогонял оптимайзером, но не помогло. Может кто сталкивался с подобным?

Версия oracle 10.2.0.4.0.
16.02.2021 17:59
Nik_75
 
alert_log:


Tue Feb 16 23:07:58 2021
Instance terminated by PMON, pid = 26816
Dump file d:\oracle\product\10.2.0\admin\privozin\bdump\alert_privozin.log
Tue Feb 16 23:47:03 2021
ORACLE V10.2.0.4.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.0 Service Pack 2
CPU : 4 - type 586, 4 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:6367M/8182M, Ph+PgF:14847M/16595M, VA:1887M/2047M
Tue Feb 16 23:47:03 2021
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
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
timed_statistics = TRUE
sga_max_size = 922746880
__shared_pool_size = 293601280
shared_pool_size = 293601280
__large_pool_size = 12582912
large_pool_size = 12582912
__java_pool_size = 25165824
__streams_pool_size = 0
shared_pool_reserved_size= 20971520
trace_enabled = FALSE
nls_language = RUSSIAN
nls_territory = RUSSIA
control_files = D:\ORACLE\ORADATA\PRIVOZIN\PRIVOZIN\CONTROL01.CTL, D:\ORACLE\ORADATA\PRIVOZIN\PRIVOZIN\CONTROL02.CTL, D:\ORACLE\ORADATA\PRIVOZIN\PRIVOZIN\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 50331648
db_cache_advice = OFF
compatible = 10.2.0.3.0
_db_file_noncontig_mblock_read_count= 0
db_recovery_file_dest = D:\FRA
db_recovery_file_dest_size= 562281840640
fast_start_mttr_target = 600
_allow_resetlogs_corruption= TRUE
transactions_per_rollback_segment= 1
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
fast_start_parallel_rollback= FALSE
recyclebin = off
O7_DICTIONARY_ACCESSIBILITY= TRUE
remote_login_passwordfile= EXCLUSIVE
audit_sys_operations = FALSE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=PRIVOZINXDB)
session_cached_cursors = 500
job_queue_processes = 2
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PRIVOZIN\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PRIVOZIN\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PRIVOZIN\UDUMP
max_dump_file_size = 5000000
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PRIVOZIN\CDUMP
commit_write = batch,nowait
optimizer_features_enable= 10.2.0.4
audit_trail = DB
db_name = PRIVOZIN
open_cursors = 300
query_rewrite_integrity = stale_tolerated
pga_aggregate_target = 33554432
PMON started with pid=2, OS id=28244
PSP0 started with pid=3, OS id=26988
MMAN started with pid=4, OS id=28196
DBW0 started with pid=5, OS id=28368
LGWR started with pid=6, OS id=26996
CKPT started with pid=7, OS id=27600
SMON started with pid=8, OS id=28620
RECO started with pid=9, OS id=20120
CJQ0 started with pid=10, OS id=27512
MMON started with pid=11, OS id=27500
Tue Feb 16 23:47:03 2021
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=27660
Tue Feb 16 23:47:03 2021
starting up 1 shared server(s) ...
Tue Feb 16 23:47:03 2021
alter database mount exclusive
Tue Feb 16 23:47:07 2021
Setting recovery target incarnation to 2
Tue Feb 16 23:47:08 2021
Successful mount of redo thread 1, with mount id 2233886839
Tue Feb 16 23:47:08 2021
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Feb 16 23:47:08 2021
alter database open
Tue Feb 16 23:47:08 2021
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Tue Feb 16 23:47:08 2021
Started redo scan
Tue Feb 16 23:47:09 2021
Completed redo scan
79124 redo blocks read, 853 data blocks need recovery
Tue Feb 16 23:47:10 2021
Started redo application at
Thread 1: logseq 12988, block 221952
Tue Feb 16 23:47:11 2021
Recovery of Online Redo Log: Thread 1 Group 6 Seq 12988 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\PRIVOZIN\PRIVOZIN\REDO03.LOG6+.DBF
Tue Feb 16 23:47:13 2021
Completed redo application
Tue Feb 16 23:47:13 2021
Completed crash recovery at
Thread 1: logseq 12988, block 301076, scn 2927424360
853 data blocks read, 853 data blocks written, 79124 redo blocks read
Tue Feb 16 23:47:14 2021
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=19, OS id=26848
Tue Feb 16 23:47:14 2021
ARC0: Archival started
ARC1: Archival started
ARC1 started with pid=20, OS id=28480
Tue Feb 16 23:47:14 2021
LGWR: STARTING ARCH PROCESSES COMPLETE
Tue Feb 16 23:47:14 2021
Thread 1 advanced to log sequence 12989 (thread open)
Thread 1 opened at log sequence 12989
Current log# 4 seq# 12989 mem# 0: D:\ORACLE\ORADATA\PRIVOZIN\PRIVOZIN\REDO01.LOG4+.DBF
Successful open of redo thread 1
Tue Feb 16 23:47:14 2021
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Tue Feb 16 23:47:14 2021
ARC1: Becoming the heartbeat ARCH
Tue Feb 16 23:47:14 2021
SMON: enabling cache recovery
Tue Feb 16 23:47:14 2021
db_recovery_file_dest_size of 536233 MB is 23.78% 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.
Tue Feb 16 23:47:16 2021
Successfully onlined Undo Tablespace 1.
Tue Feb 16 23:47:16 2021
SMON: enabling tx recovery
Tue Feb 16 23:47:17 2021
Database Characterset is CL8MSWIN1251
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 4
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=26, OS id=27508
Tue Feb 16 23:47:30 2021
Completed: alter database open
Tue Feb 16 23:47:38 2021
Errors in file d:\oracle\product\10.2.0\admin\privozin\bdump\privozin_smon_28620.trc:
ORA-00600: код внутр. ошибки, аргументы: [4137], [], [], [], [], [], [], []

Tue Feb 16 23:47:39 2021
ORACLE Instance privozin (pid = 8) - Error 600 encountered while recovering transaction (1, 3).
Tue Feb 16 23:47:39 2021
Errors in file d:\oracle\product\10.2.0\admin\privozin\bdump\privozin_smon_28620.trc:
ORA-00600: код внутр. ошибки, аргументы: [4137], [], [], [], [], [], [], []

Tue Feb 16 23:49:44 2021
MMAN: Can't zero buffer pool DEFAULT for blocksize 8192
Tue Feb 16 23:49:44 2021
ALTER SYSTEM SET sga_target='922746880' SCOPE=MEMORY;
Tue Feb 16 23:49:44 2021
ALTER SYSTEM SET undo_retention=1800 SCOPE=MEMORY;
Tue Feb 16 23:49:44 2021
ALTER SYSTEM SET open_cursors=500 SCOPE=MEMORY;
Tue Feb 16 23:49:45 2021
ALTER SYSTEM SET parallel_max_servers=4 SCOPE=MEMORY;
Tue Feb 16 23:49:45 2021
ALTER SYSTEM SET parallel_threads_per_cpu=1 SCOPE=MEMORY;
Tue Feb 16 23:49:45 2021
ALTER SYSTEM SET job_queue_processes=30 SCOPE=MEMORY;
Tue Feb 16 23:49:45 2021
ALTER SYSTEM SET pga_aggregate_target='599785472' SCOPE=MEMORY;
Tue Feb 16 23:49:49 2021
ALTER SYSTEM SET db_cache_size='352321536' SCOPE=MEMORY;
Tue Feb 16 23:50:25 2021
Errors in file d:\oracle\product\10.2.0\admin\privozin\bdump\privozin_smon_28620.trc:
ORA-00600: код внутр. ошибки, аргументы: [4137], [], [], [], [], [], [], []

Tue Feb 16 23:50:26 2021
ORACLE Instance privozin (pid = 8) - Error 600 encountered while recovering transaction (1, 3).
Tue Feb 16 23:50:27 2021
Errors in file d:\oracle\product\10.2.0\admin\privozin\bdump\privozin_smon_28620.trc:
ORA-00600: код внутр. ошибки, аргументы: [4137], [], [], [], [], [], [], []

Tue Feb 16 23:51:39 2021
ORA-01555 caused by SQL statement below (SQL ID: 54ajgt9g74vyh, Query Duration=1 sec, SCN: 0x0000.ae7d8d2c):
Tue Feb 16 23:51:39 2021
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*) from "SYS"."WRH$_SQLTEXT" t
Tue Feb 16 23:53:38 2021
Errors in file d:\oracle\product\10.2.0\admin\privozin\bdump\privozin_smon_28620.trc:
ORA-00600: код внутр. ошибки, аргументы: [4137], [], [], [], [], [], [], []

Tue Feb 16 23:53:38 2021
ORACLE Instance privozin (pid = 8) - Error 600 encountered while recovering transaction (1, 3).
Tue Feb 16 23:53:38 2021
Errors in file d:\oracle\product\10.2.0\admin\privozin\bdump\privozin_smon_28620.trc:
ORA-00600: код внутр. ошибки, аргументы: [4137], [], [], [], [], [], [], []
16.02.2021 18:27
OlegON
 
попробуй
undo_management = manual
и пересоздать UNDO-tablespace...
если не прокатит - вариант переместить все файлы БД куда-то и восстановить ее из бекапа оптимизатором, я тут писал, как...
16.02.2021 18:37
OlegON
 
и, да, 10 уже не рекомендую... только там, где Супермаг совсем древней версии и точно не будет обновляться. впрочем, не рекомендую и Windows... при любых проблемах с базой ее нужно ребутнуть в первую очередь и делать это регулярно.
Часовой пояс GMT +3, время: 17:29.

Форум на базе vBulletin®
Copyright © Jelsoft Enterprises Ltd.
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.