OraFAQ Forum: Backup & Recovery » ORA-00376: file 3 cannot be read at this time

Home » RDBMS Server » Backup & Recovery » ORA-00376: file 3 cannot be read at this time (ORACLE 11G,linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00376: file 3 cannot be read at this time [message #629959]

Thu, 18 December 2014 02:31

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]

Report message to a moderator

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

cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester

Senior Member

What is the size of the file on the server?

Report message to a moderator

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

Michel Cadot
Messages: 67666
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 26 13:11:06 CST 2021