重庆思庄Oracle、Redhat认证学习论坛

标题: oracle异常问题ORA-01116、ORA-01110、ORA-27041:无法打开文件 [打印本页]

作者: jiawang 时间: 2024-11-7 11:46
标题: oracle异常问题ORA-01116、ORA-01110、ORA-27041:无法打开文件
报错现象：
alter日志出现大量ORA-01116、ORA-01110、ORA-27041:无法打开文件
Thu Oct 24 15:40:18 2024
Errors in file /data/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_m000_23797.trc:
ORA-01116: error in opening database file 9
ORA-01110: data file 9: '/data/oracle/product/11.2.0/dbs/FSMC_YSJ1'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /data/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_m000_23797.trc:
ORA-01116: error in opening database file 14
ORA-01110: data file 14: '/data/oracle/oradata/orcl/fsmc_ysj01.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

问题分析：
数据库正常运行中

解决办法：

alter database datafile'/data/oracle/product/11.2.0/dbs/FSMC_YSJ1'offline drop;

alter database datafile'/data/oracle/oradata/orcl/fsmc_ysj01.dbf'offline drop;

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)