Who should attend
- Data Warehouse administrators
- Database designers
- Technical consultants
- System analysts
- Database administrators
Prerequisites
- Oracle Database Administration experience
- Oracle Database 11g: Administration Workshop I Release 2
Course Objectives
- Install Oracle 11gR2 software and create RAC database
- Manage RAC databases
- Manage backup and recovery for RAC
- Determine RAC-specific tuning components
- Configure and manage services in a RAC environment
- Describe high availability architectures
Product Description
- 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
- 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
- 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
- Channel Connections to Cluster Instances
- Distribution of Backups
- 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
- 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
- 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