In this class, you’ll cover backup and recovery techniques. Hands-on exercises reinforce the material covered. This course is designed to help you prepare for the Oracle Certified Associate and Oracle Certified Professional exams.

What You’ll Learn

  • Backup and recover the database
  • Monitor, troubleshoot, and maintain the database
  • How to configure and use Recovery Manager

Who Needs to Attend

Database administrators, support engineers, technical consultants, systems administrators, network managers and technical support personnel

Prerequisites

  • Knowledge of SQL
  • Introduction to Oracle 11g SQL and SQL* Plus course or equivalent experience
  • Introduction to Oracle 11g PL/SQL course or equivalent experience is highly recommended

Follow-On Courses

There are no follow-ons for this course.

Course Outline

1. Backup and Recovery Concepts

  • Basics of Database Backup, Restore, and Recovery
  • Types of Failure that May Occur in an Oracle Database
  • Ways to Tune Instance Recovery
  • Importance of Checkpoints, Redo Log Files, and Archived Log File
  • Configure ARCHIVELOG Mode
  • Flashback Database / Table / Query

2. Database Backups

  • Create Consistent Database Backups
  • Create Incremental Backups
  • Automate Database Backups
  • Monitor the Flash Recovery Area
  • Back Up Your Database without Shutting It Down

3. Database Recovery

  • Loss of a Control File
  • Loss of a Redo Log File
  • Loss of Data Files
  • Loss of Temp Files
  • Loss of Undo Tablespaces

4. Recovery Manager Configuration

  • Parameters affecting RMAN
  • Use of a Flashback Recovery Area
  • The CONFIGURE Command
  • Persistent Settings
  • NOCATALOG / CATALOG Mode
  • Channel Allocation
  • Controlfile Autobackup
  • Retention Policies

5. Recovery Manager Operations

  • Using the BACKUP Command
  • Creating Backup Sets / Image Copies
  • Parallelization
  • Compressed Backups
  • Whole Database Copying
  • Incremental Backups
  • Block Change Tracking
  • RMAN Backup Monitoring
  • REPORT and LIST commands

6. Non-Critical Loss Recovery

  • Password and Network Files
  • Read-Only Tablespaces
  • Temporary Tablespaces
  • Index Tablespaces
  • Redo Log Members / Control Files

7. Database Recovery

  • Recovering the Control File
  • Reasons for Incomplete Recovery
  • Recovery after RESETLOGS
  • Incomplete Recovery using EM
  • Incomplete Recovery using RMAN
  • Incomplete Recovery using SQL

8. Flashback Database

  • When to Use
  • Configuration and Use
  • Monitoring Flashback Database
  • Using EM for Flashback Database
  • Flash Recovery Area Maintenance
  • Flash Recovery Area Monitoring

9. User Error Recovery

  • The New Recycle Bin
  • Flashback a Dropped Table using EM
  • Querying Dropped Tables
  • Flashback Versions Query
  • Flashback Transaction Query

10. Block Corruption Management

  • DBVERIFY and ANALYZE
  • DBMS_REPAIR
  • Block Media Recovery
  • DBMS_BLOCK_CHECKING Parameter
  • Using RMAN for Block Corruption

11. Tune Database Operations

  • SQL Parsing and Execution
  • Shared SQL Statements / Bind Variables
  • The SQL Area / High Load SQL
  • Automatic Segment Space Management
  • Statement Transformation
  • Using SQL Syntax

12. Tuning The Logical Structure

  • Tablespace Considerations
  • Table Considerations
  • Free Space Management
  • Chaining and Migrated Data
  • Choosing the Right Index
  • Index Usage Monitoring
  • Materialized Views

13. SQL Tuning Tools

  • Execution Plans
  • Cost-Based Optimization
  • Table Column and Index Statistics
  • DBMS_STATS
  • Stats Pack
  • Execution Plans / EXPLAIN PLAN
  • Row Access Methods / Index Types
  • Autotrace
  • SQL_TRACE and TKPROF
  • Using Hints
  • Stored Outlines and Plan Stability
  • Query Rewrites / Materialized Views
  • Initialization Parameters

14. Application Memory Use

  • Memory Tuning Goals
  • Tuning the Buffer Cache
  • Memory Subcaches
  • Partitioned Tables and Indexes

Labs

Lab 1: Configuring the Database for Backup

Lab 2: Basic Database Media Recovery

Lab 3: Archivelog Setup

Lab 4: Recovery Manager Configuration

Lab 5: Recovery Manager Backups

Lab 6: Database Recovery using RMAN

Lab 7: Flashback Database

Lab 8: Flashback for User Errors

Lab 9: Dealing with Block Corruption