Oracle Solution for Error ora-01139
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
What triggered the Error:
The RESETLOGS option was given in ALTER DATABASE OPEN, but there has been no incomplete recovery session.What should we do to fix it:
Retry the ALTER DATABASE OPEN without specifying RESETLOGS
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
