How to fix the Oracle error ORA-38860: cannot FLASHBACK DATABASE during instantiation of a logical standby?

In this post, you’ll learn more about the Oracle ErrorORA-38860: cannot FLASHBACK DATABASE during instantiation of a logical standby with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-38860: cannot FLASHBACK DATABASE during instantiation of a logical standby

Reason for the Error ORA-38860: cannot FLASHBACK DATABASE during instantiation of a logical standby

The command was not permitted because the controlfile indicates the database was in the process of becoming a logical standby database but the controlfile conversion had not completed.

How to fix the Error ORA-38860: cannot FLASHBACK DATABASE during instantiation of a logical standby ?

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

If in the process of creating a logical standby database, perform the remaining instantiation procedures to completion. If this flashback operation followed a Data Guard failure, permit the errant Data Guard operation to successfully complete. Once the instantiation is complete, reissue the flashback operation.