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



服务热线 : 13764045638   QQ号:47079569    邮箱:[email protected]

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。






Leave a Reply

Your email address will not be published. Required fields are marked *