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