How to fix the Oracle error ORA-16827: Flashback Database is disabled?

In this post, you’ll learn more about the Oracle ErrorORA-16827: Flashback Database is disabled with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-16827: Flashback Database is disabled

Reason for the Error ORA-16827: Flashback Database is disabled

The broker detected that the Flashback Database feature was disabled. With Flashback Database disabled, the broker would not be able to:

– reinstate a database that required reinstatement.

– convert a physical standby database to a snapshot standby database.

– convert a snapshot standby database to a physical standby database. Flashback Database may been disabled manually with the ALTER DATABASE FLASHBACK DATABASE OFF command or automatically by the database in the event of an error.

How to fix the Error ORA-16827: Flashback Database is disabled ?

You can fix this error in Oracle by following the below steps

Check the database alert log to determine whether Flashback Database was disabled due to errors and then correct the problem. If Flashback Database had been manually disabled, reenable Flashback Database with the ALTER DATABASE FLASHBACK DATABASE ON command. If, after enabling Flashback Database, the database still cannot be reinstated or converted, you must re-create the database from a copy of the primary database.