ORA-01139: RESETLOGS option only valid after an incomplete database recovery

 💡 While shutting down my TEST database process was hanged. Then I had to use shutdown abort. But when I wanted to start database it did not open.

 Xử lý lỗi này như thế nào?

SQL> alter database open resetlogs;  
 alter database open resetlogs  
 *  
 ERROR at line 1:  
 ORA-01139: RESETLOGS option only valid after an incomplete database recovery

Unsuccessful…

Let`s recover database

SQL> recover database until cancel;  
 Media recovery complete.
SQL> alter database open resetlogs;  
 Database altered.

Related posts

Khắc phục lỗi recovery khi OPEN RESETLOGS lỗi SYSTEM trong Oracle Database?

check the FRA usage and troubleshoot the issue in oracle DB

ORA-16086: Redo data cannot be written to the standby redo log