ORA-00376 : file 'name' can not be read at this time

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 30 Dec 1999 07:20:16 GMT
Message-ID: <386b07f6.20367707@172.16.7.5>

Hello all,

My database is Oracle 8.0.3 for Netware. I do a full offline backup at 10:30 PM and then startup at 11:55 PM everday.

This morning,I found an error message, when I was select for somethig.

ORA-00376:file 'vol:oranw803\database\adm1app.ora' can not be read at this time

I cheked DBA_TABLESPACES and all tablespaces were ONLINE. Then I checked for v$datafile,I found one datafile's status was RECOVER. So I shutdown immediate,startup mount pfile=:::, and recover database; when recover complete,I select v$datafile again,the file was still RECOVER.

I tried to restore yesterday's adm1app.ora,and startup mount,recover database. BUT didn't work,either.(datafile status was still RECOVER)

Finanlly I recreated controlfile,recover database,alter database open, then it worked(I could do select something).

IF THIS HAPPENS AGAIN,how could I solve the problem? Is it OK to recreate control file,or another solutions?

Thanks for any tips.
Best Regards.

Violin.
violin.hsiao_at_mail.pouchen.com.tw Received on Thu Dec 30 1999 - 01:20:16 CST