The following is the ORA-16107 error message, you can learn the cause and solution of the Oracle database error.


ORA-16107 all log data from primary has been processed

Cause: On the primary system, the log stream has been ended by the ALTER DATABASE PREPARE TO SWITCHOVER TO LOGICAL STANDBY statement.

Solution: Issue one of the following statements to make this standby a primary or resume applying changes from a new primary:

ALTER DATABASE PREPARE TO SWITCHOVER TO LOGICAL PRIMARY;
ALTER DATABASE START LOGICAL STANDBY APPLY NEW PRIMARY dblink;

Case:

Please wait for the update…