每五分钟，Oracle Engine每五分钟将错误返回到TRC文件中，其中显示了消息：
'ora-00376：file'/U01/app/oracle/product/11.2.0/dbhome_2/dbs/missing00002'目前无法读取'。
该文件不存在，如果我检查哪个是表空间，我可以看到那是sysaux。
如果我检查Sysaux表空间的所有数据文件，仅在状态“恢复”中出现。
如果我尝试删除它，它会将其返回到表空间的唯一文件，如果我添加新的数据文件并尝试删除，它会将错误返回错误，说这是表空间的第一个数据文件。
我无法删除表空间，因为它会给我返回无法删除的错误。
我该怎么办？将所有数据库导出并导入它应该起作用，但这将是最后的选择。
Every five minutes, oracle engine returns an error into trc files where it says the message:
'ORA-00376: File '/u01/app/oracle/product/11.2.0/dbhome_2/dbs/MISSING00002' cannot be read at this time'.
This file doesn't exist and if i check which one is the tablespace where is located i can see that is sysaux.
If i check for all datafiles of sysaux tablespace, only this appears with status 'RECOVER'.
If i try to delete it it returns me the error that is the only file of tablespace, and if i add a new datafile and try to delete, it returns me the error saying that is the first datafile of tablespace.
I can't drop tablespace because it returns me the error that can't be deleted.
What could i do? Making an export of all database and import it should work, but this would be the last option.
发布评论
评论（2）
“丢失xxx”数据文件本质上告诉您Oracle找不到正确的文件（也许您已移动或删除了实际数据文件）。 “丢失”不是实际文件。
如果您有RMAN备份，则可以尝试从备份恢复文件（可以使用恢复顾问来实现此目的），或者如果您认为您知道实际文件在哪里，则可以运行“重命名”数据文件，以指向正确的文件：
"MISSINGXXX" datafile essentially tells you that Oracle is not able to find the correct file (maybe you moved or deleted the actual data file). "Missing" isn't an actual file.
If you have an RMAN backup, you can try restoring the file from backup (you could use recovery advisor to achieve this), or if you think you know where the actual file is you could run "rename" datafile procedure to point to the correct file: https://docs.oracle.com/cd/E18283_01/server.112/e17120/dfiles005.htm
RMAN数据恢复顾问可以为您提供帮助。
祝你好运！
RMAN Data Recovery Advisor can help you out.
Best of luck!