诗檀软件专业数据库修复团队
ORA-01177
oerr ora 1177
01177, 00000, "data file does not match dictionary - probably old incarnation"
// *Cause: When comparing the control file with the data dictionary after
// a CREATE CONTROLFILE or OPEN RESETLOGS, it was noted that this
// datafile was inconsistent with the dictionary. Most likely the
// file is a backup of a file that was dropped from the database,
// and the same file number was reused for a new file. It may also
// be that an incomplete recovery stopped at a time when this file
// number was used for another datafile.
// *Action: Do a CREATE CONTROLFILE with the correct file or none at all.
适用于：
Oracle Server - Enterprise Edition – 版本 11.2.0.1 到 11.2.0.3 - Release: 11.2 到 11.2
本文信息适用于任何平台。
目标
在时间点还原和恢复成功后，在打开未被还原的数据文件的resetlogs时生成错误：
RMAN> run {
2> set until time "to_date('22-MAR-2012 01:24:09', 'DD-MON-YYYY HH24:MI:SS')";
3> restore database;
4> recover database;
5> alter database open resetlogs;
6> }
...
channel ORA_SBT_TAPE_1: restoring datafile 00001 to D:\APP\ORACLE\ORADATA\ORCL\SY
STEM01.DBF
channel ORA_SBT_TAPE_1: restoring datafile 00002 to D:\APP\ORACLE\ORADATA\ORCL\SY
SAUX01.DBF
channel ORA_SBT_TAPE_1: restoring datafile 00004 to D:\APP\ORACLE\ORADATA\ORCL\PA
TROL_DATA01.DBF
channel ORA_SBT_TAPE_1: restoring datafile 00005 to D:\APP\ORACLE\ORADATA\ORCL\US
ERS01.DBF
channel ORA_SBT_TAPE_1: reading from backup piece db_bak_245_1_778554117
channel ORA_SBT_TAPE_1: piece handle=db_bak_245_1_778554117 tag=FULL_DB_BACKUP_T
O_BUR
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:02:46
channel ORA_SBT_TAPE_1: starting datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_1: restoring datafile 00003 to E:\APP\ORACLE\ORADATA\ORCL\UN
DOTBS01.DBF
channel ORA_SBT_TAPE_1: restoring datafile 00006 to D:\APP\ORACLE\ORADATA\ORCL\HP
OM_DATA01.DBF
channel ORA_SBT_TAPE_1: restoring datafile 00007 to D:\APP\ORACLE\ORADATA\ORCL\AU
...
archived log file name=F:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2012_03_
22\O1_MF_1_277_7PPC2842_.ARC RECID=191 STAMP=778585352
archived log file name=F:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2012_03_
22\O1_MF_1_278_7POTMOCJ_.ARC thread=1 sequence=278
media recovery complete, elapsed time: 00:00:00
Finished recover at 22-MAR-12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
ORA-03114: not connected to ORACLE
RMAN-03002: failure of alter db command at 03/22/2012 09:43:52
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01177: data file does not match dictionary - probably old incarnation
ORA-01110: data file 9: 'E:\APP\ORACLE\ORADATA\ORCL\USER_CONFIG_01.DBF'
Process ID: 2676
Session ID: 2740 Serial number: 10
ORACLE error from target database:
ORA-03114: not connected to ORACLE
解决方案
从还原操作中，我们未发现数据文件号 9
但当尝试打开时，错误在数据文件9上出现
这表示在选择时间 '22-MAR-2012 01:24:09'时该数据文件不是数据库的一部分
由于数据文件在控制文件中被列出，生成了错误。
这表示在数据文件还原之前，控制文件未被还原。
要解决问题，还原控制文件：
RMAN> startup nomount
run {
set until time "to_date('22-MAR-2012 01:24:09', 'DD-MON-YYYY HH24:MI:SS')";
restore controlfile from autobackup;
alter database mount;
restore database;
recover database;
alter database open resetlogs;
}