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

Question

2.20K views29/11/2022Oracle Database

0

Amen1.09K 18/11/2022 0 Comments

The cause and solution for ORA-01139: RESETLOGS option only valid after an incomplete database recover error.

Write your answer.

score 0 · Answer 1 · 2022-11-29T07:50:21+00:00

The cause for this error is that Oracle can’t find the online redo log files.

Solution: Recreate the online redo log files and the steps are as follows:

run the following command:
1
2
SQL> recover database until cancel;
Media recovery complete.
Open your database with the OPEN RESETLOGS clause:
1
SQL> alter database open resetlogs;