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


Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


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


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


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

©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页