APPLIES TO:
Oracle Database - Enterprise Edition - Version 8.1.7.4 and later
Information in this document applies to any platform.
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