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