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

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

by tuanlp

 💡 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.

You may also like