Home » RDBMS Server » Backup & Recovery » Getting error ORA-00376: file 13 cannot be read at this time
Getting error ORA-00376: file 13 cannot be read at this time [message #156676] Thu, 26 January 2006 23:49
bijayad
Messages: 11
Registered: August 2005
Junior Member
Hi,

I am getting from error when I am trying to read from the table.
SQL> select count(*) from SUMMARY_RA;
select count(*) from SUMMARY_RA
*
ERROR at line 1:
ORA-00376: file 13 cannot be read at this time
ORA-01110: data file 13: '/oradb1/oradata/biw/data/biw_tbs03.dbf'

I thing this error is because of some data block corruption in data file. My database is up, but I am unable to read the data.
For this data file (.dbf) we don't have any backup and our database is running in no archieve mode.

Can any one please suggest me how I can recover the data from that data file.

Thanks.
Previous Topic: RMAN backup error
Next Topic: oracle DB recovery using rman
Goto Forum:
  


Current Time: Mon Dec 23 03:50:51 CST 2024