问题现象
数据库报错:
ORA-00376: file 94 cannot be read at this time
原因分析
RAC的节点1因为备份失败——》没有及时清除备份——》操作系统根目录满——》节点1发生宕机——》94号数据文件状态变成了recover
解决办法
对94号文件先recover,然后再online
SQL> select file#,status from v$datafile where status<>'ONLINE' ;
FILE# STATUS
---------- -------
1 SYSTEM
5 SYSTEM
11 SYSTEM
94 RECOVER
SQL> recover datafile 94;
Media recovery complete.
SQL> alter database datafile 94 online;
alter database datafile 94 online
*
ERROR at line 1:
ORA-01516: nonexistent log file, data file, or temporary file "94" in the
current container
SQL> alter session set container=pdbcenter;
Session altered.
SQL> alter database datafile 94 online;