insert 数据报错
ORA-00376: file 76 cannot be read at this time
ORA-01110: data file 76: '/oracle/......XXXXX.dbf'
去数据库目录查看发现目录报I/O ERROR
发现挂载问题,重新挂载目录
PS:如果是目录满了,那就需要迁移文件参考(https://blog.csdn.net/weixin_43813742/article/details/105806544)
select file#,name,status from v$datafile;
发现部分数据文件状态为recover状态
解决方案:
sql>alter database datafile '/oracle/......XXXXX.dbf' offline;
登录rman
RMAN>recover datafile 76; --file#
sql>alter database datafile '/oracle/......XXXXX.dbf' online;
文件较多的话,采用脚本肯定恢复方便
sql>@xxx.sql
rman target / @xxxx.rman