I was managing and configuration an Active-Standby database running in an Oracle RAC that has two nodes when I found the following output from the alert.log:
2021-08-24 Log Apply Services Managed Standby Recovery Canceled 2021-08-24 Log Apply Services Attempt to start background Managed Standby Recovery process 2021-08-24 Log Apply Services Background Managed Standby Recovery process started 2021-08-24 Log Apply Services Managed Standby Recovery starting Real Time Apply 2021-08-24 Log Apply Services Media Recovery Waiting for T-1.S-194 2021-08-24 Log Transport Services Error 12154 received logging on to the standby 2021-08-24 Fetch Archive Log FAL: Error 12154 connecting to DB_TECH1,DB_TECH2 for fetching gap sequence
After some research, I found that the parameter FAL_SERVER was not configured right in both Primary and Standby databases. The parameter was fixed on both sides. The main issue to cause this to happen is because the multiple service names in the FAL_SERVER parameter on the Standby database were not configured correctly.
The issue was that the parameter was configured as below:
fal_server = '<service name of database 1>,<service name of database 2>'
Instead of correct form as below:
Example :
fal_server = '<service name of database 1>,<service name of database 2>' ALTER SYSTEM SET fal_server='DB_TECH1','DB_TECH2' SCOPE=BOTH SID='*';
After the right configuration, the Data Guard 19c starts to works correctly.
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.