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

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:

1. run the following command:

   SQL> recover database until cancel;
    Media recovery complete.

2. Open your database with the OPEN RESETLOGS clause:

   SQL> alter database open resetlogs;