Oracle DBA, How To, Error, Cause and Action

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

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

No comments:

Post a Comment

Thanks for your comment.