说实话自己刚接触oracle,对于日志的问题也不清楚,贴出来大家帮忙看看
Errors in file e:\oracle\admin\fexch\bdump\fexch_lgwr_796.trc:
ORA-00345: redo log write error block 31188 count 2
ORA-00312: online log 2 thread 1: 'E:\ORACLE\ORADATA\FEXCH\REDO02.LOG'
ORA-27070: skgfdisp: async read/write failed
OSD-04016: 异步 I/O 请求排队时出错。
O/S-Error: (OS 23) 数据错误 (循环冗余检查)。
Wed Aug 20 11:53:45 2008
Errors in file e:\oracle\admin\fexch\bdump\fexch_lgwr_796.trc:
ORA-00340: IO error processing online log 2 of thread 1
ORA-00345: redo log write error block 31188 count 2
ORA-00312: online log 2 thread 1: 'E:\ORACLE\ORADATA\FEXCH\REDO02.LOG'
ORA-27070: skgfdisp: async read/write failed
OSD-04016: 异步 I/O 请求排队时出错。
O/S-Error: (OS 23) 数据错误 (循环冗余检查)。
LGWR: terminating instance due to error 340
Instance terminated by LGWR, pid = 796
Dump file e:\oracle\admin\fexch\bdump\alert_fexch.log
Wed Aug 20 13:34:15 2008
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Wed Aug 20 13:34:15 2008
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 = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = E:\oracle\oradata\fexch\CONTROL01.CTL, E:\oracle\oradata\fexch\CONTROL02.CTL, E:\oracle\oradata\fexch\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = fexch
dispatchers = (PROTOCOL=TCP) (SERVICE=fexchXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = E:\oracle\admin\fexch\bdump
user_dump_dest = E:\oracle\admin\fexch\udump
core_dump_dest = E:\oracle\admin\fexch\cdump
sort_area_size = 524288
db_name = fexch
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
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
QMN0 started with pid=9
Wed Aug 20 13:34:17 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Aug 20 13:34:18 2008
alter database mount exclusive
Wed Aug 20 13:34:23 2008
Successful mount of redo thread 1, with mount id 3026251610.
Wed Aug 20 13:34:23 2008
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Aug 20 13:34:23 2008
alter database open
Wed Aug 20 13:34:23 2008
Beginning crash recovery of 1 threads
Wed Aug 20 13:34:23 2008
Started first pass scan
Wed Aug 20 13:34:25 2008
Completed first pass scan
3558 redo blocks read, 69 data blocks need recovery
Wed Aug 20 13:34:25 2008
Started recovery at
Thread 1: logseq 63, block 27630, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 63 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\ORADATA\FEXCH\REDO02.LOG
Wed Aug 20 13:34:26 2008
Ended recovery at
Thread 1: logseq 63, block 31188, scn 0.13352790
69 data blocks read, 69 data blocks written, 3558 redo blocks read
Crash recovery completed successfully
Wed Aug 20 13:34:27 2008
Thread 1 advanced to log sequence 64
Thread 1 opened at log sequence 64
Current log# 3 seq# 64 mem# 0: E:\ORACLE\ORADATA\FEXCH\REDO03.LOG
Successful open of redo thread 1.
Wed Aug 20 13:34:27 2008
SMON: enabling cache recovery
Wed Aug 20 13:34:28 2008
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Wed Aug 20 13:34:28 2008
SMON: enabling tx recovery
Wed Aug 20 13:34:28 2008
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open