Exadata Database Machine Administration Workshop (D73668GC10)

• Datenbankadministratoren
• Datenbankdesigner
• Data Warehouse-Administrator
• Systemadministratoren

Erforderliche Vorkenntnisse:

• General storage and systems administration

Empfohlene Vorkenntnisse:

• Oracle RAC/ASM DBA
• Oracle Enterprise Linux: System Administration
• Relevant Hardware Training
• Networking (inc. Infiniband)
• Oracle Enterprise Manager 11g: Grid Control Essentials
• Oracle 11g: RAC and Grid Infrastructure Overview Seminar Release 2
• Oracle Database 11g: Administration Workshop II Release 2 (D50079DE20)
• Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Release 2
• Oracle Database 11g: Administration Workshop I DBA Release 2 (D50102DE20)

• Describe the architecture of Database Machine and its integration with Oracle Database, Clusterware and ASM
• Complete the initial configuration of Database Machine
• Describe the key capabilities of Exadata and Database Machine
• Describe various recommended approaches for migrating to Database Machine
• Identify the benefits of using Database Machine for different application classes
• Monitor Database Machine health and optimize performance
• Configure Exadata I/O Resource Management

Introduction

• Course Objectives
• Audience and Prerequisites
• Course Contents
• Terminology
• Additional Resources
• Introducing the Laboratory Environment

Exadata Database Machine Overview

• Introducing Database Machine
• Introducing Exadata Storage Server
• Exadata Storage Server Architecture: Overview
• Exadata Storage Server Features: Overview
• Database Machine Capacity
• Exadata Storage Expansion Racks
• InfiniBand Network
• Database Machine Support: Overview

Exadata Database Machine Architecture

• Database Machine Architecture: Overview
• Database Machine Network Architecture
• InfiniBand Network Architecture
• X2-2 Full Rack Leaf Switch Topology
• Spine and Leaf Topology
• Scale Performance and Capacity
• Database Machine Software Architecture: Overview
• Disk Storage Entities and Relationships

Key Capabilities of Exadata Database Machine

• Classic Database I/O and SQL Processing Model
• Exadata Smart Scan Model
• Exadata Smart Storage Capabilities
• Exadata Hybrid Columnar Compression Data Organization
• Exadata Smart Flash Cache Intelligent Caching
• Storage Index with Partitions
• Database File System
• I/O Resource Management: Overview

Exadata Database Machine Initial Configuration

• Database Machine Implementation: Overview
• General Configuration
• Choosing the Right Protection Level
• Oracle Enterprise Manager Grid Control Configuration
• Database Machine Hardware Installation: Overview
• Configuring Oracle Exadata Database Machine: Overview
• Selecting the Database Server Operating System
• Deploying Solaris on the Database Servers

Exadata Storage Server Configuration

• Exadata Storage Server Administration: Overview
• Testing Storage Server Performance Using CALIBRATE
• Configuring the Exadata Cell Server Software
• Creating Flash-Based Grid Disks
• Creating Smart Flash Log
• Configuring ASM and Database Instances to Access Exadata Cells
• Exadata Storage Security: Overview
• Exadata Storage Security Implementation

I/O Resource Management

• I/O Resource Management: Overview
• IORM Architecture
• Getting Started with IORM
• Enabling Intradatabase Resource Management
• Setting Database I/O Utilization Limits
• Interdatabase Plans and Database Roles
• Using Database I/O Metrics
• IORM and Exadata Storage Server Flash Memory

Recommendations for Optimizing Database Performance

• Optimizing Performance
• Flash Memory Usage
• Compression Usage
• Index Usage
• ASM Allocation Unit Size
• Minimum Extent Size
• Optimizing Database Performance with Exadata

Using Smart Scan

• Exadata Smart Scan: Overview
• Smart Scan Requirements
• Monitoring Smart Scan in SQL Execution Plans
• Smart Scan Join Processing with Bloom Filters
• Other Situations Affecting Smart Scan
• Exadata Storage Server Statistics: Overview
• Exadata Storage Server Wait Events: Overview
• Using Smart Scan

Consolidation Options and Recommendations

• Consolidation: Overview
• Different Consolidation Types
• Recommended Storage Configuration for Consolidation
• Alternative Storage Configurations
• Cluster Configuration Options
• Isolating Management Roles
• Schema Consolidation Recommendations
• Maintenance Considerations

Migrating Databases to Exadata Database Machine

• Migration Best Practices: Overview
• Performing Capacity Planning
• Database Machine Migration Considerations
• Choosing the Right Migration Path
• Logical Migration Approaches
• Physical Migration Approaches
• Post-Migration Best Practices
• Migrating to Databases Machine Using Transportable

Bulk Data Loading Using Oracle DBFS

• Bulk Data Loading Using Oracle DBFS: Overview
• Preparing the Data Files
• Staging the Data Files
• Configuring the Staging Area
• Configuring the Target Database
• Loading the Target Database
• Bulk Data Loading Using Oracle DBFS

Exadata Database Machine Platform Monitoring Introduction

• Monitoring Technologies and Standards
• Simple Network Management Protocol (SNMP)
• Intelligent Platform Management Interface (IPMI)
• Integrated Lights Out Manager (ILOM)
• Exadata Storage Server Metrics, Thresholds, and Alerts
• Automatic Diagnostic Repository (ADR)
• Enterprise Manager Grid Control
• Enterprise Manager Database Control

Configuring Enterprise Manager Grid Control 11g to Monitor Exadata Database Machine

• Enterprise Manager Grid Control Architecture: Overview
• Grid Control Monitoring Architecture for Exadata Database Machine
• Configuring Grid Control to Monitor Exadata Database Machine
• Deploying the Oracle Management Agent
• Configuring ASM and Oracle Database Targets
• Deployment Overview for System Monitoring Plug-ins
• Recommended Plug-in Deployment Strategy
• Switch

Monitoring Exadata Storage Servers

• Exadata Metrics and Alerts Architecture
• Monitoring Exadata Storage Server with Metrics
• Monitoring Exadata Storage Server with Alerts
• Monitoring Exadata with Active Requests
• Monitoring Exadata Storage Server with Grid Control: Overview
• Monitoring Hardware Failure and Sensor State
• Monitoring Exadata Storage Server Availability
• Comparing Metrics Across Multiple Storage Servers

Monitoring Exadata Database Machine Database Servers

• Monitoring Database Servers: Overview
• Monitoring Hardware
• Monitoring the Operating System
• Monitoring Oracle Grid Infrastructure
• Monitoring Oracle Database
• Monitoring Oracle Management Agent

Monitoring the InfiniBand Network

• InfiniBand Network Monitoring: Overview
• Manually Monitoring the InfiniBand Switches
• Monitoring the InfiniBand Switches with Grid Control
• Monitoring the InfiniBand Switch Ports
• Monitoring the InfiniBand Ports on Database Machine Servers
• Monitoring the InfiniBand Fabric: Subnet Manager Master Location
• Monitoring the InfiniBand Fabric: Network Topology and Link Status

Monitoring Other Exadata Database Machine Components

• Monitoring the Cisco Catalyst Ethernet Switch
• Monitoring the Sun Power Distribution Units
• Monitoring the Avocent MergePoint Unity KVM Switch

Other Useful Monitoring Tools

• Exachk: Overview
• Running Exachk
• Exachk Output
• DiagTools: Overview
• Using ADRCI on Exadata Storage Servers
• Imageinfo: Overview
• Imagehistory: Overview
• OSWatcher: Overview

Backup and Recovery

• Using RMAN with Database Machine
• General Recommendations for RMAN
• Disk-Based Backup Strategy
• Disk-Based Backup Recommendations
• Tape-Based Backup Strategy
• Tape-Based Backup Architecture
• Connecting the Media Server Using Ethernet
• Backup and Recovery of Database Machine Software

Exadata Database Machine Maintenance Tasks

• Database Machine Maintenance: Overview
• Powering Database Machine Off and On
• Safely Shutting Down a Single Exadata Storage Server
• Replacing a Damaged Physical Disk
• Replacing a Damaged Flash Card
• Moving All Disks from One Cell to Another
• Using the Exadata Cell Software Rescue Procedure

Patching Exadata Database Machine

• Patching and Updating: Overview
• Maintaining Exadata Storage Server Software
• Maintaining Database Server Software
• Assisted Patching Using OPlan
• Maintaining Other Software
• Recommended Patching Process
• Test System Recommendations