Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-800-268-7737 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


Oracle 12c Backup Recovery and Tuning

GK# 7498 Vendor# OR250

Course Overview


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


  • Delivery Format:
  • Date:
  • Location:
  • Access Period:


What You'll Learn

  • Backup and recover the database
  • Monitor, troubleshoot, and maintain the database
  • How to configure and use recovery manager


Viewing outline for:

Virtual Classroom Live Outline

1. Backup and Recovery Concepts

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

2. Database Backups

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

3. Database Recovery

  • Recover from Loss of a Control File, a Redo Log File, Data Files, and Temp Files
  • Undo Tablespaces

4. Recovery Manager Configuration

  • Parameters Affecting RMAN
  • Use of a Flashback Recovery Area
  • The CONFIGURE Command
  • Persistent Settings
  • 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 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

  • Block Media Recovery
  • 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
  • Stats Pack
  • Execution Plans / EXPLAIN PLAN
  • Row Access Methods / Index Types
  • Autotrace
  • 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


Viewing labs for:

Virtual Classroom Live 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



Who Should Attend

  • Database administrators
  • Support engineers
  • Technical consultants
  • Systems administrators
  • Network managers
  • Technical support personnel
Course Delivery

This course is available in the following formats:

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 5 day

Request this course in a different delivery format.