Home » RDBMS Server » Server Administration » ORA-00376: file 24 cannot be read at this time (Oracle 11.1.0.7.0 for IBM/AIX RISC System/6000: Version 11.1.0.7.0)
ORA-00376: file 24 cannot be read at this time [message #617085] Tue, 24 June 2014 15:26 Go to next message
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

Re: ORA-00376: file 24 cannot be read at this time [message #617086 is a reply to message #617085] Tue, 24 June 2014 15:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
should i issue recover datafile command


Yes.

Quote:
but we don't have old archive log files nows.


Anyway, try it.

One question: if you don't keep the archived logs (or their backup) in order to recover a file failure why your database is in ARCHIVELOG mode?

icon14.gif  Re: ORA-00376: file 24 cannot be read at this time [message #617088 is a reply to message #617086] Tue, 24 June 2014 15:42 Go to previous messageGo to next message
azeem87
Messages: 116
Registered: September 2005
Location: dallas
Senior Member
Thanks it worked

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
Log applied.
Media recovery complete.

+DATA/devdb/datafile/conv_index.425.774183213
AVAILABLE ONLINE
Re: ORA-00376: file 24 cannot be read at this time [message #617101 is a reply to message #617088] Wed, 25 June 2014 00:43 Go to previous message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes, most often you only need the online redo logs.
My question still remains... but you do as you want.

Previous Topic: Duplicate permissions entries and can't create new ones
Next Topic: How to detect if a database needs recovery
Goto Forum:
  


Current Time: Mon Mar 18 21:59:05 CDT 2024