ORA-01157 ORA-01110 ORA-27037 错误

yxtg

ORA-01157 ORA-01110 ORA-27037

版本：(aix5.2+rac)

----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bi
PL/SQL Release 10.1.0.5.0 - Production
CORE 10.1.0.5.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.1.0.5.0 - Productio
NLSRTL Version 10.1.0.5.0 - Production

报错信息：

Fri Jan 19 20:36:18 2007
Errors in file /u01/app/oracle/admin/dfdb/bdump/dfdb2_dbw0_2035824.trc:
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: '/u01/app/oracle/product/1012/dbs/e:CWBASE_DAT.DBF'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Fri Jan 19 20:36:18 2007
Errors in file /u01/app/oracle/admin/dfdb/bdump/dfdb2_dbw0_2035824.trc:
ORA-01186: file 8 failed verification tests
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: '/u01/app/oracle/product/1012/dbs/e:CWBASE_DAT.DBF'
Fri Jan 19 20:36:18 2007
File 8 not verified due to error ORA-01157
Fri Jan 19 20:36:18 2007
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=23, OS id=1925304
ARC0: Archival started
Fri Jan 19 20:36:18 2007
LGWR: STARTING ARCH PROCESSES COMPLETE
Fri Jan 19 20:36:18 2007


Tue Jan 23 10:07:28 2007
ARC1: Evaluating archive thread 2 sequence 7490
Tue Jan 23 10:07:28 2007
ARC1: Beginning to archive thread 2 sequence 7490 (155636578-155637693) (dfdb2)
ARCH: Connecting to console port...
Tue Jan 23 10:07:28 2007
ARC1: Creating local archive destination LOG_ARCHIVE_DEST_1: '/archivelog/dfdb/dfdb2_7490_568249543.dbf' (thread 2 sequence 7490)
(dfdb2)
ARCH: Connecting to console port...
Tue Jan 23 10:07:28 2007
ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '/archivelog/dfdb/dfdb2_7490_568249543.dbf'
(dfdb2)
ARCH: Connecting to console port...
Committing creation of archivelog '/archivelog/dfdb/dfdb2_7490_568249543.dbf'
Tue Jan 23 10:07:28 2007
ARC1: Completed archiving thread 2 sequence 7490 (155636578-155637693) (dfdb2)
ARCH: Connecting to console port...
Tue Jan 23 11:59:04 2007
ORA-1688: unable to extend table SYS.WRH$_SEG_STAT partition WRH$_SEG_ST_2113131079_12140 by 128 in tablespace SYSAUX


$ cat /u01/app/oracle/admin/dfdb/bdump/dfdb2_dbw0_2035824.trc
/u01/app/oracle/admin/dfdb/bdump/dfdb2_dbw0_2035824.trc
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/1012
System name: AIX
Node name: db_svr
Release: 2
Version: 5
Machine: 000CEB3E4C00
Instance name: dfdb2
Redo thread mounted by this instance: 2
Oracle process number: 9
Unix process pid: 2035824, image: oracle@db_svr (DBW0)

*** 2007-01-19 20:36:18.081
*** SERVICE NAME皱眉) 2007-01-19 20:36:18.067
*** SESSION ID皱眉876.1) 2007-01-19 20:36:18.067
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: '/u01/app/oracle/product/1012/dbs/e:CWBASE_DAT.DBF'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-01186: file 8 failed verification tests
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: '/u01/app/oracle/product/1012/dbs/e:CWBASE_DAT.DBF'

其他说明：

归档模式、数据库建立在裸设备。

yikaikai

ORA-01110: data file 8: '/u01/app/oracle/product/1012/dbs/e:CWBASE_DAT.DBF'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory

这不是windows

yxtg

原帖由 yikaikai 于 2007-1-23 17:25 发表
ORA-01110: data file 8: '/u01/app/oracle/product/1012/dbs/e:CWBASE_DAT.DBF'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory

这不是windows

是啊，上面已经说明了啊
版本：(aix5.2+rac)