Course Details
In this class, you’ll cover backup and recovery techniques. Hands-on exercises reinforce the material covered. This course is designed to help you prepare for the Oracle Certified Associate and Oracle Certified Professional exams.
Course Prerequisites
- Knowledge of SQL
- Introduction to Oracle 11g SQL and SQL* Plus course or equivalentexperience
- Introduction to Oracle 11g PL/SQL course or equivalent experience ishighly recommended
Course Agenda
1. Backup and Recovery Concepts
- Basics of Database Backup, Restore, and Recovery
- Types of Failure that May Occur in an Oracle Database
- Ways to Tune Instance Recovery
- Importance of Checkpoints, Redo Log Files, and Archived Log File
- Configure ARCHIVELOG Mode
- Flashback Database / Table / Query
2. Database Backups
- Create Consistent Database Backups
- Create Incremental Backups
- Automate Database Backups
- Monitor the Flash Recovery Area
- Back Up Your Database without Shutting It Down
3. Database Recovery
- Loss of a Control File
- Loss of a Redo Log File
- Loss of Data Files
- Loss of Temp Files
- Loss of 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 EM
- 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