vsn服务器 需要先建项目才能,急求!项目马上上线,但是Oracle服务器存在问题...

说实话自己刚接触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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值