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
- Managing Database Resources
- Task Automation and Administration
- Oracle Database 11g: Globalization
- Globalization Support