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

素颜马尾好姑娘i 2022-09-04 01:52 9阅读 0赞

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

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

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关为什么web项目要打包才能部署到服务器上呢?

相关项目上传svn 服务器

相关 SpringBoot项目部署到服务器上

相关服务器部署laravel项目,Nginx服务器上部署Laravel项目

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

相关 Vue-cli 项目怎么上线服务器

相关 spring boot项目上传服务器

相关从服务器购买到项目发布上线（ubuntu服务器）

相关 git 服务器上新建项目

相关在服务器上部署项目