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

Problem Description: SQL> startup ORACLE instance started. Total System Global Area 1644167168 bytes Fixed Size     2925024 bytes Variable Size 1056968224 bytes Database Buffers   570425344 bytes Redo Buffers   13848576 bytes Database mounted. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open  Solution: Step-1: Execute the following command SQL> shutdown abort; SQL> […]