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