Oracle Database 12c Back up, Recovery and Server 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.

Content


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