Oracle 12c Backup Recovery and Tuning

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.

    No classes are currenty scheduled for this course.

    Call (919) 283-1653 to get a class scheduled online or in your area!

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

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
  • Backup and recover the database
  • Monitor, troubleshoot, and maintain the database
  • How to configure and use recovery manager

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

  • Knowledge of SQL
  • Database administrators
  • Support engineers
  • Technical consultants
  • Systems administrators
  • Network managers
  • Technical support personnel

Ready to Jumpstart Your IT Career?

CONTACT US NOW!