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

O2F-00316: An unexpected token was seen at the end of a type specification

1 Answers  


ORA-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.

1 Answers  


ORA-28650: Primary index on an IOT cannot be rebuilt

1 Answers  


ORA-07504: scgcmn: $hiber unexpected return

1 Answers  


DRG-11104: Oracle Text error:

1 Answers  






SQL*Loader-00414: no columns to load for table string

1 Answers  


ORA-02171: invalid value for MAXLOGHISTORY

1 Answers  


ORA-06720: TLI Driver: SID lookup failure

1 Answers  


NPL-00420: received ASN.1 object identifier with more than 256 sub-identifiers

1 Answers  


ORA-36261: (XSAGPARTDEP00) Can not Aggregate PARTITION TEMPLATE %J because the path of aggregation would recursively enter partition %J.

1 Answers  


ORA-01203: wrong incarnation of this file - wrong creation SCN

1 Answers  


PLS-00110: bind variable 'string' not allowed in this context

1 Answers  


Categories