Oracle Database 11g: Administration Workshop II Release 2 (Self-Study Course)
Quién debería asistir
Database administrators
Technical consultants
Prerrequisitos
Oracle Database 11g Database Administration
Oracle Database 11g: Administration Workshop I Release 2
Objetivos del curso
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
Descripción del Producto
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