Fix ORA-16854: apply lag could not be determined in DGMGRL Oracle DataGuard

Error Detail While try to switch over the database and check with show configuation command getting the following error:

DGMGRL> show configuration
Configuration - dg_config
Protection Mode: MaxPerformance
Members:
PRIMARY - Primary database
Error: ORA-16763: redo transport service for a member is running
standby - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
ERROR (status updated 67 seconds ago)

Solution:

Performed the below steps to resolve the issue,

  1. Checked the standby database to verify if the MRP process is running
  2. If the MRP process is still running, cancel it using the command: “alter database recover managed standby database cancel;”
  3. Initiated the MRP process with the following command instead of “alter database recover managed standby database disconnect from session;”
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

The MRP process was started with the command above, fixing the issue.

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply