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]