Corporate Oracle Database RAC Administration Training Course

1. RAC concepts and architecture

1. Definition and components of RAC
2. Architecture overview
3. How RAC works

2. Benefits of using Oracle RAC

1. High availability and failover capabilities
2. Scalability and performance improvements
3. Load balancing and resource management

3. Overview of Oracle RAC components

1. Oracle Clusterware
2. Oracle Real Application Clusters
3. Automatic Storage Management (ASM)

1. Understanding RAC prerequisites

1. Hardware and software requirements
2. Network configuration and storage setup
3. Oracle software installation prerequisites

2. Key features and capabilities

1. Real-time database clustering
2. Workload management
3. Continuous availability and disaster recovery

3. Oracle Clusterware architecture

1. Core components and their roles
2. Cluster Ready Services (CRS)
3. High Availability Framework

1. Pre-installation requirements and setup

1. System and software checks
2. Configuring shared storage and network
3. Setting up environment variables

2. Installing Oracle RAC software

1. Installation process overview
2. Oracle Universal Installer (OUI) steps
3. Verifying the installation

3. Creating RAC databases

1. Using Database Configuration Assistant (DBCA)
2. Configuring database parameters for RAC
3. Database creation and post-creation tasks

1. Basic administration tasks

1. Starting and stopping RAC instances
2. Managing database configurations
3. Applying changes across RAC instances

2. User and security management in RAC

1. Creating and managing database users
2. Configuring roles and privileges
3. Ensuring security in a RAC environment

3. Backup and recovery strategies

1. RAC-specific backup considerations
2. Using RMAN for backups in RAC
3. Recovery scenarios and strategies

1. Tools and techniques for monitoring RAC performance

1. Enterprise Manager Cloud Control
2. Automatic Workload Repository (AWR)
3. Active Session History (ASH) reports

2. Identifying and resolving performance bottlenecks

1. Diagnosing common RAC issues
2. Analyzing system and SQL performance
3. Addressing network and interconnect problems

3. Tuning RAC for optimal performance

1. Optimizing database parameters
2. Tuning SQL and application workloads
3. Using Automatic Database Diagnostic Monitor (ADDM)

1. Configuring failover and load balancing

1. Setting up Transparent Application Failover (TAF)
2. Configuring client-side and server-side load balancing
3. Managing connection pools

2. Managing service levels with Oracle RAC

1. Creating and managing services
2. Service-level agreements and performance monitoring
3. Workload management with services

3. Implementing high availability solutions

1. Using Data Guard with RAC
2. Integrating RAC with Oracle Cloud Infrastructure for disaster recovery
3. Best practices for ensuring high availability

1. Patch management process

1. Types of patches and their applicability
2. Preparing for patch application
3. Steps for applying patches to RAC environments

2. Strategies for upgrading RAC environments

1. Planning and preparation for upgrades
2. Performing rolling upgrades
3. Post-upgrade considerations and verification

3. Best practices for patching and upgrading

1. Testing patches in a non-production environment
2. Managing downtime and communication
3. Verifying system stability and performance post-upgrade

1. Overview and configuration of RAC One Node

1. Introduction to RAC One Node
2. Configuring RAC One Node for high availability
3. Managing RAC One Node databases

2. Managing RAC One Node databases

1. Online database relocation
2. Converting a RAC One Node database to a RAC database
3. Monitoring and tuning RAC One Node databases

3. Transitioning between single-instance and RAC databases

1. Scenarios for transitioning
2. Steps for conversion
3. Considerations and best practices

1. Introduction to multitenant architecture

1. Concepts and benefits of multitenant architecture
2. CDB and PDB architecture overview

2. Configuring and managing multitenant container databases (CDB) with RAC

1. Creating and configuring CDBs and PDBs in a RAC environment
2. Managing PDBs in RAC
3. Backup, recovery, and cloning of PDBs

3. Best practices for multitenant environments

1. Resource management in a multitenant architecture
2. Security considerations for CDBs and PDBs
3. Monitoring and tuning multitenant databases

1. Understanding policy-managed databases

1. Difference between policy-managed and administrator-managed databases
2. Benefits of policy management in RAC

2. Configuring and administering policy-managed RAC databases

1. Setting up and configuring policy-managed databases
2. Managing server pools
3. Policy-based management tasks

3. Advantages and use cases

1. Flexibility and simplicity in database management
2. Use cases for policy-managed databases
3. Transitioning between administrator-managed and policy-managed databases

1. Flex Cluster architecture and components

1. Introduction to Flex Clusters
2. Key components and their functionality
3. Differences between standard and Flex Clusters

2. Configuring and managing Flex Clusters

1. Setting up a Flex Cluster
2. Managing nodes in a Flex Cluster
3. Scalability and management considerations

3. Scalability and performance considerations

1. Advantages of Flex Clusters for scalability
2. Performance optimization in Flex Clusters
3. Best practices for Flex Cluster management

1. Procedures for adding a node to RAC

1. Planning and preparation
2. Step-by-step process for adding a node
3. Verifying the addition of a node

2. Removing a node from a RAC cluster

1. Reasons for node removal
2. Steps for safely removing a node
3. Cleanup and reconfiguration after node removal

3. Considerations for cluster modification

1. Impact on performance and availability
2. Communication and documentation
3. Testing and validation

1. Concepts of physical standby databases in RAC

1. role and benefits of physical standby databases
2. architecture of physical standby in a RAC environment

2. Steps for creating and managing standby databases

1. preparation and prerequisites
2. creating a physical standby database
3. managing and monitoring standby databases

3. Data protection and disaster recovery strategies

1. using Data Guard with RAC for disaster recovery
2. failover and switchover operations
3. best practices for data protection

1. New features and enhancements in Oracle RAC 19c

1. key new features and improvements
2. benefits of upgrading to RAC 19c

2. Installation and configuration process for RAC 19c

1. prerequisites and preparation
2. installation steps and configuration
3. post-installation tasks and checks

3. Migrating to Oracle Database RAC 19c

1. planning the migration
2. performing the migration
3. verifying and optimizing the new environment