Oracle Error ORA-01588: must use RESETLOGS option for database open

Oracle Error Message

ORA-01588: must use RESETLOGS option for database open

Reason for the Error

An earlier attempt to open the database with the RESETLOGS option did not complete, or recovery was done with a control file backup, or a FLASHBACK DATABASE was done.

Solution

Use the RESETLOGS option when opening the database.