Name: Oracle Database 11g: Administration Workshop II
Course Code: OR50079
Duration: 5
Scheduled Dates for OR50079
In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios.
Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices.
Target Audience
Database Administrators
Data Warehouse Administrator
Technical Consultant
Support Engineer
Key Topics
- Database Architecture and ASM
- Configuring for Recoverability
- Using the RMAN Recovery Catalog
- Configuring Backup Specifications
- Creating Backups
- Performing User-Managed Backup and Recovery
- Using RMAN to Perform Recovery
- Using RMAN to Duplicate a Database
- Performing Tablespace Point-in-time Recovery
- Monitoring and Tuning RMAN
- Using Flashback Technology
- Using Flashback Database
- Diagnosing the Database
- Managing Memory
- Managing Database Performance
- Using the Segment Advisor
- Managing Resources
- Automating Tasks with the Scheduler
- Administering the Scheduler
- Globalization
Objectives
- Back up and recover a database
- Configure Oracle Database for optimal recovery
- Administer ASM disk groups
- Use an RMAN backup to duplicate a database
- Automating Tasks with the Scheduler
Required Skills/Experience
- Oracle Database 11g: Administration Workshop I
Fee: $3,000.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC