ORA-19906: recovery target incarnation changed during recovery

jiawang

问题现象：
TEST> recover database using backup controlfile;
ORA-00279: change 440517936 generated at 01/03/2014 20:05:55 needed for thread 1
ORA-00289: suggestion : /prod/oracle/fast_recovery_area/TEST/archivelog/2014_01_03/o1_mf_1_2154_%u_.arc
ORA-00280: change 440517936 for thread 1 is in sequence #2154


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/backup/group_3.258.817172153
ORA-00283: recovery session canceled due to errors
ORA-19906: recovery target incarnation changed during recovery


解决方法

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

再次恢复
TEST> recover database using backup controlfile;
ORA-00279: change 440517936 generated at 01/03/2014 20:05:55 needed for thread 1
ORA-00289: suggestion : /prod/oracle/fast_recovery_area/TEST/archivelog/2014_01_04/o1_mf_1_2154_%u_.arc
ORA-00280: change 440517936 for thread 1 is in sequence #2154


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/backup/group_3.258.817172153
ORA-00279: change 440517936 generated at 01/03/2014 12:54:07 needed for thread 2
ORA-00289: suggestion : /backup/thread_2_seq_1742.398.835905959
ORA-00280: change 440517936 for thread 2 is in sequence #1742


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/backup/thread_2_seq_1742.398.835905959
ORA-00279: change 440517956 generated at 01/03/2014 20:05:58 needed for thread 2
ORA-00289: suggestion : /prod/oracle/fast_recovery_area/TEST/archivelog/2014_01_04/o1_mf_2_1743_%u_.arc
ORA-00280: change 440517956 for thread 2 is in sequence #1743
ORA-00278: log file '/backup/thread_2_seq_1742.398.835905959' no longer needed for this recovery


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/backup/group_7.262.817172167
Log applied.
Media recovery complete.

郑全

这个是MYSQL 吧 ，怎么发到ORACLE板块里面来了

郑全

标题和内容不符合吧