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>
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s