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-14017: partition bound list contains too many elements

1 Answers  


TNS-01306: nt secondary err code: number

1 Answers  


QSM-02069: PCT not supported with multi-column partition key

1 Answers  


ORA-09804: Class conversion from binary to ORACLE failed.

1 Answers  


RMAN-05002: aborting point-in-time tablespace recovery

1 Answers  






LSX-00105: duplicate attribute group "~S"

1 Answers  


ORA-12222: TNS:no support is available for the protocol indicated

1 Answers  


ORA-26052: Unsupported type number for SQL expression on column string.

1 Answers  


ORA-02033: a cluster index for this cluster already exists

1 Answers  


ORA-13042: invalid SDO_LEVEL and SDO_NUMTILES combination

1 Answers  


ORA-29502: NAMED keyword required in CREATE JAVA RESOURCE

1 Answers  


ORA-31398: DBMS_LDAP: Shared servers are not supported.

1 Answers  


Categories