oracle异常问题ORA-01116、ORA-01110、ORA-27041:无法打开文件

发布时间 2023-11-03 14:33:20作者: 苍茫宇宙
select * from dba_data_files;
ORA-01116: 打开数据文件3出错
ORA-01110: 数据文件 3: '/home/oracle/dmpfile20200903/test_xfh_db.dbf'
ORA-27041: 无法打开文件
Linux-x86_64 Error:2: Nosuch file or directory
Additional information: 3
01116. 00000- "error in opening database file %s"
*CAUSE:  USUALLY THE FILE IS NOT ACCESSIBLE.
*Action:Restore the database file.

处理方式:
alter database datafile '/home/oracle/dmpfile20200903/test_xfh_db.dbf' offline drop;