Oracle Database 11g: Administration Workshop II - Self-Study Course

Ensuring data integrity and database availability is critical to any organization’s well-being. This course is designed to teach you about the concepts and architecture that support backup and recovery of Oracle Database 11g.

Learn To:

• Explore the structural elements of Database 11g.
• Manage storage using disk groups.
• Configure all aspects of backup and recovery functionality.
• Prepare a database for backup.
• Perform various types of backup.
• Monitor backup performance.
• Optimize a database.

Explore Other Database 11g Features

By investing in this course, you'll learn about using RMAN to maintain data integrity, as well as Automatic Diagnostic Recovery, Support Workbench and health checks to diagnose and repair database problems. The Database Resource Manager, Scheduler and globalization support is also covered here.

Audience

• Database Designers
• Developer
• Support Engineer
• Technical Administrator
• Database Administrators

Course Topics 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

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