Error Detail While try to switch over the database and check with show configuation command getting the following error:
DGMGRL> show configurationConfiguration - 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: DisabledConfiguration Status:ERROR (status updated 67 seconds ago)
Solution:
Performed the below steps to resolve the issue,
- Checked the standby database to verify if the MRP process is running
- If the MRP process is still running, cancel it using the command: “alter database recover managed standby database cancel;”
- 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.