Oracle 12c Backup Recovery and Tuning

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

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