Duration: 5 Days
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.
What You Will Learn
- Backup and recover the database
-
Monitor, troubleshoot, and maintain the database
-
How to configure and use Recovery Manager
Audience
Database administrators, support engineers, technical consultants, systems administrators, network managers and technical support personnel
Prerequistes
-
Knowledge of SQL
-
Introduction to Oracle 11g SQL and SQL* Plus course or equivalent
experience
-
Introduction to Oracle 11g PL/SQL course or equivalent experience is
highly recommended
Course Outline
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
Course Labs
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
