Oracle数据恢复 ORA-00283 ORA-01110 ORA-01122 ORA-01203报错一例

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

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

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

Oracle数据恢复 ORA-00283 ORA-01110 ORA-01122 ORA-01203报错一例

[oracle@vrh8 ~]$ oerr ora 283
00283, 00000, "recovery session canceled due to errors"
// *Cause: An error during recovery was determined to be fatal enough to end
//         the current recovery session.
// *Action: More specific messages will accompany this message. Refer to
//          the other messages for the appropriate action.

[oracle@vrh8 ~]$ oerr ora 1110
01110, 00000, "data file %s: '%s'"
// *Cause:  Reporting file name for details of another error
// *Action: See associated error message

[oracle@vrh8 ~]$ oerr ora 1122
01122, 00000, "database file %s failed verification check"
// *Cause:  The information in this file is inconsistent with information
//         from the control file. See accompanying message for reason.
// *Action: Make certain that the db files and control files are the correct
//         files for this database.


[oracle@vrh8 ~]$ oerr ora 1203
01203, 00000, "wrong incarnation of this file - wrong creation SCN"
// *Cause:  The creation SCN in the file header is not the same as the
//         creation SCN in the control file. This is probably a copy of a
//         file that was dropped.
// *Action: Restore a current copy of the data file and do recovery as needed.

ora-1203报错说明数据文件4的文件头的incarnation SCN存在讹误，也代表数据文件4可能有其他形式的损坏。 如果在没有备份的情况下，建议对数据文件4做手动修复，并检验数据文件4中的数据block。