0845 450 6120

Oracle 11g Database Administrator Fundamentals Part II

iTrain's Oracle 11g Database Administrator Fundamentals Part II hands on course is been designed to explore the concepts and architecture that support backup and recovery, effective memory management, alongside some performance evaluation and tuning tasks

We don't currently have any courses listed for Oracle 11g Database Administrator Fundamentals Part II, would you like to view all courses for Oracle?

Learning Objectives

This intensive hands on course is designed to teach attendees the concepts and architecture that support backup and recovery, effective memory management, alongside some performance evaluation and tuning tasks

Course Content

Training Course Contents

Database Architecture and ASM

  • Oracle Database Architecture Overview.
  • ASM General Architecture
  • Creating an ASM Instance
  • ASM Storage Concepts
  • The ASMCMD Utility

Configuring for Recoverability

  • Backup and Recovery Functionality
  • Typical Backup and Recovery Tasks.
  • Oracle Backup and Recovery Solutions.
  • Causes of File Loss

User-Managed Backup & Recovery

  • Restoring and Recovering
  • Critical Versus Non-critical
  • Recovering from a TEMPFILE Loss
  • Recovering a Read-Only Tablespace

Configuring RMAN

  • Using RMAN to Create Backups
  • Configuring Persistent RMAN Settings.
  • Control File Auto-backups
  • 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
  • Archival Backups: Concepts

Using RMAN Recovery Catalog

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

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 Data

  • Creating a Duplicate Database
  • Creating an Initialization Parameter File for the Auxiliary Instance.
  • Allocating Auxiliary Channels
  • Understand RMAN Duplication
  • Using EM to Clone a Database
  • Cloning a Running Database

Point-in-time Recovery

  • Tablespace Point-in-Time Recovery (TSPITR) Concepts.
  • TSPITR Architecture.
  • 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

  • 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

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

Using Flashback Database

  • Flashback 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 (AMM) Overview
  • Oracle Database Memory Parameters
  • Auto Memory Parameter Dependency
  • Automatic Shared Memory Management (ASMM) 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 & Tuning Methodology
  • Instance Tuning
  • Troubleshoot and Tune 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

Scheduler

  • Simplifying Management Tasks
  • Key Components and Steps
  • Programs
  • Schedules
  • Jobs and Job classes
  • Windows

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Our Customers Include