If you have database in archive log mode use
recover datafile 'datafile name';
Violin <violin.hsiao_at_mail.pouchen.com.tw> wrote in message
news:386b85c1.12682151_at_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 - 21:49:00 CST
