09.10.2018 19:31
kamres
 
При попытке обновить данные в таблице через dbForge Studio остановилась база, теперь при запуске выдает:
Код:
ORA-00471: DBWR process terminated with error
База в архивлоге. Как его победить?
в алерте
Код:
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
  processes                = 400
  sessions                 = 445
  timed_statistics         = TRUE
  sga_max_size             = 5368709120
  __shared_pool_size       = 1073741824
  shared_pool_size         = 1073741824
  __large_pool_size        = 1073741824
  large_pool_size          = 1073741824
  __java_pool_size         = 1073741824
  java_pool_size           = 1073741824
  trace_enabled            = FALSE
  control_files            = D:\ORACLE\ORADATA\KAMAVTO\CONTROL01.CTL, D:\ORACLE\ORADATA\KAMAVTO\CONTROL02.CTL, D:\ORACLE\ORADATA\KAMAVTO\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 1073741824
  db_cache_size            = 1073741824
  db_recycle_cache_size    = 67108864
  db_cache_advice          = OFF
  compatible               = 10.2.0.3.0
  log_archive_start        = TRUE
  db_recovery_file_dest    = E:\backup_log
  db_recovery_file_dest_size= 966367641600
  fast_start_mttr_target   = 600
  transactions_per_rollback_segment= 1
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  recyclebin               = off
  O7_DICTIONARY_ACCESSIBILITY= TRUE
  remote_login_passwordfile= EXCLUSIVE
  audit_sys_operations     = FALSE
  db_domain                = 
  instance_name            = KAMAVTO
  job_queue_processes      = 10
  background_dump_dest     = D:\ORACLE\ADMIN\KAMAVTO\BDUMP
  user_dump_dest           = D:\ORACLE\ADMIN\KAMAVTO\UDUMP
  max_dump_file_size       = 5000000
  core_dump_dest           = D:\ORACLE\ADMIN\KAMAVTO\CDUMP
  commit_write             = batch,nowait
  optimizer_features_enable= 10.2.0.4
  audit_trail              = XML
  sort_area_size           = 4194304
  db_name                  = KAMAVTO
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  query_rewrite_integrity  = stale_tolerated
  pga_aggregate_target     = 1048576000
  optimizer_dynamic_sampling= 2
Deprecated system parameters with specified values:
  log_archive_start        
End of deprecated system parameter listing
PMON started with pid=2, OS id=5508
PSP0 started with pid=4, OS id=3368
MMAN started with pid=6, OS id=5520
DBW0 started with pid=8, OS id=4952
DBW1 started with pid=10, OS id=3176
LGWR started with pid=12, OS id=3604
CKPT started with pid=14, OS id=5676
SMON started with pid=16, OS id=5688
RECO started with pid=18, OS id=5416
CJQ0 started with pid=20, OS id=2616
MMON started with pid=22, OS id=3732
MMNL started with pid=24, OS id=6112
Tue Oct 09 18:48:02 2018
alter database mount exclusive
Tue Oct 09 18:48:06 2018
Setting recovery target incarnation to 1
Tue Oct 09 18:48:06 2018
Successful mount of redo thread 1, with mount id 377811490
Tue Oct 09 18:48:06 2018
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Oct 09 18:48:06 2018
alter database open
Tue Oct 09 18:48:06 2018
Beginning crash recovery of 1 threads
 parallel recovery started with 15 processes
Tue Oct 09 18:48:06 2018
Started redo scan
Tue Oct 09 18:48:07 2018
Completed redo scan
 54948 redo blocks read, 4095 data blocks need recovery
Tue Oct 09 18:48:08 2018
Started redo application at
 Thread 1: logseq 324781, block 92874
Tue Oct 09 18:48:08 2018
Recovery of Online Redo Log: Thread 1 Group 1 Seq 324781 Reading mem 0
  Mem# 0: D:\ORACLE\ORADATA\KAMAVTO\REDO01.LOG
Tue Oct 09 18:48:08 2018
Recovery of Online Redo Log: Thread 1 Group 2 Seq 324782 Reading mem 0
  Mem# 0: D:\ORACLE\ORADATA\KAMAVTO\REDO02.LOG
Tue Oct 09 18:48:08 2018
Completed redo application
Tue Oct 09 18:48:08 2018
Hex dump of (file 9, block 59382) in trace file d:\oracle\admin\kamavto\bdump\kamavto_dbw0_4952.trc
Corrupt block relative dba: 0x0240e7f6 (file 9, block 59382)
Bad header found during preparing block for write
Data in bad block:
 type: 6 format: 2 rdba: 0x0240e7f6
 last change scn: 0x0001.0eb628d8 seq: 0x2 flg: 0x28
 spare1: 0x0 spare2: 0x0 spare3: 0x540e
 consistency value in tail: 0x28d80602
 check value in block header: 0x0
 block checksum disabled
Tue Oct 09 18:48:09 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_dbw0_4952.trc:
ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], []

Tue Oct 09 18:48:09 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_dbw0_4952.trc:
ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], []

DBW0: terminating instance due to error 471
Tue Oct 09 18:48:09 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p014_4676.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:09 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p013_980.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:09 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p012_584.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:09 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p011_5700.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:10 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p010_6044.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:10 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p009_4592.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:10 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p008_2152.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:10 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p007_4488.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:10 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p002_3936.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:10 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p000_5588.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:10 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p001_3408.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:11 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_pmon_5508.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:11 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p004_4588.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:11 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_psp0_3368.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:11 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_mman_5520.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:11 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_ckpt_5676.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:11 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_dbw1_3176.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:11 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_lgwr_3604.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:12 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p003_5956.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:13 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p005_5872.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:14 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_p006_5272.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:14 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_reco_5416.trc:
ORA-00471: DBWR process terminated with error

Tue Oct 09 18:48:14 2018
Errors in file d:\oracle\admin\kamavto\bdump\kamavto_smon_5688.trc:
ORA-00471: DBWR process terminated with error
сейчас статус
Код:
INSTANCE_NAME    STATUS
---------------- ------------
kamavto          MOUNTED
при попытке startup open;
Код:
SQL> startup open;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 5368709120 bytes
Fixed Size                  2171616 bytes
Variable Size            4221361440 bytes
Database Buffers         1140850688 bytes
Redo Buffers                4325376 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
судя по всему не смог записать
Код:
Hex dump of (file 9, block 59382) in trace file d:\oracle\admin\kamavto\bdump\kamavto_dbw1_4188.trc
Corrupt block relative dba: 0x0240e7f6 (file 9, block 59382)
Bad header found during preparing block for write
Data in bad block:
 type: 6 format: 2 rdba: 0x0240e7f6
 last change scn: 0x0001.0eb628d8 seq: 0x2 flg: 0x28
 spare1: 0x0 spare2: 0x0 spare3: 0x540e
 consistency value in tail: 0x28d80602
 check value in block header: 0x0
 block checksum disabled
09.10.2018 20:36
OlegON
 
Оптимизатор используешь? Почему не смог записать-то?
09.10.2018 20:43
kamres
 
Оптимизатор не использую, не записал похоже что dbForge Studio очень много пытался записать.
09.10.2018 22:43
OlegON
 
нет, это, скорее, с дисками голяк, либо винда или антивирусы... ищи сначала, что с винтами...
10.10.2018 08:22
kamres
 
Видимых проблем с дисками нет, в журналах винды ошибок нет, антивируса нет, восстановил так:

https://olegon.ru/https://olegon.ru/showthread.php?t=14917

Цитата:
Stels восстановил всё по тем же путям
а дальше:
Код:
startup mount;
alter database recover automatic database using backup controlfile until cancel;
alter database recover cancel;
alter database open resetlogs;

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