ORACLE RAC 11g Administration

ORACLE RAC 11g Administration

The main aim of Oracle RAC is to implement a clustered database to provide performance, scalability and resilience. Oracle RAC allows multiple computers to run Oracle RDBMS software simultaneously while accessing a single database, thus providing clustering.

In a non-RAC Oracle database, a single instance accesses a single database. The database consists of a collection of data files, control files, and redo logs located on disk. The instance comprises the collection of Oracle-related memory and operating system processes that run on a computer system.

In an Oracle RAC environment, 2 or more computers (each with an Oracle RDBMS instance) concurrently access a single database. This allows an application or user to connect to either computer and have access to a single coordinated set of data.


Identify Real Application Clusters components
    •	1.Understand Real Application Clusters
    •	2.Clusters Scalability and High Availability
    •	3.The Necessity of Global Resources
    •	4.Parallel Execution with RAC
    •	5.RAC Software and Database Principles
    •	6.RAC and Shared Storage Technologies
    •	7.Understand VIPs

Install, create, administer, and monitor a Real Application Clusters database
    •	1.Describe the installation of Oracle RAC 10g
    •	2.Perform RAC pre-installation tasks
    •	3.Perform cluster setup tasks
    •	4.Install Oracle Clusterware
    •	5.Install and configure Automatic Storage Management (ASM)
    •	6.Install the Oracle database software
    •	7.Create a cluster database
    •	8.Install the Enterprise Manager agent on each cluster node

Use configuration and management tools for Real Application Clusters databases
    •	1.Use Enterprise Manager cluster database pages
    •	2.Define redo log files in a RAC environment
    •	3.Define undo tablespaces in a RAC environment
    •	4.Start and stop RAC databases and instances
    •	5.Modify initialization parameters in a RAC environment
    •	6.Manage ASM instances in a RAC environment

Develop a backup and recovery strategy for Real Application Clusters databases
    •	1.Configure the RAC database to use ARCHIVELOG mode and the flash recovery area
    •	2.Configure RMAN for the RAC environment

Configure and monitor Oracle Clusterware resources
    •	1.Manually control the Oracle Clusterware stack
    •	2.Change voting disk and OCR configuration
    •	3.Back up or recover your voting disks and OCR files
    •	4.Change VIP addresses
    •	5.Use the CRS framework

Review high availability best practices
    •	1.Add a new node to your cluster database
    •	2.Remove a node from your cluster database
    •	3.Decide on the best ASM configuration to use
    •	4.Patch your RAC system in a rolling fashion
    •	5.High Availability Architecture