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> startup mount;
SQL> $ rman target / 
RMAN> recover database;
SQL> quit;
SQL> alter database open resetlogs;
SQL> $ rman target / 
RMAN> reset database;

Step-2:  
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.
Database opened.
SQL>


Comments