Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-14 18:33:29 | 查看: 1699| 回复: 0

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'



20101116_723f56f89be8b222fe59XmnHShrJCf5F.jpg
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-6-18 20:06 , Processed in 0.051096 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569