诗檀软件专业数据库修复团队
服务热线 ： 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。