ORA-00376 数据文件无法读取

若oracle数据库出现ORA-00376

1、检查数据文件状态
select file#,name,status from v$datafile;
发现数据文件5 recover状态
2、 恢复数据文件5
recover datafile 5;
SQL> recover datafile 5;     
ORA-00279: change 998939379 generated at 04/11/2016 14:14:00 needed for thread
1
ORA-00289: suggestion :
/oracle/product/10.2.0/db_1/dbs/arch1_64219_858941864.dbf
ORA-00280: change 998939379 for thread 1 is in sequence #64219

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto  
ORA-00279: change 998945611 generated at 04/11/2016 14:34:00 needed for thread
1
ORA-00289: suggestion :
/oracle/product/10.2.0/db_1/dbs/arch1_64220_858941864.dbf
ORA-00280: change 998945611 for thread 1 is in sequence #64220
ORA-00278: log file '/oracle/product/10.2.0/db_1/dbs/arch1_64219_858941864.dbf'
no longer needed for this recovery

Log applied.
Media recovery complete.
SQL> select file#,status from v$datafile;

     FILE# STATUS
---------- -------
     1 SYSTEM
     2 ONLINE
     3 ONLINE
     4 ONLINE
     5 OFFLINE

3、把数据文件5改为联机状态
alter database datafile 5 online;

数据库恢复正常