Oracle Database 12c R2: RAC Administration Ed 2
Duration : 4 Days (32 Hours)
Overview
Course Details
Prerequisites
Oracle Database 12c R2: RAC Administration Ed 2 Course Overview:
The Oracle Database 12c R2: RAC Administration training course provides a comprehensive overview of Oracle RAC database architecture. Throughout the training, participants will gain knowledge about Global Resources and Cache Fusion, essential components of Oracle RAC. Additionally, learners will be introduced to the Oracle Database Exadata Cloud Service, exploring its capabilities and features. The course equips attendees with the necessary skills to effectively administer Oracle RAC databases and utilize Oracle Database Exadata Cloud Service.
Intended Audience:
- Administrator
- Database Administrators
Learning Objectives of Oracle Database 12c R2: RAC Administration Ed 2:
- Configuring Oracle RAC Reader Nodes
- Defining redo log files & undo tablespaces in a RAC environment
- Converting a single-instance Oracle Database to RACs
- Installing the Oracle Database software
- Creating a cluster database
- Defining local temporary tablespaces in a RAC environment
- Modifying initialization parameters in a RAC environment
- Performing post-database-creation tasks
- Configuring RMAN for the RAC environment & RAC database to use ARCHIVELOG mode and the fast recovery area
Module 1: Grid Infrastructure: Overview
- Clusterware Characteristics
- RAC and Flex ASM
- Oracle Clusterware
- What is a Flex Cluster ?
- Hardware and Software Concepts (High level)
- What is a Cluster?
Module 2: RAC Databases Overview & Architecture
- Oracle RAC One Node (High level)
- Benefits of Using RAC
- Overview of Oracle RAC
- Global Resources
- Scaleup and Speedup
- I/O Throughput Balanced
- Cluster-Aware Storage Solutions
Module 3: Installing and Configuring Oracle RAC
- Post-installation Tasks
- Single Instance to RAC Conversion using DBCA and rconfig
- Creating the Cluster Database
- Installation options
- Configuring Oracle RAC Reader Nodes
- Installing the Oracle Database Software
Module 4: Oracle RAC Administration
- Parameters and RAC – SPFILE, Identical and Unique Parameters
- RAC Alerts
- RAC Metrics
- Use Enterprise Manager Cluster Database Pages
- Local Temporary Tablespaces
- Redo Threads
- Separation of Duty for Administering Oracle RAC
- Undo Tablespaces
Module 5: Upgrading and Patching Oracle RAC
- Merge Patches
- Performing Out of Place Database Upgrades
- Ovierview of Upgrades and Patching
- Post Upgrade Tasks
- Planning and Preparing for Upgrade
- PSU, CPU and Interim Patches
- Release and Patch Set Upgrades
Module 6: Managing Backup and Recovery for RAC
- Redo Threads and Archive Logs Configurations and Admin
- Parameter Settings Affecting Parallel Recovery and MTTR
- Instance Failure And Recovery In RAC – LMON and SMON
- RAC and the Fast Recovery Area
- RMAN Configuration
- RMAN Admin for RAC: Channels, Instances, Backup Considerations
Module 7: RAC Global Resource Management and Cache Fusion
- Row cache management
- Buffer Cache Management Requirements
- Undo and read consistency considerations in RAC
- Multi-block read considerations in RAC
- Globally Managed Resources and Management
- Buffer cache fusion
- Accessing single blocks in RAC
- Library Cache Management
Module 8: RAC Database Monitoring and Tuning
- OCPU and Wait Time Latencies
- Common RAC Tuning
- RAC specific V$ Views
- Wait Events for RAC
- Monitoring RAC with Cluster Health Advisor (CHA)
- Session and System Statistics
- Automatic Database Diagnostic Monitor for RAC
Module 9: Managing High Availability of Services in a RAC Environment
- Oracle Services
- Managing Services
- Service-Oriented Buffer Cache Access
- Services and Connection Load Balancing
- Creating Services
- Use Services with Client Applications
- Services for Policy – and Administrator-Managed Databases
- Services and Transparent Application Failover
Module 10: Managing High Availability of Connections
- Client-Side Load Balancing
- Server-Side Load Balancing
- Types of Workload Distribution
- Configuring the Server-Side ONS
- The Load Balancing Advisory FAN Event
- Server-Side Callouts
- Fast Application Notification
- Runtime Connection Load Balancing and Connection Pools
Module 11: Application Continuity
- Side Effects
- Restrictions
- What problem does it solve?
- How AC works
- Benefits of AC
- Application requirements
- What is AC?
- AC Architecture
Module 12: RAC One Node
- Use DBCA to convert a single instance database to a RAC One Node database
- RAC One Node Concepts
- Adding Oracle RAC One Node Database to an Existing Cluster
- Convert an Oracle RAC database to a RAC One Node database
- Online database migration
- Convert an Oracle RAC One Node database to a RAC database
Module 13: Oracle Database In-Memory in RAC
- Architecture of In-Memory Column Store
- Implementing In-Memory FastStart
- Implementing In-Memory Column Store in RAC
Module 14: Multitenant Architecture and RAC
- Oracle RAC and Multitenant Configuration
- CDB in a Non-RAC Environment
- Connection to a Non-RAC CDB
- Multitenant Architecture: Benefits
- Non-CDB Architecture
- Oracle RAC and Multitenant Architecture
- Containers
- Terminology and Data Dictionary Views
Module 15: Quality of Service Management
- QOS Management concepts
- QoS Management components
- QoS Management functionality
- Describe the benefits of using QoS Management
Module 16: Oracle Database Exadata Cloud Service Overview
- REST APIs
- Management Responsibilities
- Introducing Exadata Cloud Service
- Simple Web-Based Provisioning & Management
- Migrating to Exadata Cloud Service
- Storage Configuration & Management Details
- Service Architecture & Availability
Oracle Database 12c R2: RAC Administration Ed 2 Course Prerequisites:
- Oracle Database 12c R2: Clusterware Administration
Suggested but not mandatory
- Working knowledge of Oracle Database 11g: Release 2, including Clusterware, ASM, and RAC
- Working knowledge of Oracle Clusterware, ASM & RAC on Linux
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!