ORA-00376: file 17 cannot be read at this time

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';