ORA-00376: file 17 cannot be read at this time and ORA-01110: data file 17: '/oracle/XXX/sapdata2/prd_14/prd.data14'
1 – Validate the datafiles state:
SQL > select name from v$datafile where status = 'RECOVER';
Results:
/oracle/XXX/sapdata2/prd_14/prd.data14
2 – Do a Recover
SQL > alter database recover datafile '/oracle/XXX/sapdata2/prd_14/prd.data14';
SQL > shutdown
SQL > startup
3 – Validate at the OS Level if error is still there
#tail -100 alert_PRD.log
If the error is there:
SQL > shutdown
SQL > startup mount;
SQL > alter database datafile '/oracle/XXX/sapdata2/prd_14/prd.data14' offline;
SQL > alter database recover datafile '/oracle/XXX/sapdata2/prd_14/prd.data14';
SQL > alter database datafile '/oracle/XXX/sapdata2/prd_14/prd.data14' online;
SQL > alter database open;
4 – Useful command lines:
select substr(name,22,20) "Datafile", status from v$datafile;
select name from v$datafile where status = 'OFFLINE';
select name from v$datafile where status = 'SYSTEM';
select name from v$datafile where status = 'ONLINE';
select name from v$datafile where status = 'RECOVER';