ITPub博客

首页 > 数据库 > Oracle > rman恢复时ORA-01152: file 1 was not restored from a sufficiently old backup

rman恢复时ORA-01152: file 1 was not restored from a sufficiently old backup

原创 Oracle 作者:darren__chan 时间:2015-07-16 09:40:51 0 删除 编辑



ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup 
ORA-01110: data file 1: '/oradata/datafile1/system01.dbf'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/15/2015 17:50:56
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 2220 and starting SCN of 8429237




解决方法:
是由于controlfile里所记录的scn与datafile里的scn不一致。后来查了一下发现restore controlfile时取了一份较早的文件。
于是:
1.shutdown immediate
2.startup nomount
3.rman 下 set dbid
4.重新restore 一份较晚的controlfile.
5.alter database mount;
6.重新recover database 到原先指定的时间点,这里不用restore database是因为原来已经restore成功了
7.alter database open resetlogs;


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29863023/viewspace-1734732/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
一思尚存,此志不懈

注册时间:2014-09-09

  • 博文量
    210
  • 访问量
    1344236