recover database ORA-01152
在rman异机恢复时遇到了错误
RMAN> recover database; Starting recover at 2022-07-02 07:01:37 using channel ORA_DISK_1 starting media recovery Oracle Error: 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: '/u01/app/oracle/oradata/orcl/system01.dbf' RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 07/02/2022 07:01:37 RMAN-06053: unable to perform media recovery because of missing log RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 155437 and starting SCN of 7339623905833 RMAN-06102: no channel to restore a backup or copy of archived log for thread 1 with sequence 155436 and starting SCN of 7339623903051
这是刚刚做的一个全备,recover database时为什么需要应用全库备份之前的归档呢?不是应该应用全库备份之后产生的归档吗?
ORA-01152:文件1没有从足够旧的备份中恢复,备份里restore出的controlfile上的scn 小于 datafile上所记录的scn。
通过查询归档日志的备份信息,发现归档日志nbu备走了,取出来后,正常恢复完成了。