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备走了,取出来后,正常恢复完成了。

 

posted @ 2022-07-14 11:17  尘世间一个迷途小书童  阅读(356)  评论(0编辑  收藏  举报