Incomplete recovery gi…

最新推荐文章于 2023-12-11 15:19:52 发布

babymouse1212

最新推荐文章于 2023-12-11 15:19:52 发布

阅读量309

点赞数

分类专栏：备份恢复

本文链接：https://blog.csdn.net/babymouse1212/article/details/71079114

版权

备份恢复专栏收录该内容

40 篇文章 0 订阅

订阅专栏

Incomplete recovery gives ORA-01152 (文档 ID 278856.1)

转到底部

还有可能是你的备份文件不全的原因,数据文件的checkpoint_change#不一致

In this Document

Symptoms

Cause

Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

APPLIES TO:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.4 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Jan-2014***

SYMPTOMS

Getting ORA-1152 trying to open the database after incomplete recovery.

CAUSE

This error occurs when a file is ahead in time (SCN) than the stopping point of recovery.

SOLUTION

To implement the solution, please execute the following steps:

1. Identify which file is newer:
a. Startup mount the instance
b. Issue the following queries:

sql> select file#, status, checkpoint_change# from v$datafile;
sql> select file#, status, fuzzy, checkpoint_change# from v$datafile_header;

c. reviewing the checkpoint_change#, identify which file is newer than the others.

2. Restore this file from a previous backup.
3. Reissue the incomplete recovery