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

?

1 2 3 4 5 6 7 8 9 10 11 12

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;