Oracle Database 11g: Administration Workshop II Release 2 (German) Self-Study Course

Please note that audio for this course is in German.

This course takes the Database Administrator beyond the basic tasks covered in the first workshop. It will help you develop a much deeper understanding of possibly the most important job of a DBA: backup and recovery.

Learn To:

• Automate DBA tasks with the Scheduler.
• Diagnose and repair data failures with Flashback technology.
• Manage space to optimize database storage so you can respond to growing space requirements.
• Monitor and manage major database components, including memory, performance and resources.
• Secure the availability of your database using appropriate backup and recovery strategies.

Benefits to You

You'll learn the concepts and architecture that support backup and recovery, while exploring the step-by-step process to carry it out in various ways and situations. This includes how to define and test your own backup and recovery scenarios.

Manage Memory Effectively

As a DBA, you'll also learn how to manage memory effectively and conduct performance evaluation and tuning tasks. This includes using some of the advisors. Expert Oracle University instructors will help you dive into flashback technologies, scheduling jobs inside and outside of the database and controlling system resource usage.

Audience

• Database Administrators
• Technical Administrator
• Support Engineer
• Technical Consultant

Course Topics Oracle Database 11g Release 2: Database Architecture and Recovery Operations

• Oracle Database Architecture
• Backup and Recovery Operations

Oracle Database 11g Release 2: The RMAN Catalog and Creating Backups

• The RMAN Recovery Catalog
• Creating Backups with RMAN

Oracle Database 11g Release 2: Performing Restore and Recovery Tasks

• Restore and Recovery Tasks
• Performing User-Managed Backup and Recovery

Oracle Database 11g Release 2: Using, Monitoring and Tuning RMAN

• Using RMAN to Perform Recovery
• Monitoring and Tuning RMAN

Oracle Database 11g Release 2: Database Diagnostics and Flashback Technologies

• Diagnosing the Oracle Database
• Flashback Technologies

Oracle Database 11g Release 2: Managing Database Memory and Performance

• Managing Memory
• Managing Database Performance

Oracle Database 11g Release 2: Managing Database Resources and the Scheduler

• Managing Resources
• Task Automation and Administration

Oracle Database 11g Release 2: Managing Database Space and Duplication

• Oracle Database 11g Release 2: Managing Database Space and Duplication
• Duplicate Databases

Course Objectives

• Recognize the Oracle Database architecture with ASM, and the configuration and management DBA Tools
• Recognize the causes of file loss and how to recover files
• Identify how to configure backup and recovery functionality in Oracle Database 11g Release 2
• Recognize the benefits and uses of an RMAN recovery catalog and identify the steps for creating and configuring one
• Identify how to prepare a database for backup and then for perform and monitor various types of RMAN backups
• Recognize the steps for manually backing up, recovering and restoring a database
• Identify the options available when performing RMAN recoveries
• Identify ways to monitor and tune RMAN to reduce bottlenecks and balance backup and recovery operations
• Identify how to diagnose and repair database problems
• Identify how to use Flashback technologies to recover a database
• Recognize the memory components used in Oracle Database 11g, and configure AMM and ASMM
• Identify how to improve a database's performance by monitoring statistics, implementing recommendations from advisors, tuning SQL statements, and replaying workloads
• Identify how to use the Database Resource Manager to monitor and manage system resources to consumer groups
• Identify how to schedule and monitor event-based and time-based jobs and job chains in order to make the best use of resources
• Manage storage in a database by allocating and reclaiming space and by quickly moving large amounts of data to other databases
• Identify how to create a cloned copy of a database using RMAN and Enterprise Manager