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



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

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02034: speed bind not permitted

1 Answers  


PLS-01420: INTERSECT and MINUS set operators are not ANSI

1 Answers  


ORA-28554: pass-through SQL: out of cursors

1 Answers  


ORA-25275: Test support for buffered queues

1 Answers  


ORA-16407: Standby database is in the future of the archive log

1 Answers  






RMAN-06066: the target database must be mounted when issuing a RECOVER command

1 Answers  


ORA-15117: command only operates on one diskgroup

1 Answers  


QSM-02153: inline view or subquery in FROM list not supported for this type MV

1 Answers  


QSM-02090: SELECT includes an expression that is not just a column

1 Answers  


ORA-00127: dispatcher string does not exist

1 Answers  


ORA-39096: invalid input value string for parameter string

1 Answers  


ORA-00383: DEFAULT cache for blocksize string cannot be reduced to zero

1 Answers  


Categories