Errors message " ORA-00376: file 126 cannot be read at this time "

[Former Member]

Dear All,

I have the errors message like this in Our Dump st22 DBIF_RSQL_Error,

Database errors text ......" ORA-00376: file 126 cannot be read at this time

#ORA-01111: name for data file 126 is unknown rename to correct the files

#ORA-01110: data file 126: '/oracle/AC3/102_64/dbs/MISSING126"

.........

we have found the ossnote Note 328785 - ORA-00376: File cannot be read at this time but seem not solve the issue,

also we found this message below please any want can help to solve this issue?

Re: ORA-01111: name for data file string is unknown - rename to correct file

Answer

1. 1 Cause: The data file was missing from a CREATE CONTROLFILE

command or backup controlfile recovery was done with a

controlfile that was saved before the file was created.

Action: Rename the MISSING file to the name of the real file.

Please add more information about this Error

[Former Member]

The restore is completed but seems when we are running the control.sql we missing one files on this sql.

that why when i executed this command ,

SQL> SELECT NAME FROM V$DATAFILE WHERE STATUS = 'RECOVER';

NAME

-

---

/oracle/AC3/102_64/dbs/MISSING00126

SQL>

Regrads,

Chrisna

[markus_doehr2]

What happened prior to this problem? Did you do a restore? Did you add/delete data files?

Markus