In this post, you’ll learn more about the Oracle ErrorORA-01589: must use RESETLOGS or NORESETLOGS option for database open with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
Reason for the Error ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
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.
How to fix the Error ORA-01589: must use RESETLOGS or NORESETLOGS option for database open ?
You can fix this error in Oracle by following the below steps
Specify the appropriate option.