关于ORA-01157和ORA-01110报错的求助
OS版本 aix 5.3
数据库版本 oracle 10.2.0.4 rac
今天客户进行exp时报错
ORA-01157: cannot identify/lock data file 31 - see DBWR trace file
ORA-01110: data file 31: '/dev/pc8.dbf'
我看了一下alert log，13号用户有创建表空间的操作，后来客户解释说 当时是通过em直接创建表空间的，但是创建失败，就删掉了。该数据库表空间是建在裸设备上面的，但是通过em直接创建时，
表空间EMC4DG 竟然completed，而表空间EMC4DG_TEMP 却报错ORA-12913(想不明白为什么会一个成功，一个失败)
现在执行select * from dba_data_files; 查询时，也报ORA-01157和ORA-01110的错误
麻烦大侠们帮忙分析下该怎么解决，谢谢
节点1的alert log 和trc文件见附件抓图
节点2的alert log如下
Sat Nov 13 11:53:50 2010
Errors in file /oracle/admin/eipora/bdump/eipora2_dbw0_1835196.trc:
ORA-01157: cannot identify/lock data file 30 - see DBWR trace file
ORA-01110: data file 30: '/dev/EMC4DG.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Sat Nov 13 11:53:50 2010
Errors in file /oracle/admin/eipora/bdump/eipora2_dbw0_1835196.trc:
ORA-01186: file 30 failed verification tests
ORA-01157: cannot identify/lock data file 30 - see DBWR trace file
ORA-01110: data file 30: '/dev/EMC4DG.dbf'
Sat Nov 13 11:53:50 2010
File 30 not verified due to error ORA-01157
Sat Nov 13 11:53:50 2010
Errors in file /oracle/admin/eipora/bdump/eipora2_dbw0_1835196.trc:
ORA-01157: cannot identify/lock data file 30 - see DBWR trace file
ORA-01110: data file 30: '/dev/EMC4DG.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Sat Nov 13 11:53:50 2010
Errors in file /oracle/admin/eipora/bdump/eipora2_dbw0_1835196.trc:
ORA-01186: file 30 failed verification tests
ORA-01157: cannot identify/lock data file 30 - see DBWR trace file
ORA-01110: data file 30: '/dev/EMC4DG.dbf'
File 30 not verified due to error ORA-01157
Sat Nov 13 12:03:38 2010
create tablespace pc8 datafile '\dev\pc8.dbf' size 5G
Sat Nov 13 12:10:50 2010
ORA-604 signalled during: create tablespace pc8 datafile '\dev\pc8.dbf' size 5G
...
Sat Nov 13 12:15:12 2010
create tablespace pc8 datafile '/dev/pc8.dbf' size 1G
Sat Nov 13 12:16:41 2010
Completed: create tablespace pc8 datafile '/dev/pc8.dbf' size 1G
Sat Nov 13 12:16:57 2010
alter database datafile '/dev/pc8.dbf' autoextend on next 50m maxsize unlimited
Sat Nov 13 12:16:57 2010
Completed: alter database datafile '/dev/pc8.dbf' autoextend on next 50m maxsize unlimited
Sat Nov 13 15:19:12 2010
drop tablespace EMC4DG
Sat Nov 13 15:29:06 2010
ORA-3135 signalled during: drop tablespace EMC4DG
...
Sat Nov 13 15:29:26 2010
drop tablespace emc4dg
Sat Nov 13 16:07:56 2010
WARNING: inbound connection timed out (ORA-3136)
Sun Nov 14 01:00:18 2010
节点2的trc文件
/oracle/admin/eipora/bdump/eipora2_dbw0_1835196.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /oracle/product/10.2.0/db_1
System name: AIX
Node name: dgps_eipdb2_srv
Release: 3
Version: 5
Machine: 00CB07F44C00
Instance name: eipora2
Redo thread mounted by this instance: 2
Oracle process number: 10
Unix process pid: 1835196, image: oracle@dgps_eipdb2_srv (DBW0)
*** 2010-09-13 18:51:05.550
*** SERVICE NAME : (SYS$BACKGROUND) 2010-09-13 18:51:05.543
*** SESSION ID : (1097.1) 2010-09-13 18:51:05.543
SKGXPIWAIT: keepalive_reset elapsed 3569934506 ts 3019106066 last ping 3744138856 check 600000
PING HISTORY for CONTEXT Time Stampe 0xb3f3e712
MSGs Time Stamp
--- ----------
0 0xdf2b0668
0 0xdf2b0668
0 0xdf2b0668
0 0xdf2b0668
0 0xdf2b0668
0 0xdf2b0668
0 0xdf2b0668
0 0xdf2b0668
0 0xdf2b0668
0 0xdf2b0668
0 0xdf2b0668
0 0xdf2b0668
0 0xdf2b0668
0 0xdf2b0668
0 0xdf2b0668
0 0xdf2b0668
SKGXP_KEEPALIVE_RESET: alarm unblocked already
SKGXP_KEEPALIVE_RESET: restting shared signal for keep alive messages
SKGXP_KEEPALIVE_RESET: re-initing shared signal for keep alive messages
SKGXP_KEEPALIVE_RESET: setting alarm for keep alive messages
*** 2010-11-13 11:53:50.148
ORA-01157: cannot identify/lock data file 30 - see DBWR trace file
ORA-01110: data file 30: '/dev/EMC4DG.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 30 failed verification tests
ORA-01157: cannot identify/lock data file 30 - see DBWR trace file
ORA-01110: data file 30: '/dev/EMC4DG.dbf'
ORA-01157: cannot identify/lock data file 30 - see DBWR trace file
ORA-01110: data file 30: '/dev/EMC4DG.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 30 failed verification tests
ORA-01157: cannot identify/lock data file 30 - see DBWR trace file
ORA-01110: data file 30: '/dev/EMC4DG.dbf'
页:
[1]