dbv查询mysql数据错误_数据库报file I/O错,用dbv检查文件也报错,请教是不是有坏块,该怎么定位...

OS:SUSE Linux Enterprise Server 11 (x86_64)

VERSION = 11

PATCHLEVEL = 2

oracle版本:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production

alter log:  。。。。。。

Fri May 08 01:17:21 2015

Completed crash recovery at

Thread 1: logseq 1648175, block 74413, scn 9464420060247

7872 data blocks read, 4450 data blocks written, 223227 redo blocks read

Fri May 08 01:17:23 2015

Thread 1 advanced to log sequence 1648176

Thread 1 opened at log sequence 1648176

Current log# 1 seq# 1648176 mem# 0: /oracle/app/oradata/ora11g/redo01.log

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Fri May 08 01:17:25 2015

SMON: enabling cache recovery

Successfully onlined Undo Tablespace 199.

Verifying file header compatibility for 11g tablespace encryption..

Verifying 11g file header compatibility for tablespace encryption completed

SMON: enabling tx recovery

Thread 1 advanced to log sequence 1648177

Current log# 2 seq# 1648177 mem# 0: /oracle/app/oradata/ora11g/redo02.log

Thread 1 advanced to log sequence 1648178

Current log# 3 seq# 1648178 mem# 0: /oracle/app/oradata/ora11g/redo03.log

Thread 1 cannot allocate new log, sequence 1648179

Checkpoint not complete

Current log# 3 seq# 1648178 mem# 0: /oracle/app/oradata/ora11g/redo03.log

Fri May 08 01:17:34 2015

Database Characterset is AL32UTF8

Opening with internal Resource Manager plan

Fri May 08 01:17:40 2015

KCF: write/open error block=0x1e1ba online=1

file=2 /oracle/app/oradata/ora11g/sysaux01.dbf

error=27072 txt: 'Linux-x86_64 Error: 5: Input/output error

Additional information: 4

Additional information: 123322

Additional information: -1'

Errors in file /oracle/app/diag/rdbms/ora11g/ora11g/trace/ora11g_dbw0_3526.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

ORA-01114: IO error writing block to file 2 (block # 123322)

ORA-01110: data file 2: '/oracle/app/oradata/ora11g/sysaux01.dbf'

ORA-27072: File I/O error

Linux-x86_64 Error: 5: Input/output error

Additional information: 4

Additional information: 123322

Additional information: -1

DBW0 (ospid: 3526): terminating the instance due to error 1242

Errors in file /oracle/app/diag/rdbms/ora11g/ora11g/trace/ora11g_ora_3564.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Error 604 happened during db open, shutting down database

Instance terminated by DBW0, pid = 3526

Fri May 08 09:53:08 2015

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 800

LICENSE_SESSIONS_WARNING = 800

Picked latch-free SCN scheme 3

Using LOG_ARCHIVE_DEST_1 parameter default value as /oracle/app/product/11g/db/dbs/arch

Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on.

IMODE=BR

ILAT =97

LICENSE_MAX_USERS = 0

SYS auditing is disabled

。。。。。。。。。。。。。。

dbv 报错(这个工具不熟):

dbv file='/oracle/app/oradata/ora11g/sysaux01.dbf'

DBVERIFY: Release 11.1.0.6.0 - Production on Fri May 8 10:11:45 2015

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

DBVERIFY - Verification starting : FILE = /oracle/app/oradata/ora11g/sysaux01.dbf

DBV-00600: Fatal Error - [28] [27061] [0] [0]

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值