БД не в режиме archivelog
Архивов нет.
Ругается на битый блок ORA-01578: ORACLE data block corrupted (file # 1, block # 498)
Как его реанимировать или обойти?
Mon Oct 22 10:21:07 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 159383552
large_pool_size = 8388608
java_pool_size = 0
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 = 629145600
compatible = 9.2.0.0.0
log_buffer = 104857600
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
_allow_resetlogs_corruption= TRUE
transactions_per_rollback_segment= 1
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
O7_DICTIONARY_ACCESSIBILITY= TRUE
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = KAMAVTO
job_queue_processes = 5
hash_join_enabled = TRUE
background_dump_dest = d:\oracle\admin\KAMAVTO\bdump
user_dump_dest = d:\oracle\admin\KAMAVTO\udump
core_dump_dest = d:\oracle\admin\KAMAVTO\cdump
sort_area_size = 4194304
db_name = KAMAVTO
open_cursors = 300
star_transformation_enabled= FALSE
parallel_automatic_tuning= TRUE
query_rewrite_enabled = FALSE
pga_aggregate_target = 209715200
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Mon Oct 22 10:21:09 2007
/* OracleOEM */ ALTER DATABASE MOUNT
Mon Oct 22 10:21:13 2007
Successful mount of redo thread 1, with mount id 25331413.
Mon Oct 22 10:21:13 2007
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Mon Oct 22 10:22:22 2007
/* OracleOEM */ ALTER DATABASE OPEN
Mon Oct 22 10:22:22 2007
Beginning crash recovery of 1 threads
Mon Oct 22 10:22:22 2007
Started first pass scan
Mon Oct 22 10:22:22 2007
Completed first pass scan
31 redo blocks read, 7 data blocks need recovery
Mon Oct 22 10:22:22 2007
Started recovery at
Thread 1: logseq 28, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 28 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\KAMAVTO\REDO02.LOG
Mon Oct 22 10:22:23 2007
Ended recovery at
Thread 1: logseq 28, block 34, scn 0.52774905
7 data blocks read, 7 data blocks written, 31 redo blocks read
Crash recovery completed successfully
Mon Oct 22 10:22:23 2007
Thread 1 advanced to log sequence 29
Thread 1 opened at log sequence 29
Current log# 1 seq# 29 mem# 0: D:\ORACLE\ORADATA\KAMAVTO\REDO01.LOG
Successful open of redo thread 1.
Mon Oct 22 10:22:23 2007
SMON: enabling cache recovery
Mon Oct 22 10:22:23 2007
Undo Segment 1 Onlined
Successfully onlined Undo Tablespace 1.
Mon Oct 22 10:22:23 2007
SMON: enabling tx recovery
Mon Oct 22 10:22:23 2007
Database Characterset is CL8MSWIN1251
Updating 9.2.0.7.0 NLS parameters in sys.props$
-- adding 9.2.0.1.0 NLS parameters.
Mon Oct 22 10:22:23 2007
SMON: about to recover undo segment 2
SMON: mark undo segment 2 as needs recovery
SMON: about to recover undo segment 3
SMON: mark undo segment 3 as needs recovery
SMON: about to recover undo segment 4
SMON: mark undo segment 4 as needs recovery
SMON: about to recover undo segment 5
SMON: mark undo segment 5 as needs recovery
SMON: about to recover undo segment 6
SMON: mark undo segment 6 as needs recovery
SMON: about to recover undo segment 7
SMON: mark undo segment 7 as needs recovery
SMON: about to recover undo segment 8
SMON: mark undo segment 8 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 10
SMON: mark undo segment 10 as needs recovery
Undo Segment 1 Onlined
Mon Oct 22 10:22:24 2007
Undo Segment 1 Onlined
Undo Segment 1 Onlined
Undo Segment 1 Onlined
Undo Segment 1 Onlined
Undo Segment 1 Onlined
Undo Segment 1 Onlined
Undo Segment 1 Onlined
Undo Segment 1 Onlined
Undo Segment 1 Onlined
Mon Oct 22 10:22:25 2007
SMON: about to recover undo segment 2
SMON: mark undo segment 2 as needs recovery
SMON: about to recover undo segment 3
SMON: mark undo segment 3 as needs recovery
SMON: about to recover undo segment 4
SMON: mark undo segment 4 as needs recovery
SMON: about to recover undo segment 5
SMON: mark undo segment 5 as needs recovery
SMON: about to recover undo segment 6
SMON: mark undo segment 6 as needs recovery
SMON: about to recover undo segment 7
SMON: mark undo segment 7 as needs recovery
SMON: about to recover undo segment 8
SMON: mark undo segment 8 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 10
SMON: mark undo segment 10 as needs recovery
Mon Oct 22 10:22:25 2007
Errors in file d:\oracle\admin\kamavto\udump\kamavto_ora_3296.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 498)
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\KAMAVTO\SYSTEM01.DBF'
Mon Oct 22 10:22:25 2007
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 3296
ORA-1092 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ...