Home » RDBMS Server » Backup & Recovery » ORA-00376: file 3 cannot be read at this time (ORACLE 11G,linux)
ORA-00376: file 3 cannot be read at this time [message #629959] Thu, 18 December 2014 02:31 Go to next message
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

hi,
I am facing below error while executing SQL query. Datafile exist on the path but data cant be access.

[code]
ORA-00376: file 3 cannot be read at this time
ORA-01110: data file 3: '/u01/app/oracle/oradata/RACBKP2/etistbs01.dbf' using oracle 11g on linux datafile exist but sql query fail to execute datafile size shows 0 size
[code]
Re: ORA-00376: file 3 cannot be read at this time [message #629960 is a reply to message #629959] Thu, 18 December 2014 02:40 Go to previous messageGo to next message
cookiemonster
Messages: 13017
Registered: September 2008
Location: Rainy Manchester
Senior Member
What is the size of the file on the server?
Re: ORA-00376: file 3 cannot be read at this time [message #629962 is a reply to message #629959] Thu, 18 December 2014 03:03 Go to previous message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

As cookiemonster suggested, post the result of:
ls -l /u01/app/oracle/oradata/RACBKP2/etistbs01.dbf
du -b /u01/app/oracle/oradata/RACBKP2/etistbs01.dbf

Previous Topic: RMAN Restore of Backups as Part of a Database Upgrade
Next Topic: Problem with RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;
Goto Forum:
  


Current Time: Sun Feb 25 12:40:53 CST 2018

Total time taken to generate the page: 0.03616 seconds