Who should attend
- Database administrators
- Technical consultants
Prerequisites
- Oracle Database 11g Database Administration
- Oracle Database 11g: Administration Workshop I Release 2
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
Product Description
- 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