Oracle Database 11g: RAC Administration

Cel szkolenia

In this course, students will learn about RAC database administration in the Oracle Grid Infrastructure environment. Students will learn to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL, and SQL*Plus. Students will study the new connection architecture and how to make those connections highly available. Backup and recovery issues relative to cluster database environments will also be studied.

Czas trwania

Konspekt

1. Real Application Clusters Database Installation
   • Installing The Oracle Database Software
   • Creating A Cluster Database
   • Post–database Creation Tasks
   • Single-Instance Conversion Using the DBCA
   • Single-Instance Conversion Using rconfig
   • Background Processes Specific to Oracle RAC
2. Oracle RAC Administration
   • Enterprise Manager Cluster Database Pages
   • Redo Log Files In A RAC Environment
   • Undo Tablespaces In A RAC Environment
   • Starting And Stopping RAC Databases And Instances
   • Initialization Parameters In A RAC Environment
   • Transparent Data Encryption and Wallets in RAC
   • Quiescing RAC Databases
3. Managing Backup and Recovery for RAC
   • Protecting Against Media Failure
   • Parallel Recovery in RAC
   • Archived Log File Configurations
   • RAC Backup and Recovery Using EM
   • Archived Redo File Conventions in RAC
   • Connections to Cluster Instances
   • Distribution of Backups
4. Monitoring and Tuning the RAC Database
   • Determining RAC-Specific Tuning Components
   • Tuning Instance Recovery in RAC
   • RAC-Specific Wait Events, Global Enqueues, and System Statistics
   • Implementing the Most Common RAC Tuning Tips
   • Using the Cluster Database Performance Pages
   • Using the Automatic Workload Repository in RAC
   • Using Automatic Database Diagnostic Monitor in RAC
5. Services
   • Configure and Manage Services in a RAC environment
   • Using Services with Client Applications
   • Using Services with the Database Resource Manager
   • Use Services with the Scheduler
   • Configuring Services Aggregation and Tracing
   • Managing Services From the Command Line
   • Managing Services With Enterprise Manager
6. Design for High Availability
   • Designing a Maximum Availability Architecture
   • Determine the Best RAC and Data Guard Topologies
   • Data Guard Broker Configuration files in a RAC Environment
   • Identifying Successful Disk I/O strategies

Wymagania

Required Prerequisites:

• Oracle Database Administration experience
• Oracle Database 11g: Administration Workshop I DBA Release 2
• Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Release 2

Suggested Prerequisites:

• Oracle Database 11g: Administration Workshop II DBA Release 2
• Oracle Database: Introduction to SQL

Certyfikaty

Lokalizacje

Prowadzący

Cena szkolenia

Materiały tradycyjne:
4686 PLN

Materiały CTAB:
5086 PLN