1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Hands-On Oracle Database 11g: Backup, Recovery and Server Tuning

 
Course: 928   Type: Hands-On Training   Duration: 4 Days
 
 

You Will Learn How To

  • Implement backup and recovery strategies to safeguard Oracle 11g databases
  • Configure the database for fault tolerance
  • Perform backup and recovery with Recovery Manager and Oracle Enterprise Manager
  • Maintain high availability with hot standby databases using Oracle Data Guard
  • Alleviate bottlenecks by tuning the Oracle 11g server memory components
  • Automate server tuning with the workload repository and diagnostics information

Course Benefits

Oracle Database 11g includes an increased range of tools that can be used to ensure full protection and recovery from failure. Those responsible for administering Oracle data need an in-depth knowledge of these tools to ensure optimal database availability. In this course you gain extensive hands-on experience with backup strategies and recovery techniques on Oracle databases. You employ a set of automated tuning tools to mitigate poor resource allocation and enhance database performance.

Who Should Attend

Those interested in safeguarding and tuning Oracle 11g databases. Knowledge of database administration at the level of Course 927, "Oracle Database 11g Administration," is assumed.

Hands-On Training

Hands-on exercises provide you with practical experience with Oracle 11g. Exercises include:
  • Building a fault-tolerant database
  • Enabling fast recovery with flashback database
  • Backing up and recovering databases with RMAN and OEM
  • Creating an Oracle 11g Data Guard environment
  • Activating the standby database
  • Improving the performance of commonly used queries with the result cache
  • Diagnosing and relieving lock contention with ADDM

Related Courses

 
Oracle is a registered trademark of Oracle Corporation. 		 

Upcoming Dates

Mar 17 - 20, 2009
 Washington, DC (Reston, VA)
Apr 7 - 10, 2009
 Washington, DC (Alexandria, VA)
Apr 14 - 17, 2009
 New York
Apr 28 - May 1, 2009
 Washington, DC (Rockville, MD)
May 19 - 22, 2009
 Chicago (Schaumburg)
Jun 16 - 19, 2009
 Los Angeles
Jun 23 - 26, 2009
 Washington, DC (Reston, VA)
Jul 14 - 17, 2009
 Washington, DC (Alexandria, VA)
Jul 21 - 24, 2009
 New York
Aug 4 - 7, 2009
 Washington, DC (Rockville, MD)
Aug 18 - 21, 2009
 Chicago (Schaumburg)

For complete schedule, please visit www.learningtree.com
 
http://www.learningtree.com/courses/928pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Hands-On Oracle Database 11g: Backup, Recovery and Server Tuning

 
Course: 928   Type: Hands-On Training   Duration: 4 Days
 
 
Course 928 Content
 

Safeguarding the Database

Ensuring resilience

  • Configuring and protecting redo logs and control files
  • Achieving total recall with Flashback Data Archive

Performing backups

  • Selecting appropriate backup strategies
  • Implementing hot and cold backups
  • Managing the Flash Recovery Area

Recovering the database

  • Database, tablespace and datafile recoveries
  • Flashing back the database to a recent point in time

Performing Backup and Recovery with Recovery Manager (RMAN)

Setting up Recovery Manager

  • Creating and merging recovery catalogs
  • Registering databases for recovery
  • Modifying catalog contents
  • Implementing virtual private catalogs
  • Configuring channels and redundancy

Backup operations with RMAN

  • Working with full and incremental backups
  • Scripting the backup activity
  • Listing and reporting on RMAN operations
  • Maintaining the redo stream with archival backups
  • Protecting very large datafiles with multisection backups

Performing automated recovery

  • Backup sets and image copies for restore and recovery
  • Rolling forward image copies with incremental backups
  • Tuning backup processing with block change tracking

Managing Backup and Recovery with Oracle Enterprise Manager (OEM)

Automating backup and recovery operations

  • Configuring default settings
  • Navigating the screens to perform backup and recovery

Repairing lost data with Data Recovery Advisor

  • Obtaining advice for repairing data failures
  • Executing repairs
  • Classifying and closing failures

Disaster Recovery with Data Guard

Establishing the standby environment

  • Creating and synchronizing the standby database
  • Controlling log shipping and redo apply mechanisms
  • Applying data protection policies
  • Physical vs. logical standby databases

Managing the standby database

  • Maintaining a read-only standby during managed recovery
  • Synchronizing the standby with incremental backups
  • Preserving the performance of the primary database

Moving operations to the standby

  • Failing over and switching to the standby facility
  • Achieving No-Data-Loss and delayed recovery

Configuring and Tuning the Oracle Server

Tuning the SGA

  • Maximizing the use of the shared pool
  • Tuning the buffer cache with the Buffer Cache Advisor
  • Reducing I/O with multiple buffer pools
  • Monitoring latch contention

Enhancing query performance with the result cache

  • Controlling result cache usage
  • Monitoring the result cache with DBMS_RESULT_CACHE

Oracle 11g Server Automated Tuning

Automatic Workload Repository (AWR)

  • Performing root cause analysis with the Automatic Database Diagnostics Monitor (ADDM)
  • Tracking session activity with Active Session History (ASH)
  • Handling logging and tracing with Automated Diagnostics Repository (ADR)
  • Gathering statistics with user-specified preferences

Automatic Memory Management (AMM)

  • Tuning memory with the memory advisors
  • Enabling total memory management with AMM

Generating workloads for predictive testing

  • Capturing workloads with Database Replay
  • Analyzing and evaluating the results of the replay session
 
http://www.learningtree.com/courses/928pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Hands-On Oracle Database 11g: Backup, Recovery and Server Tuning Tuition

 
Course: 928   Type: Hands-On Training   Duration: 4 Days
 
 

Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,800 10-Day Pass
$ 1,670 Training Passport
$ 1,625 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 Government Discount
 

 

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,670 per course
  • Savings as much as 45%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,625 per course
  • Save as much as 45%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $305 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learningtree.com/courses/928pf.htm