ORA-19906: recovery target incarnation changed during recovery

来源：互联网发布：mac移动硬盘无法读取编辑：程序博客网时间：2024/06/06 05:34

RMAN对进行数据库改名恢复的时候，报告ORA-19906: recovery target incarnation changed during recovery

问题描述

q1ebsdb.imc.com | TEST | /home/oratest > sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 3 22:10:48 2014Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsTEST> recover database using backup controlfile;ORA-00279: change 440517936 generated at 01/03/2014 20:05:55 needed for thread 1ORA-00289: suggestion : /prod/oracle/fast_recovery_area/TEST/archivelog/2014_01_03/o1_mf_1_2154_%u_.arcORA-00280: change 440517936 for thread 1 is in sequence #2154Specify log: {<RET>=suggested | filename | AUTO | CANCEL}/backup/group_3.258.817172153ORA-00283: recovery session canceled due to errorsORA-19906: recovery target incarnation changed during recoveryORA-01112: media recovery not started

解决方法

如果出现上面的情况，需要在RMAN中使用reset database to incarnation x;或者删除数据之前陈旧，用不到的那些归档等干扰因素。
RMAN> list incarnation;找到当前的incarnation
RMAN> reset database to incarnation x;

q1ebsdb.imc.com | TEST | /backup > sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Sat Jan 4 00:02:46 2014Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsTEST> recover database using backup controlfile;ORA-00279: change 440517936 generated at 01/03/2014 20:05:55 needed for thread 1ORA-00289: suggestion : /prod/oracle/fast_recovery_area/TEST/archivelog/2014_01_04/o1_mf_1_2154_%u_.arcORA-00280: change 440517936 for thread 1 is in sequence #2154Specify log: {<RET>=suggested | filename | AUTO | CANCEL}/backup/group_3.258.817172153ORA-00279: change 440517936 generated at 01/03/2014 12:54:07 needed for thread 2ORA-00289: suggestion : /backup/thread_2_seq_1742.398.835905959ORA-00280: change 440517936 for thread 2 is in sequence #1742Specify log: {<RET>=suggested | filename | AUTO | CANCEL}/backup/thread_2_seq_1742.398.835905959ORA-00279: change 440517956 generated at 01/03/2014 20:05:58 needed for thread 2ORA-00289: suggestion : /prod/oracle/fast_recovery_area/TEST/archivelog/2014_01_04/o1_mf_2_1743_%u_.arcORA-00280: change 440517956 for thread 2 is in sequence #1743ORA-00278: log file '/backup/thread_2_seq_1742.398.835905959' no longer needed for this recoverySpecify log: {<RET>=suggested | filename | AUTO | CANCEL}/backup/group_7.262.817172167Log applied.Media recovery complete.

0 0