大佬教程收集整理的这篇文章主要介绍了【Oracle】RMAN-20208: UNTIL CHANGE is before RESETLOGS change,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
在数据库已经进入新的incarnation之后,在使用新的incarnation的控制文件来恢复之前的incarnation时会出现以下报错:
RMAN> recover database until scn 1306720;
Starting recover at 04-Jul-16
using channel ORA_disK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FolLOWS ===============
RMAN-03002: failure of recover command at 07/04/2016 20:12:06
RMAN-20208: UNTIL CHANGE is before resetLOGS change
解决方法也很简单,使用List incarnation;命令查看所有的incarnation,之后reset database to incarnation x;你想要恢复的备份所在的incarnation即可。RMAN> List incarnation;
List of Database Incarnations
DB Key Inc Key DB name DB ID STATUS reset SCN reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 SOURCEDB 310015860 PARENT 1 24-AUG-13
2 2 SOURCEDB 310015860 PARENT 925702 31-JAN-16
3 3 SOURCEDB 310015860 CURRENT 1306720 04-Jul-16
RMAN> reset database to incarnation 2;
database reset to incarnation 2
starting media recovery
archived log for thread 1 with sequence 30 is already on disk as file /home/oracle/arch/o1_mf_1_30_cqp7gbgk_.arc
archived log for thread 1 with sequence 31 is already on disk as file /home/oracle/arch/o1_mf_1_31_cqp7qsDW_.arc
archived log for thread 1 with sequence 32 is already on disk as file /home/oracle/arch/o1_mf_1_32_cqp8jht8_.arc
archived log for thread 1 with sequence 33 is already on disk as file /home/oracle/arch/o1_mf_1_33_cqp8smkk_.arc
archived log file name=/home/oracle/arch/o1_mf_1_30_cqp7gbgk_.arc thread=1 sequence=30
archived log file name=/home/oracle/arch/o1_mf_1_31_cqp7qsDW_.arc thread=1 sequence=31
archived log file name=/home/oracle/arch/o1_mf_1_32_cqp8jht8_.arc thread=1 sequence=32
archived log file name=/home/oracle/arch/o1_mf_1_33_cqp8smkk_.arc thread=1 sequence=33
media recovery complete,elapsed time: 00:00:08
Finished recover at 04-Jul-16
可以看到指定正确的incarnation后数据库可以正常进行恢复。以上是大佬教程为你收集整理的【Oracle】RMAN-20208: UNTIL CHANGE is before RESETLOGS change全部内容,希望文章能够帮你解决【Oracle】RMAN-20208: UNTIL CHANGE is before RESETLOGS change所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。