Oracle Database 11g Release 2 DBA - Part II

5 Day Course
Hands On
Code O11GDBAII

Book Now - 1 Delivery Method Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online

Overview

This Oracle Database 11g Release 2 DBA - Part II course introduces the delegate to advanced administration tasks. Participants will learn how to plan and implement a backup and recovery strategy using Recovery Manager. They will also learn how to control database resources using the Resource Manager; how to automate administration tasks with the Scheduler and how to carry out performance monitoring and tuning.

The delegate will practise:

  • Planning a backup strategy and a disaster recovery strategy
  • Altering a database to archivelog and noarchivelog modes
  • Managing memory
  • Using Recovery Manager to perform backups and restorations
  • Using Flashback technology to diagnose and repair a database
  • Reviewing database logs for diagnostic purposes
  • Using Database advisors and views to monitor and improve database performance
  • Controlling database resources using Resource Manager
  • Automating management tasks with the Scheduler

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Hide all

Backup and Recovery Considerations (6 topics)

  • Oracle Suggested Backup Strategy
  • Plan and Implement a Backup and Recovery Strategy
  • Define a Backup Strategy
  • Define a Disaster Recovery Plan
  • The Advantages and Disadvantages of Different Backup Methods
  • Test a Backup and Recovery Plan

Oracle Recovery Structures and Processes (4 topics)

  • Architectural Components of Backup and Restore
  • Redo Logs, Checkpoints and Archives
  • Multiplexing Control Files and Redo Logs
  • Types of Database Failure

Memory Management (6 topics)

  • Automatic Shared Memory Management
  • PGA Memory Management
  • Automatic Memory Management
  • The Memory Advisor
  • Memory Allocation Advisors
  • Memory Management Data Dictionary Views

Using Archivelog and Noarchivelog Modes (5 topics)

  • The Archive Modes of a Database
  • Altering the Archive Mode of a Database
  • Configuring Multiple Archival Destinations
  • Configuring Multiple ARCH Processes
  • Data Dictionary Tables for Archiving

Troubleshooting Utilities (12 topics)

  • Database Synchronization
  • Using Log and Trace Files to Diagnose Problems
  • Detecting Block Corruption
  • DB_BLOCK_CHECKSUM
  • DB_BLOCK_CHECKING
  • The ANALYZE Command
  • The DBMS_REPAIR Package
  • Use DBVERIFY to Validate the Database File Structure
  • Block Media Recovery
  • Automatic Diagnostic Repository (ADR)
  • The ADR Command Line Tool (ADRCI)
  • The Health Monitor

Recovery Manager Overview (4 topics)

  • Overview of Recovery Manager
  • RMAN Features and Components
  • Connect to RMAN
  • Start Up and Shut Down a Target Database Using RMAN

Create a Recovery Catalog (9 topics)

  • Recovery Catalog Overview
  • Create a Recovery Catalog
  • Use a Flashback Recovery Area
  • Register and Unregister a Database
  • Control File Information
  • RESYNC CATALOG command
  • Virtual Private Catalogs
  • Merge Catalogs
  • Backup a Recovery Catalog

Backing up with RMAN (10 topics)

  • Channel Allocation
  • The Configure Channel Command
  • Types of RMAN Backup
  • Recovery Manager Commands
  • Performing Backups with RMAN
  • The Backup Command
  • The Copy Command
  • Backup File Image Copies
  • Perform Full, Incremental and Cumulative Backups
  • Use Data Dictionary Tables

Maintain a Recovery Catalog (8 topics)

  • Reset Database Command
  • Change the Availability Status of Backups and Copies
  • Catalog Backups Made with Operating System Commands
  • Generate Reports and Lists
  • Configuration Values
  • Cross Check Backups and Copies
  • Delete Backups
  • Drop Database and Archival Backups

Restore and Recover with RMAN (14 topics)

  • Overview of Restore
  • The Restore Command
  • Restore a Database in Noarchivelog Mode
  • Restore and Recover a Database in Archivelog Mode
  • Incomplete Recovery using Until Time and Until Sequence
  • Restore and Recover a Tablespace
  • Automatic tempfile Recovery
  • Recover a Datafile Not Backed Up
  • Recover a Lost Redo Log Group
  • Re-create a Password Authentication File
  • Apply Incremental Backups to Restore Datafile Image Copies
  • The Switch command
  • The Data Recovery Advisor (DRA)
  • Restore and Recover the Database on a New Host

Create aa Duplicate Database with RMAN (8 topics)

  • Overview of Database Duplication
  • Database Duplication
  • Duplication Options
  • Create Files for the Duplicate Database
  • Prepare an Auxiliary Instance for Duplication
  • Create a Duplicate Database
  • Clone a Running Database without a Backup
  • Targetless duplication of a database

Manage Space for the Database (2 topics)

  • Transport Tablespaces
  • Transport Databases

Monitor, Tune RMAN (8 topics)

  • Recovery Manager Tuning Overview
  • Tuning RMAN Backup Performance
  • Synchronous and Asynchronous I/O
  • Instance Recovery Performance Tuning
  • RMAN Messages
  • Troubleshoot RMAN
  • RMAN Detected Block Corruptions
  • Performance impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION

Flashback (13 topics)

  • Configure and Use Flashback Database
  • Monitor Flashback Database
  • Flash Recovery Area Space Usage
  • Flashback Query
  • Retrieve Row History with Flashback Versions Query
  • Audit or Recover from Transactions with Flashback Transactions Query
  • Flashback Table
  • Recover Dropped Tables with Flashback Drop
  • The Recycle Bin
  • Recover Tables to a Point in Time with Flashback Table
  • Flashback Database
  • Flashback Restore Points
  • Flashback Transaction Backout

Oracle Total Recall (4 topics)

  • Overview of Oracle Total Recall
  • Manage Flashback Archives
  • Flashback Data Archive and Auditing
  • Flashback Data Archive Uses

Automate Tasks with the Scheduler (13 topics)

  • Introduction to the Scheduler
  • Scheduler Related Parameters
  • Access Rights
  • Create a Program
  • Drop a Program
  • Create a Schedule
  • Create a Job
  • Job Classes
  • Windows
  • Window Group
  • Monitoring and Logging
  • Use Time Based, Event Based and Complex Schedules
  • Multi Destination Jobs

Manage Space in Segments (6 topics)

  • Tablespace Monitoring
  • Segment Management Enhancements
  • Segment Advisor
  • Segment Space Estimation
  • Online Segment Shrink
  • Proactive Tablespace Management

Manage Space in Blocks (3 topics)

  • Free Space Management
  • Monitor Space
  • Compress Data

Manage Database Performance (6 topics)

  • Tuning Activities
  • Use Statistic Preferences
  • Optimizer Statistics Collection
  • Monitor The Performance of Sessions And Services
  • Automatic Workload Repository (AWR)
  • The Benefits of Automatic Database Replay

Database Performance by SQL Tuning (4 topics)

  • Application and SQL Tuning
  • SQL Tuning Advisor
  • SQL Access Adviso
  • SQL Performance Analyzer

Automatic Storage Management (10 topics)

  • Overview of ASM
  • ASM Instance Creation
  • SYSASM Role
  • Administer ASM Disk Groups
  • ASM Files
  • ASM Startup and Shutdown
  • ASM Data Dictionary Views
  • Migrate a Database to ASM Using RMAN
  • The ASM Command Line Tool
  • Use 4KB Sector Disks

Managing Resources with Resource Manager (10 topics)

  • Overview of the Database Resource Manager
  • Create Resource Plans
  • Create Resource Consumer Groups
  • Create Resource Plan Directives
  • Limit CPU Utilization at the Database Level
  • Instance Caging
  • Control Resources by User Groups
  • Specify an Instance Plan
  • Monitor the Resource Manager
  • Data Dictionary Views

Prerequisites

A working knowledge of Oracle SQL and Oracle Database Administration. This can be obtained by attendance on the pre-requisite courses. Knowledge of PL/SQL would be beneficial.

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

Relevant Certifications

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections