ORA-16107: all log data from primary has been processed

You are here: Home // Oracle 11g // ORA-16107: all log data from primary has been processed

ORA-16107: all log data from primary has been processed

Posted by Oracle 11g Release 2 on Aug 15, 2009 | Leave a Comment

Cause: On the primary system, the log stream has been ended by the ALTER DATABASE COMMIT TO SWITCHOVER TO LOGICAL STANDBY command. See the solution below.

Error solution: Issue one of the following commands to make this standby a primary or resume applying changes from a new primary. ALTER DATABASE COMMIT TO SWITCHOVER TO LOGICAL PRIMARY; ALTER DATABASE START LOGICAL STANDBY APPLY NEW PRIMARY dblink;

Database version: Oracle 11g Release 2 (11.2)

Tags: ora, Oracle 11g Release 2