Chapter 10. Real-world Scenarios

In this chapter, we will consider some real-world business scenarios that are very essential for any RAC database administrator. Let's begin this chapter by considering some important questions regarding situations you may possibly find yourself in, while handling Oracle Clusterware and dealing with business-critical RAC databases:

• First, how will you manage if the database server has reached the maximum resource capacity and you are unable to add any additional resources, in terms of CPU and memory?

• How will you handle the workload pressure of your application if the number of business users increases drastically?

• How will you provide users the uninterrupted service of your business-critical applications during a prolonged planned or unplanned downtime or prevent any single-point of failure situations?

When facing real-world business scenarios similar to the ones in this bullet list, an Oracle Real Application Cluster (RAC) could be the answer to all of your...