Best Practices for Oracle Database Configuration (Part 2)


Oracle Data Guard configuration.


In part 1, we have set forth the best practices that you should observe when setting up your Oracle Databases.  Let us continue with the best practices for your Oracle systems.

Best practices for configuring Real Application Clusters

When dealing with Real Application Clusters, you should:

  1. Register all instances with remote listeners.  Your listeners should be registered via the REMOTE_LISTENER parameter.  This is to make sure that all of your listeners are aware of all the services and instances that run these services.  What’s more, listeners should be utilizing server side load balancing.  If you are using virtual IP addresses or cluster aliases, your listeners should be listening on this as well.  One thing that listeners should avoid is listening in on the hostname, which would cause you to have disconnected sessions when the virtual IPs are automatically relocated to their owning nodes.
  1. Avoid setting up CLUSTER_INTERCONNECTS unless you need it to scale. CLUSTER_INTERCONNECTS is an initialization parameter that you only need to set up if there are two or more cluster interconnect and the default is not at par with the throughput requirements of the Real Application Clusters database.

Best practices for configuring Data Guard

After you have determined the right standby database for your needs, you should configure it right.  The best practices to do this include:

  • Making sure that there is a simple yet robust archiving configuration and strategy
  • Using multiplexed standby redo logs with enough size
  • Using FORCE LOGGING and Real Time Apply
  • Setting up Dynamic Service Registration for your database and listeners
  • Tuning the WAN network
  • Doing a performance assessment for your planned network configuration
  • Setting the Data Protection Mode
  • Using a MAN or LAN for maximum protection or availability modes
  • Using ARCH for the maximum performance throughput
  • Using ASYNC to avoid loss of data
  • Evaluating your SSH port forwarding
  • Make sure that redo data is securely transmitted

Best practices for configuring Oracle Maximum Availability Architecture (MAA)

To configure your MAA right, you should:

  1. Set up multiple standby instances.  Having multiple standby instances and having multiple standby databases are two different things.  Standby instances can have either managed recovery process or logical standby apply process, and all the other standby instances are designated as secondary.  These multiple standby instances help you have transparent connection failover when things fail to connect to your primary standby instance. It also helps you do scheduled maintenance by allowing the secondary standby instances take over the host and the primary standby instance when you need to take them offline.
  1. Set up Connect-Time Failover for Network Service Descriptors.  Connect-time failover happens when a connection request is redirected to another listener after the first request for connection fails.

Four Cornerstone can help you set up your Oracle Maximum Availability Architecture, Real Application Clusters and Data Guard with all these best practices in place.  Call us at 817-377-1144 and start working with a team of certified Oracle experts, all of which have years of experience working in a variety of industries and working with different companies.  We can also help you set up your backup and recovery systems as well as ensure fast application failovers.

Contact us now!

Photo courtesy of David Feng.

AI Governance

What is AI TRiSM?

If reading now about AI TRiSM for the first time, it might be good read on and learn what it’s about because it leads the...

Keep Reading

Cloud Blog

4 Ways To Benefit from…

One of the benefits you get when you work with cloud applications is that you often have quarterly updates that are packed with features. This...

Keep Reading

Artificial Intelligence

Data and Analytics: Cross the…

  Artificial intelligence is a manna sent from digital heaven. That’s how blessed your business can get if you immerse into the AI of things....

Keep Reading

Business Intelligence Blog

How Brand Names Survive in…

  The age of digital marketplace has made it possible for unknown and smaller companies to compete with better-known and well-established brands. Take for example...

Keep Reading

Artificial Intelligence

The Phenomenon That Is Artificial…

  Artificial intelligence is when a machine does cognitive functions that are more associated with humans, such as thinking, learning, problem solving, and reasoning. As...

Keep Reading


Digital Transformation in Banking: Shift…

  The start of a new decade is already shaping up to be exciting for financial services, especially for banks as they continue to compete...

Keep Reading

Business Intelligence Blog

Data Science and Its Economic…

It would seem that artificial intelligence is the focus of businesses that are looking to future proof their organizations and stay competitive. And why not?...

Keep Reading

Data Blog

Ensure Efficient Data Science and…

In an ever-expanding landscape called Internet of Things and the exploding development of artificial intelligence, we are bombarded with complex methods of integrating data science...

Keep Reading

Business Intelligence Blog

Cybersecurity: The Top 5 Expectations…

  If you think about it, cybersecurity is closely tied to human rights, privacy, freedom, and even basic safety. As a whole, we have become...

Keep Reading

Business Intelligence Blog

Tech Security Should Be Easy…

  IT professionals know that tech security is important in everything that they do. And that there are a lot of products, tools, innovations, and...

Keep Reading

Live Chat | Emergency