Oracle Database - Enterprise Edition - Version 22.214.171.124 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