Oracle 在物理standby由于未知原因字典检查删除新创建的数据文件Dictionary Check deleting the Newly created datafile for unknown at the Physical Standby

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com

 

ORA-01111 oerr ora 1111
01111, 00000, "name for data file %s is unknown - rename to correct file"
// *Cause:  The data file was missing from a CREATE CONTROLFILE command or
//          backup control file recovery was done with a control file that
//          was saved before the file was created.
// *Action: Rename the MISSING file to the name of the real file.


ORA-01274 oerr ora 1274
01274, 0000, "cannot add datafile '%s' - file could not be created"
// *Cause: Automated standby file management was disabled, so an added file
//         could not automatically be created on the standby.
//         The error from the creation attempt is displayed in another message.
//         The control file file entry for the file is 'UNNAMEDnnnnn'.
// *Action: Use the ALTER DATABASE CREATE DATAFILE statement to create the
//          file, or set STANDBY_FILE_MANAGEMENT to AUTO and restart
//          standby recovery.

适用于:

Oracle Database – Enterprise Edition – 版本11.2.0.1 及以上
本文信息适用于任何平台。

症状

  • 由于类似”db_file_name_convert”和”standby_file_management”参数的错误设置,MRP被终止显示错误ORA-1111 或ORA-1274 。

原因

 

该问题由于未发布Bug 8676442导致。

该Bug仍在由开发团队处理中。

Bug 8676442 – NEWLY CREATED DATAFILE FOR UNKNOWN DATAFILE GETS REMOVED BY DICTIONARY CHECK

 

按照 Document 739618.1 中给出的步骤,且当物理Standby 被打开时,它失败显示以下错误:

Tablespace ‘<TS name>’ <TS number> found in controlfile,
but not in the data dictionary. Deleting from controlfile.
Removing file from controlfile.
data file 62: ‘<Name of the Datafile with full path>’
Tablespace ‘<TS name>’ <TS number> found in controlfile,
but not in the data dictionary. Deleting from controlfile.
Dictionary check complete

 

解决方案

按照在bug中给出的解决方法:
在mount模式下创建空文件并在mount模式下启动managed recovery直到字典被新的文件和表空间更新。

然后打开数据库。

关注刘相兵的新浪微博

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

Speak Your Mind

沪ICP备14014813号

沪公网安备 31010802001379号

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569