HomeOracleOracle Error ORA-16827: Flashback Database is disabled

Oracle Error ORA-16827: Flashback Database is disabled

Oracle Error Message

ORA-16827: Flashback Database is disabled

Reason for the Error

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.

Solution

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.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...