重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-19906: recovery target incarnation changed during recovery [打印本页]

作者: jiawang    时间: 2023-9-8 11:51
标题: ORA-19906: recovery target incarnation changed during recovery
本帖最后由 jiawang 于 2023-9-10 16:21 编辑

问题现象:
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.



作者: 郑全    时间: 2023-9-8 19:40
这个是MYSQL 吧 ,怎么发到ORACLE板块里面来了
作者: 郑全    时间: 2023-9-8 19:41
标题和内容不符合吧




欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2