Oracle Database 11g: Administration Workshop II (Self-Study Course)
Who should attend
Database designers
Developers
Database administrators
Prerequisites
Oracle Database 11g: Administration Workshop
Working knowledge of SQL
Course Objectives
Recognize the steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks
Steps for making sure that any changes to a database can be easily reversed,using Oracle Database 11g's flashback features.
Identify the steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks
Identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads,
Identify ways to ensure that resources are being put to best use and database jobs are performed when they should be, using the Database Resource Manager and the Scheduler
Recognize the steps for utilizing Oracle Database 11g's globalization support features to ensure that information and data is displayed in a user's native language
Recognize steps for configuring aspects of backup and recovery functionality in Oracle Database 11g
Identify the steps for preparing a database for backup and then for performing various types of RMAN backups and monitoring them
Identify ways to use RMAN to ensure that data is not lost in Oracle Database 11g
Recognize the structural elements in Oracle Database 11g's architecture and the steps for managing storage using disk groups
Product Description
Oracle Database 11g: Database Architecture and ASM
Database Architecture and ASM Overview
Disk Group Management and Storage
Oracle Database 11g: Configuring for Recovery
Recovery Operations
The RMAN Recovery Catalog
Oracle Database 11g: Configuring for Backups
Backup Specifications and RMAN
Performing User-Managed Backup and Recovery
Oracle Database 11g: Using RMAN for Recovery
Using RMAN to Perform Recovery
Duplicate Databases and TSPITR
Oracle Database 11g: Supporting RMAN and Using Flashback Technology
Monitoring and Tuning RMAN
Using Flashback Technology
Oracle Database 11g: Diagnosing the Database and Managing Memory
Diagnosing the Database
Managing Memory
Oracle Database 11g: Database Performance and Space Management
Managing Database Performance
Space Management
Oracle Database 11g: Managing Resources and Task Automation