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;