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

You are here: Home // Oracle 11g // ORA-01139: RESETLOGS option only valid after an incomplete database recovery

Cause: The RESETLOGS option was given in ALTER DATABASE OPEN, but there has been no incomplete recovery session. See the solution below.

Error solution: Retry the ALTER DATABASE OPEN without specifying RESETLOGS

Database version: Oracle 11g Release 2 (11.2)