Course 282:
Oracle Backup, Recovery, and Tuning

(5 days)

 

Course Description

Oracle Database includes an increased range of tools that can be used to ensure full protection and recovery from failure. Those responsible for administering Oracle data need an in-depth knowledge of these tools to ensure optimal database availability. In this course, you gain extensive hands-on experience with backup strategies and recovery techniques on Oracle databases including a concentration on Oracle Recovery Manager. In this course, you will employ a set of automated tuning tools to mitigate poor resource allocation and enhance database performance.

Learning Objectives

  • Implement backup and recovery strategies to safeguard Oracle databases
  • Configure the database for fault tolerance
  • Perform backup and recovery with Recovery Manager and Oracle Enterprise Manager
  • Maintain high availability with hot standby databases using Oracle Data Guard
  • Alleviate bottlenecks by tuning the Oracle server memory components
  • Automate server tuning with the workload repository and diagnostics information

Who Should Attend

Those interested in safeguarding and tuning Oracle databases.

Prerequisites

Course 281: Oracle Database Administration, or equivalent knowledge of database administration is assumed.


Course Outline

Safeguarding the Database and Ensuring Resilience

  • Configuring and Protecting Redo Logs and Control Files
  • Achieving Total Recall with Flashback Data Archive

Basic Backup and Recovery Techniques

  • Identifying Possible Points of Failure
  • Selecting Appropriate Backup Strategies
  • Implementing Hot and Cold Backups
  • Managing the Flash Recovery Area
  • Recovering the Database
  • Database, Tablespace and Datafile Recoveries
  • Flashing Back the database to a Recent Point in Time

Performing Backup and Recovery with Recovery Manager (RMAN)

  • Creating and Merging Recovery Catalogs
  • Registering Databases for Recovery
  • Modifying Catalog Contents
  • Implementing Virtual Private Catalogs
  • Backup Operations with RMAN
  • Working with Full and Incremental Backups
  • Scripting the Backup Activity
  • Listing and Reporting on RMAN Operations
  • Protecting Very Large Datafiles with Multisection Backups
  • Performing Automated Recovery
  • Backup Sets and Image Copies for Restore and Recovery
  • Rolling Forward Image Copies with Incremental Backups
  • Tuning Backup Processing with Block Change Tracking

Automating Backup and Recovery with Oracle Enterprise Manager (OEM)

  • Configuring Default Settings
  • Navigating the Screens to Perform Backup and Recovery
  • Repairing Lost Data with Data Recovery Advisor
  • Obtaining Advice for Repairing Data Failures
  • Executing Repairs, Classifying and Closing Failures

Disaster Recovery with Data Guard

  • Establishing the Standby Environment
  • Creating and Synchronizing the Standby Database
  • Controlling Log Shipping and Redo Apply Mechanisms
  • Applying Data Protection Policies
  • Physical vs. Logical Standby Databases
  • Managing the Standby Database
  • Maintaining a Read-Only Standby During Managed Recovery
  • Synchronizing the Standby with Incremental Backups
  • Moving Operations to the Standby
  • Failing Over and Switching to the Standby Facility
  • Achieving No-Data-Loss and Delayed Recovery

Configuring and Tuning the Oracle Server

  • Tuning the SGA
  • Maximizing the Use of the Shared Pool
  • Tuning the Buffer Cache with the Buffer Cache Advisor
  • Reducing I/O with Multiple Buffer Pools
  • Monitoring Latch Contention
  • Enhancing Query Performance with the Result Cache
  • Controlling Result Cache Usage
  • Monitoring the Result Cache with DBMS_RESULT_CACHE

Oracle Server Automated Tuning

  • Automatic Workload Repository (AWR)
  • Performing Root Cause Analysis with the Automatic Database Diagnostics Monitor (ADDM)
  • Tracking Session Activity with Active Session History (ASH)
  • Handling Logging and Tracing with Automated Diagnostics Repository (ADR)
  • Gathering Statistics with User-Specified Preferences
  • Automatic Memory Management (AMM)
  • Tuning Memory with the Memory Advisors
  • Enabling Total Memory Management with AMM
  • Generating Workloads for Predictive Testing
  • Capturing Workloads with Database Replay
  • Analyzing and Evaluating the Results of the Replay Session

Please Contact Your ROI Representative to Discuss Course Tailoring!