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

NNC-00427: server does not support this version of the protocol

1 Answers  


ORA-19646: cannot change size of datafile string from string to string

1 Answers  


ORA-01097: cannot shutdown while in a transaction - commit or rollback first

1 Answers  


IMP-00018: partial import of previous table completed: number rows imported

1 Answers  


ORA-19732: incorrect number of datafiles for tablespace string

1 Answers  






ORA-08109: nosort is not a supported option for online index build

1 Answers  


ORA-02305: only EXECUTE, DEBUG, and UNDER privileges are valid for types

1 Answers  


ORA-32605: invalid REBUILD option

1 Answers  


ORA-00069: cannot acquire lock -- table locks disabled for string

1 Answers  


PLS-00649: method "string" can be overridden only once per object type

1 Answers  


ORA-12833: Coordinator's instance not a member of parallel_instance_group

1 Answers  


ORA-34719: (NLSCHARSET03) Character data loss in NTEXT/TEXT conversion

1 Answers  


Categories