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

OS: Oracle Linux 6.8
Oracle Database: 12c
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 

In this case, the following operations must be performed.

SQL> shutdown abort;
SQL> startup mount;
$ rman target / 
RMAN> recover database;
SQL> alter database open resetlogs;
RMAN> reset database;

After the commands are executed successfully, the database is opened again.

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>

Hits: 6

Leave a Reply

Your email address will not be published. Required fields are marked *