如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com
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.
症状
RMAN复制阶段,创建临时文件时我们在辅助实例中看到以下错误:
ORA-01186: file 1025 failed verification tests
ORA-01122: database file 1025 failed verification check
ORA-01110: data file 1025: ‘/u01/oradata/temp_01.dbf’
ORA-01206: file is not part of this database – wrong database id
File 1025 not verified due to error ORA-01122
或者
ORA-01186: file 1025 failed verification tests
ORA-01122: database file 1025 failed verification check
ORA-01110: data file 1025: ‘/u01/oradata/temp_01.dbf’
ORA-01203: wrong incarnation of this file – wrong creation SCN
File 1025 not verified due to error ORA-01122
该复制操作不会失败。以上错误只会影响辅助实例中临时文件的创建。
原因
当复制数据库,且辅助实例临时文件预先存在于操作系统上时,有关临时文件的ORA-01122错误才会发生。
当首次运行复制,且操作系统上不存在临时文件时,复制才能正常进行,并成功创建临时文件。辅助实例的警报日志记录条目如下:
Tue Jun 27 13:10:28 2006
Errors in file /apps/oracle/admin/AUX/bdump/aux_dbw0_19957.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 – see DBWR trace file
ORA-01110: data file 201: ‘/u002/oradata/AUX/temp01.dbf’ <– expected error as file does not exist.
Tue Jun 27 13:10:28 2006
File 201 not verified due to error ORA-01157
Tue Jun 27 13:10:28 2006
Dictionary check complete
Tue Jun 27 13:10:28 2006
SMON: enabling tx recovery
Tue Jun 27 13:10:28 2006
Re-creating tempfile /u002/oradata/AUX/temp01.dbf <– Tempfiles are added correctly.
Database Characterset is WE8ISO8859P1
RMAN复制尝试将临时文件添加到辅助数据库。首次进行复制时,该临时文件不是实际存在,所以Oracle会发出ORA- 01186 / ORA- 01157,并继续创建临时文件。
然而,当辅助临时文件已经存在(前面复制尝试成功创建的),则Oracle 无法添加临时文件到辅助实例,将发出ORA-01186/ORA-01122/ORA-01203 或 ORA-01186/ORA-01122/ORA-01206。
解决方案
错误出现后,你仅需连接到辅助实例并手动添加临时文件。
为避免以后出现这种错误,开始复制操作时,确保你清除了辅助实例的数据文件和临时文件。再次尝试复制之前,你可以使用DROP DATABASE命令删除辅助实例的所有文件,这样当RMAN为辅助实例创建临时文件时,我们就不会面临ORA- 01122错误。
下面是使用DROP DATABASE清除数据库所有文件(数据文件/临时文件/重做日志/控制文件/参数文件)的一个例子:
From SQL*PLUS connect to the database that needs to be dropped and mount in exclusive mode:
SQL> startup mount exclusive;
SQL> alter system enable restricted session;
SQL> exit;
From RMAN, connect to the database that needs to be dropped as target and execute:
RMAN> drop database including backups;
或者,如果你不想使用DROP DATABASE命令,可以使用V$DATAFILE 和 V$TEMPFILE 视图来查看辅助数据库的数据文件和临时文件路径,并在再次开始复制前手动删除它们。
Comment