Canada IT Courses
ExitCertified US




ExitCertified - Excellence in IT Certified Education
 
IT education classes
IT training feature sheet
 
   
 
start > courses and registration > training feature sheet
Oracle Database 11g: Administration Workshop II
 
 
 
 
oracle certified training  
 
code. 11g-DBA2   length. 5 days
type. Instructor-Led   partner. Oracle
price.
$3,000  
 
 
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.

Learn To:

Back up and recover a database using RMAN and Enterprise Manager
Configure Oracle Database for optimal recovery for any environment
Identify burdensome database sessions and poorly performing SQL
Configure the database instance such that resources are allocated among sessions and tasks appropriately Schedule jobs to run inside or outside of the database


 
course schedule  
 
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.
   
Request course date Request on site training
 
who can benefit
  
 

Database Administrators
Support Engineer
Data Warehouse Administrator
Technical Consultant


 
prerequisites
  
 

Oracle Database 11g: Administration Workshop I New


 
skills gained
  
 

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




 
course content details  
 


  Database Architecture and ASM

Oracle Database Architecture Overview
ASM General Architecture
Creating an ASM Instance
Using Enterprise Manager to Manage ASM Users
ASM Storage Concepts
The ASMCMD Utility
ASM Scalability and Performance




  Configuring for Recoverability

Purpose of Backup and Recovery Functionality
Typical Backup and Recovery Tasks
Oracle Backup and Recovery Solutions
Using Recovery Manager (RMAN)
Using a Flash Recovery Area
Flash Recovery Area Space Management


  Using the RMAN Recovery Catalog

RMAN Repository Data Storage: Comparison of Options
Storing Information in the Recovery Catalog
Registering a Database in the Recovery Catalog
Recovery Catalog Resynchronization: Concepts
Using RMAN Stored Scripts
Backing Up and Recovering the Recovery Catalog
Using a Virtual Private Catalog




  Configuring Backup Specifications

Using RMAN to Create Backups
Configuring Persistent Settings for RMAN
Using Enterprise Manager to Configure RMAN Settings
Control File Auto-backups
Managing Persistent Settings
Configuring Devices for Backup
Configuring and Allocating Channels for Use in Backups
Configuring Backup Optimization




  Creating Backups

Creating an Oracle-Suggested Backup
Creating Backup Sets & Image Copies
Creating a Whole Database Backup
RMAN Backup Types
Monitoring Block Change Tracking
Creating Duplex Backup Sets
Archival Backups: Concepts
Encrypting Backups




  Performing User-Managed Backup and Recovery

Restoring and Recovering
Causes of File Loss
Critical Versus Non-critical
Recovering from a TEMPFILE Loss
Re-creating Indexes
Recovering from a Lost Index Tablespace
Authentication Methods for Database Administrators
Recovering a Read-Only Tablespace




  Using RMAN to Perform Recovery

Using RMAN RESTORE and RECOVER Commands
Performing Recovery Using Enterprise Manager
Recovery Using Incrementally Updated Backups
Perform a Fast Switch to Image Copies
Restoring and Recovering the Database on a New Host
Performing Disaster Recovery




  Using RMAN to Duplicate a Database

Using RMAN to Create a Duplicate Database
Creating a Duplicate Database
Creating an Initialization Parameter File for the Auxiliary Instance
Allocating Auxiliary Channels
Understanding the RMAN Duplication Operation
Using EM to Clone a Database
Cloning a Running Database




  Performing Tablespace Point-in-time Recovery

Tablespace Point-in-Time Recovery (TSPITR) Concepts
Tablespace Point-in-Time Recovery: Architecture
Understanding When to Use TSPITR
Determining the Tablespaces for the Recovery Set
Using Enterprise Manager to Perform TSPITR
Understanding TSPITR Processing
Troubleshooting RMAN TSPITR




  Monitoring and Tuning RMAN

Parallelization of Backup Sets
Monitoring RMAN Sessions
Interpreting RMAN Message Output
Using the DEBUG Option
Tuning RMAN
RMAN Multiplexing
Comparing Synchronous and Asynchronous I/O
Tape Subsystem Performance Rules




  Using Flashback Technology

Flashback Technology
Transactions and Undo
Guaranteeing Undo Retention
Preparing Your Database for Flashback
Flashback Drop and the Recycle Bin
Using Flashback Technology to Query Data
Possible Workflow
Flashback Transaction Wizard




  Using Flashback Database

Flashback Table
Enabling Row Movement on a Table
Enabling Row Movement on a Table
Flashback Database Architecture
Configuring Flashback Database
Performing Flashback Database Using EM
Flashback Database Considerations
Flashback Data Archive




  Diagnosing the Database

Automatic Diagnostic Workflow & Repository
Location for Diagnostic Traces
Viewing the Alert Log Using Enterprise Manager
The Support Workbench and Oracle Configuration Manager
Create a Service Request
Package and upload diagnostic data to Oracle Support
Incident Packaging Configuration
Health Monitor Overview & Data Recovery Advisor




  Managing Memory

Oracle Memory Structures
Automatic Memory Management Overview
Oracle Database Memory Parameters
Auto Memory Parameter Dependency
Automatic Shared Memory Management: Overview
Automatic PGA Memory Management
Using the Memory Advisor to Size the SGA
Memory Tuning Guidelines for the Library Cache




  Managing Database Performance

Tuning Activities
Performance Planning & Performance Tuning Methodology
Instance Tuning
Troubleshooting and Tuning Views
Automatic Workload Repository
SQL Tuning & SQL Advisors
Using the SQL Tuning Advisor
SQL Access Advisor: Overview




  Using the Segment Advisor

Space Management: Overview
Proactive Tablespace Monitoring
Thresholds and Resolving Space Problems
Monitoring Tablespace Space Usage
Shrinking Segments
Space Reclamation with ASSM
Automatic Segment Advisor
Minimum Compatibility Level




  Managing Resources

Database Resource Manager: Overview
Database Resource Manager Concepts
Accessing Resource Plans
Default Maintenance Resource Manager Plan
Creating Consumer Groups
Resource Allocation Methods for Resource Plans
Resource Allocation Methods for Resource Plans
Monitoring the Resource Manager




  Automating Tasks with the Scheduler

Simplifying Management Tasks
Key Components and Steps
Creating an Event-Based Schedule
Creating Complex Schedules
Creating Job Chains
Creating Job Chains




  Administering the Scheduler

Advanced Scheduler Concepts
Job Classes
Windows
Prioritizing Jobs Within a Window
Remote Jobs
Installing the Scheduler Agent
Dictionary Views Supporting Remote Jobs




  Globalization

Globalization Support Features
What Every DBA Needs to Know
Understanding Unicode
Database Character Sets and National Character Sets
Language- and Territory-Dependent Parameters
Linguistic Searching and Sorting
Case- and Accent-Insensitive Search and Sort
NLS Data Conversion with Oracle Utilities





 
Give your team direction. Authorized IT education.


ExitCertified - Oracle 100% Student Satisfaction


find a course
 
phone us
 
view course schedule





Give your team direction. Authorized IT education.

 
go to top
Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education
© 2008 ExitCertified. All rights reserved.
terms of use and disclaimer :: privacy policy :: webmaster :: link to us
   
Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware