Oracle Error ORA-01139: RESETLOGS option only valid after an incomplete database recovery

Oracle Error Message

ORA-01139: RESETLOGS option only valid after an incomplete database recovery

Reason for the Error

The RESETLOGS option was given in ALTER DATABASE OPEN, but there has been no incomplete recovery session.

Solution

Retry the ALTER DATABASE OPEN without specifying RESETLOGS