Oracle 10g/11g Database Administration I Part 2

 

Course Description

 

In this Oracle database administration online training course, Part 2 of a two part series, you will explore how an Oracle Database applies 'grid computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. Students will learn how to install, administer and maintain an Oracle 10g or 11g database in an effective and efficient manner. Training topics such as performance monitoring, database security and backup and recovery techniques are covered. This Oracle training will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.

 

Once you have completed Oracle 10g/11g Database Administration I Part 2 the next course you will want to take is Oracle 10g/11g Database Administration II Part 1. The Oracle 10g/11g Database Administration II is a 2 part series that will enhance your knowledge further with more advance Oracle database topics. Click here to learn more about Oracle 10g/11g Database Administration II Part 1 and Part 2.

 

In This Course You Will Learn How To:

 

 

  • Explain Oracle's architectural components.
  • Demonstrate how to use Oracle's universal installer and configuration assistants.
  • Identify the different interfaces to an Oracle database.
  • Describe the different database control and storage structures.
  • Explain how to use schema and user management tools.
  • Contrast the different techniques for importing data to an Oracle database and exporting data from an Oracle database.
  • Describe PL/SQL declarations, code and exceptions.
  • Discuss Oracle's password security and database auditing features.
  • Configure Oracle's default user account features.
  • Configure and tune Oracle's Listener and Net Services features.
  • Learn how to establish, tune and monitor Oracle's Shared Server configuration.
  • Explain how to manually and automatically monitor the performance of an Oracle database.
  • Describe how to use Oracle's advisors to help tune and monitor database performance.
  • Show how to tune and administer Oracle's database undo management.
  • Discover how Oracle detects and resolves locking conflicts.
  • Learn the roles of control files, data files and redo log files in database backup and recovery.
  • Describe the implications of running your database in NOARCHIVELOG mode and ARCHIVELOG mode on database backup and recovery.
  • Discuss the different types of database backups.
  • Differentiate the differences between user-managed and server-managed backups.
  • Contrast the differences between database restoration and database recovery.
  • Illustrate the importance of database incarnations in database recovery.

 

Prerequisites

 

You need to have equivalent Oracle 9i database experience and have taken Oracle 10g/11g Database Administration I Part 1 or have taken the following courses:

  • Oracle 10g/11g: Introduction to SQL
  • Oracle 10g/11g: Advanced SQL
  • Oracle 11g PL/SQL Programming Part 1
  • Oracle 11g PL/SQL Programming Part 2
  • Oracle 10g/11g Database Administration I Part 1

Outline

 

Module 00: Oracle 10g/11g Database Administration I Part 2 Online Training - Course Introduction

 

Module 01: Oracle Shared Server

  • Architecture
  • Benefits and Features

 

Module 02: Configuration, Tuning and Monitoring

  • Oracle Shared Server Configuration
  • Tuning the Oracle Shared Server
  • Demo: Tuning the Oracle Shared Server
  • Exercise: Tuning MAX_SHARED_SERVERS
  • Monitoring the Oracle Shared Server
  • Exercise: Tuning Shared Servers

 

Module 03: Database Performance Monitoring, Part 1

  • Database Statistics: Manual vs. Automatic
  • Demo: Viewing Database Statistics
  • Exercise: Database Statistics
  • Exercise: V$OSSTAT View
  • Analyzing Objects

 

Module 04: Database Performance Monitoring, Part 2

  • Validating Database Structure
  • Demo: Validating Database Structure
  • Exercise: Validating Structure
  • Validating System Objects

 

Module 05: Database Maintenance Techniques

  • Alerts
  • Exercise: Alerts
  • Enterprise Manager
  • Threshold Information
  • Demo: Recovering from Non-Critical Losses
  • Exercises: Threshold Alerts and Views

 

Module 06: Using Advisors

  • SQL Access Advisor Package
  • Diagnostic Advisor
  • SQL Advisor
  • Tuning Advisor
  • Demo: Diagnostic and SQL Tuning Advisors
  • Exercise: SQL Tuning Advisor

 

Module 07: Using the Automatic Database Diagnostic Monitor (ADDM)

  • ADDM and AWR
  • ADDM Features
  • Reports
  • Demo: Automatic Database Management
  • Exercise: Working with ADDM

 

Module 08: Using the Workload Repository

  • Components
  • Snapshots
  • Views
  • Reports
  • Demo: Recovering from User Errors
  • Exercise: Generating an AWR report

 

Module 09: Configuring Database Undo Management

  • Definition of Database Undo Management
  • Exercises: Monitoring Database Undo
  • Configuration of Database Undo Management
  • Demo: Using Recovery Manager
  • Exercises: UNDO_RETENTION
  • Exercise: Undo Retention and Tablespace

 

Module 10: Administering Database Undo Management

  • Flashback
  • Flashback Mechanism
  • Flashback Query
  • Demo: Table Flashback
  • Exercise: Using Table Flashback
  • Undo Advisor

 

Module 11: Detecting Database Locking Conflicts

  • Detecting Database Locking Conflicts
  • Database Locking Modes

 

Module 12: Resolving Database Locking Conflicts

  • Detecting Deadlocks
  • Designing Avoidance of Deadlocks
  • Manual Locking

 

Module 13: Database Backup and Recovery Concepts

  • Overview
  • Control Files
  • Sizing Control Files

 

Module 14: Data and Log Files

  • Data Files
  • Exercise: Viewing Absolute File Numbers
  • DB_ Files
  • Log Files
  • Listing Data Files
  • Exercises: Listing and Viewing Files

 

Module 15: Writer and Archiver Processes

  • Log Writer Processes
  • Archiver Processes
  • Demo: Performing Critical Database Recoveries
  • Exercise: Adjusting Archiver Processes

 

Module 16: NOARCHIVELOG and ARCHIVELOG Mode

  • NOARCHIVELOG mode
  • ARCHIVELOG mode
  • Implications of ARCHIVELOG mode and Automatic Archival

 

Module 17: Constituent Elements

  • Overview
  • Data Files
  • Redo Logs
  • Control Files

 

Module 18: Database Backups

  • Consistent Backups vs. Inconsistent Backups
  • Full Backups vs. Incremental Backups
  • Demo: Performing Backups

 

Module 19: User-Managed Backups and Individual Tablespaces

  • Performing User-Managed Backups
  • Configuring a Flash Recovery Area
  • Demo: Configuring a Flash Recovery Area
  • Exercises: Flash Recovery Area
  • Backing Up Individual Tablespaces
  • Demo: Backing Up Individual Tablespaces
  • Exercise: Backing Up Individual Tablespaces

 

Module 20: Server-Managed Backups

  • Performing Server-Managed Backups (RMAN)
  • Demo: Configure RMAN for Complete Backup
  • Exercise: Configure RMAN for Complete Backup

 

Module 21: Types of Database Recovery

  • General Categories of Recovery
  • Datafile Recovery
  • Demo: Restoring a Data File by its File Number
  • Exercise: Restoring a Datafile by Filenumber
  • Using RMAN for Recovery
  • Fast Database Recovery
  • Using Flashback
  • Demo: Flashback Database
  • Exercise: Fast Database Recovery

 

Module 22: Using Flashback

  • Methodology
  • Flashback Drop
  • Recovering Objects from Recycle Bin
  • Demo: Recovering Objects from Recycle Bin
  • Exercise: Flashback Table

 

Module 23: Incarnations and Log Sequence Numbers

  • Incarnations
  • Log Sequence Numbers
  • Exercise: Log Sequence Numbers