ORA-00376: file 24 cannot be read at this time [message #617085] |
Tue, 24 June 2014 15:26  |
azeem87
Messages: 116 Registered: September 2005 Location: dallas
|
Senior Member |
|
|
hi,
on our dev DB, due to space issue we cleaned some old sysdate-1 archive log files and removed old .log files,
app team reported this error after that, few says this error was there before also.
ORA-00376: file 24 cannot be read at this time
ORA-01110: data file 24: '+DATA/devdb/datafile/conv_index.425.774183213'
00376. 00000 - "file %s cannot be read at this time"
*Cause: attempting to read from a file that is not readable. Most likely
the file is offline.
*Action: Check the state of the file. Bring it online
[DEV] SYS@devdb> select file_name,status,online_status from dba_data_files where tablespace_name=conv_index';
FILE_NAME
--------------------------------------------------------------------------------
STATUS ONLINE_
--------- -------
+DATA/devdb/datafile/conv_index.425.774183213
AVAILABLE RECOVER
can you please advice, should i issue recover datafile command , but we don't have old archive log files nows.
Thanks
[Updated on: Tue, 24 June 2014 15:31] Report message to a moderator
|
|
|
|
|
|