Oracle 11g Database Administration 2, Part 1

Start Oracle Administration Training Today!

• Set your own training schedule
• Watch as many times as you want 24/7 for 60 days following purchase
• Find out what Dashcourses' self-paced training is all about with no obligation - download Silverlight and View a Module
• Our self-paced training modules are viewable in Internet Explorer, Firefox and Safari

Training Description

This self-paced Oracle 11g Database Administration 2 course will explain advanced Oracle database topics. This technical training will provide an in-depth look into Oracle’s backup and recovery architecture as well as advanced DBA issues, advanced memory architecture, database advisors, and job scheduler. It will discuss facets of advanced database administration tasks.

Training Objectives

After completing this course you will be able to:

• Backup and Recover the Oracle Database
• Create a Recovery Catalog
• Use Oracle’s Flashback features
• Perform Oracle managed recoveries
• Perform User managed recoveries
• Identify and correct block corruption
• Configure and ASM Instance

Prerequisites

This course is designed for the Oracle database administrator with some experience.

Part 1 Outline

Module 00) Course Introduction

• Instructor Background
• Course Overview
• Course Objectives
• Course Prerequisites

Module 01) Introduction to Oracle

• Oracle Products
• Oracle Enterprise solutions
  • PeopleSoft
  • Oracle applications
  • JD Edwards
  • Siebel

Module 02) Database Management Products

• Oracle Management Products
  • Oracle Universal Installer
  • Oracle Enterprise Manager
  • Oracle Grid Solution
  • Oracle Database
    • Enterprise Edition
    • Standard Edition
  • Database Utilities
    • Database Configuration Assistant(DBCA)
    • Networking Assistant(NETCA)

Module 03) Oracle Architecture/ASM

• Oracle Instance
  • SGA
  • Background Processes
• ASM Instance Architecture

Module 04) ASM Disks/DiskGroups

• ASM Disks
• ASM Diskgroups
  • External
  • Normal
  • High

Module 05) Managing ASM

• Administer the ASM instance
  • dd Disks
  • Rebalance Disks
  • Disk Re Sync
• asmcmd

Module 06) Database Recovery

• Archivelog Mode
• NoArchivelog mode
• Configure Multiple Archivelog Destinations

Module 07) Flash Recovery Area

• Configure Flash Recovery Area
• Configure Flashback Database

Module 08) Recovery Catalog

• Definition of Recovery Catalog
• Recovery Catalog Meta Data
• Create the Recovery Catalog

Modules 09) Recovery Catalog Scripts and Databases

• Create recovery catalog scripts
• Register target databases
• Synchronizing the recovery catalog

Module 10) Administering the Recovery catalog

• Backup the Recovery Catalog
• Configure recovery catalog settings
• Create a virtual private catalog

Module 11) RMAN Backups

• BackupSets
• Image Copies
• NonCompressed backups
• Compressed backups
• Incremental Backups

Module 12) Rman Recovery

• Non-Critical Recovery
• Rman Restore/Recover Command

Module 13) Rman Critical Recovery

• Recover a Critial DataFile
• Incremental Recovery
• Image Copy Recovery
• Recovery to an alternate location

Module 14) Rman Incomplete Recovery

• Time Based Recovery
• Duplicate Database
• Restoring a controlfile
• Recovery in NoArchivelog Mode

Module 15) User Managed Recovery

• Complete database recovery
• Incomplete database recovery
• Backup the controlfile
• Backup Database in Archivelog/Noarchivelog

Module 16) Tuning RMAN

• Multiple Channels
• Long running backups
• Async I/O
• SYNC I/O

Module 17) Additional RMAN Features

• Cloning a Database
• Tablespace Point in Time Recovery(TSPITR)

Module 18) RecycleBin

• Define the Recyclebin
• Retrieve objects from the Recyclebin
• Define protected objects in the recyclebin

Module 19) Flashback Query

• Undo_retention
• Flashback Query
• Flashback Versions Query
• Flashback Transactions Query

Module 20) Flashback Data Archives

• Define flashback Data Archives
• Manage Flashback Data Archives
• Flashback Data Archives Administration

Module 21) Flashback Database

• Confgure Flashback database
• Monitor flashback database
• Perform flashback database

Part 2 Outline

Module 00) Course Introduction

Module 01) Oracle Advanced Memory Management

• Oracles Memory structure
  • Initialization parameters

Module 02) Automatic memory tuning

• Automatic Shared Memory Management (ASMM)
  • Memory_target
  • SGA_TARGET
• Auto-tuned memory parameters

Module 03) Program Global Area (PGA)

• Understanding the PGA
• Configuring automatic tuning for the PGA

Module 04) Database Tuning

• Understand the Advisor Framework
• Define the contents of the automatic database advisors

Module 05) Automatic Tuning Optimizer

• Sql Tuning Advisor
• Sql Tuning Sets
• Sql Tuning tasks

Module 06) Physical Sql Tuning

• Sql Access Advisor
• AWR
• ADDM
• SQL workloads

Module 07) Database Impact Advisors

• SQL Performance Analyzer
• Database Replay Process

Module 08) Memory Advisors

• Database Memory Advisors
• Mean Time to Recover Advisors
• Undo Management Advisors

Module 09) Oracle and Resumable Space

• Understanding Resumable Space
• Configuring the Database for Resumable Space allocation

Module 10) Reclaiming Space

• Reclaiming wasted spaced in tables
• Reclaiming wasted space in indexes
• Using the Automatic Segment Advisor

Module 11) Resource Management

• Understand the Resource Management Architecture
• Determine Allocation Methods

Module 12) Advanced Resource Management

• Understand the resource plans
• Create a resource plan

Module 13) Database Diagnostics

• Understand the Automatic Diagnostic Repository(ADR)
• Create the ADR
• ADR contents
• ADR Tools

Module 14) Database Health Checkers

• Oracle Support Workbench
• Oracle Health Monitor
• Identify and correct block corruption

Module 15) Database Recovery Advisors

• Benefits of using the Database Recovery Advisor (DRA)
• DRA features
• Using DRA

Module 16) Oracle Job Scheduler

• Understand the Job Scheduler framework
  • Program
  • Job
  • Schedule
  • Window

Module 17) Oracle Job Scheduling Options

• Time based jobs
• Event Driven Jobs

Module 18) Oracle Jobs

• Oracle pre-defined jobs
• Oracle pre-defined windows
• Oracle maintenance tasks

Module 19) Oracle Job Definitions

• Understanding job chains
• Dependant jobs
• Define and create Job Classes
• Define and create Windows
• Job Priorities

Module 20) Oracle Globalization Support

• Define Oracle Globalization Support
• Creating a database that uses globalization support
• Database character sets

Module 21) Timezone Support

• Define time zone support
• Use Oracle Locale Builder
• Support for databases in different time zones

Module 22)Course Summary

• Review Course objectives
• Review Course content