Oracle 12c: Database Backup, Recovery, and Tuning

Live Online & Classroom Enterprise Training

Location: Bangalore, India | Dubai, UAE

Industry Experienced Instructor  |  Remote Labs  |  Lab Access Post Training

Need help finding the right training?

Course Details

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.

Course Prerequisites

  • Knowledge of SQL

Course Agenda

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
  • 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 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