Oracle Error ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

Oracle Error Message

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

Reason for the Error

Either incomplete or backup control file recovery has been performed. After these types of recovery you must specify either the RESETLOGS option or the NORESETLOGS option to open your database.

Solution

Specify the appropriate option.