rman恢复遭遇ora-1152

最新推荐文章于 2023-01-30 16:52:09 发布

DarrowZeng

最新推荐文章于 2023-01-30 16:52:09 发布

阅读量1k

点赞数

分类专栏： RMAN

本文链接：https://blog.csdn.net/darrowzeng/article/details/46785255

版权

本文详细介绍了在RMAN异机恢复中遇到ORA-1152错误的场景，提供了两种解决方案：1）根据SCN进行恢复，通过查询和比较SCN来定位并恢复到特定日志组；2）使用隐藏参数强制打开数据库，通过设置"_allow_resetlogs_corruption"为true，然后进行恢复和重置日志。

摘要由CSDN通过智能技术生成

在一次rman异机恢复中，遇到了ora-1152的错误。

Error Text, Cause and Action from Message File/s for ORA-01152

Versions 9.2, 10.1, 10.2, 11.1, 11.2, 12.1

Error:  ORA-01152 file %s was not restored from a sufficiently old backup 
---------------------------------------------------------------------------
Cause:  An incomplete recovery session was started, but an insufficient number 
	of logs were applied to make the database consistent. This file is 
	still in the future of the last log applied. The most likely cause of 
	this error is forgetting to restore the file from a backup before doing 
	incomplete recovery. 
Action: Either apply more logs until the database is consistent or restore the 
	database file from an older backup and repeat recovery.

这是metalink上面的信息。同时提到会触发12c的一个bug，以后在12c的时候需要一个补丁包。

可能metalink上描述不够清晰，只是说明是日志问题，最后总结2种解决方案

1、根据scn进行恢复

查询scan