Oracle DBA, How To, Error, Cause and Action

ORA-01139: RESETLOGS option only valid after an incomplete databaserecovery

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




Cause: The RESETLOGS option was given in ALTER DATABASE OPEN, but there has been no incomplete recovery session.




Action: Retry the ALTER DATABASE OPEN without specifying RESETLOGS