Oracle Solution for Error ora-01589

Solution for Oracle Error ORA-01589

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

What triggered 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.

What should we do to fix it:

Specify the appropriate option.