Oracle Database 11g - Administration II

Displaying courses for United States [Change]

Overview

This course brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise.

Objectives

    This course brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise.
  • Automatic database management, monitoring and tuning facilities. Included are automatic management of storage space and memory resources within the database and the role of the Segment Advisor and Memory Advisors.
  • Automatic resumption of database operations even in the face of storage space allocation failures and errors.
  • Setting metric and alert thresholds for proactive database monitoring.
  • Using deferred segment creation to improve performance and establish efficient use of space.
  • Globalization features within the database to support applications in multiple languages,currencies, time zones and countries.
  • Utilizing diagnostic sources in troubleshooting database problems and employing the Fault Diagnosability Infrastructure, the Database Instance Health monitor and the Support Workbench to capture and process fault data.
  • Configuring the database to recover from a wide variety of failures. This includes configuring redo log files and the Flash or Fast Recovery Area.
  • Using Oracle flashback technology to recover from user errors and from database failures,including Flashback Data Archive and Flashback Transaction Backout as part of the Oracle Total Recall technology.

Audience

The primary target audiences for this course are:Database administratorsWeb server administratorsSystem administratorsImplementation specialistsData center support engineersSenior application designers and developers

Syllabus

Volume A: Advanced Database Administration

  • Managing Memory
  • Managing Storage & The Segment Advisor
  • Globalization
  • Diagnosing Database Problems
  • Recovery Concepts
  • Oracle Flashback Technology
  • Flashback Database & Flashback Data Archive

Volume B: Resource Manager & Scheduler

  • Managing Resources
  • Automating Tasks with the Scheduler (Basic)
  • Automating Tasks with the Scheduler (Advanced)
  • Managing Database Performance

Volume C: RMAN Backup & Recovery

  • Instance Recovery
  • Configuring RMAN
  • Backup with RMAN
  • RMAN Management with EM
  • User-Managed Recovery Operations
  • Recovery with RMAN
  • Using the RMAN Recovery Catalog
  • Database Duplication & Cloning
  • Advanced RMAN Capabilities
  • Transporting TableSpaces
  • Recovering From Corruption with Data Recovery Advisor

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 5 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Oracle Database
United States
This skill has an average salary of
US$95,719
and is mentioned in
3.54%
of job ads in this area.
Database
United States
This skill has an average salary of
US$78,335
and is mentioned in
13.80%
of job ads in this area.
Database Administration
United States
This skill has an average salary of
US$88,280
and is mentioned in
0.63%
of job ads in this area.
C
United States
This skill has an average salary of
US$82,050
and is mentioned in
6.25%
of job ads in this area.