Hi,
One day ago we had a Hardware problem with our Solaris Machine and 11g(11.1.0.7.0) Database.
Our Server crashed saying..
ORA-00376: file 643 cannot be read at this time
The above error repeated for another file.
We checked file status and there was some problem(I/O errror when we gave ls command) while accessing the file.
Then we managed to restore that mount point.
and then we started database but the database failed to open saying below error.
RECOVERY OF THREAD 1 STUCK AT BLOCK 113713 OF FILE 643
Thu Jul 21 16:45:41 2011
RECOVERY OF THREAD 1 STUCK AT BLOCK 42896 OF FILE 644
We checked V$recover_file, No file mentioned.we checked V$datafile all files status was online and enabled was read/write.Then we manually recover the failed data files by
ALTER DATABASE RECOVER datafile '/data/irsdata/undodbs03.dbf'
ALTER DATABASE RECOVER datafile '/data/irsdata/undodbs04.dbf'
It succeeded with media recovery complete and then we were able to open Database.
Even if V$recover_file and V$datafile had not mentioned for above two problematic datafiles, why we had to do media recovery?
Any ideas?
Regards!
Edited by: Nitin Joshi on Jul 22, 2011 10:23 AM