Oracle Error ORA-38871: cannot enable flashback before open resetlogs after incomplete recovery.

Oracle Error Message

ORA-38871: cannot enable flashback before open resetlogs after incomplete recovery.

Reason for the Error

To enable flashback on a primary database, the database must be clean without requiring open resetlogs.

Solution

Open resetlogs first and then enable flashback database.