Oracle 11g Database Administration 2, Part 2

Start Oracle Administration Training Today!

• Dashcourses has partnered with GogoTraining to bring you this Self-paced Course
• 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

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