Overview
Course Description
Thank you for reading this post, don't forget to subscribe!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.
Audience Profile
- Database administrators
- Support engineers
- Technical consultants
- Systems administrators
- Network managers
- Technical support personnel
Prerequisites
- Knowledge of SQL
- Oracle 12c SQL & SQLPLUS Express Introduction
- Oracle 12c PL/SQL Introduction
Learning Objectives
- Backup and recover the database.
- Monitor, troubleshoot, and maintain the database.
- How to configure and use recovery manager.
Course Outline
Course Outline
Module 1: Backup and Recovery Concepts
Lessons
• 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
Module 2: Database Backups
Lessons
• Create consistent database backups and incremental backups
• Automate database backups
• Monitor the flash recovery area
• Back your database up without shutting it down
Lab: Configuring the database for backup
Module 3: Database Recovery
Lessons
• Recover from loss of a control file, redo log file, data files, temp files and undo tablespaces
Lab: Basic Database Media Recovery
Lab: Archivelog Setup
Module 4: Recovery Manager Configuration
Lessons
• Parameters affecting RMAN
• Use of a flashback recovery area
• The CONFIGURE command
• Persistent settings
• NOCATALOG / CATALOG mode
• Channel allocation
• Controlfile autobackup
• Retention policies
Lab: Recovery Manager Configuration
Module 5: Recovery Manager Operations
Lessons
• 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
Lab: Recovery Manager Backups
Module 6: Non-Critical Loss Recovery
Lessons
• Password and network files
• Read-Only tablespaces
• Temporary tablespaces
• Index tablespaces
• Redo log members / control files
Module 7: Database Recovery
Lessons
• Recovering the control file
• Reasons for incomplete recovery
• Recovery after RESETLOGS
• Incomplete recovery using RMAN
• Incomplete recovery using SQL
Lab: Database Recovery Using RMAN
Module 8: Flashback Database
Lessons
• When to use
• Configuration and use
• Monitoring flashback database
• Flash recovery area maintenance
• Flash recovery area monitoring
Lab: Flashback Database
Module 9: User Error Recovery
Lessons
• The new recycle bin
• Flashback a Dropped Table Using EM
• Querying dropped tables
• Flashback versions query
• Flashback transaction query
Lab: Flashback for User Errors
Module 10: Block Corruption Management
Lessons
• DBVERIFY and ANALYZE
• DBMS_REPAIR
• Block media recovery
• DBMS_BLOCK_CHECKING parameter
• Using RMAN for block corruption recovery
Lab: Dealing with Block Corruption
Module 11: Tune Database Operations
Lessons
• SQL Parsing And Execution
• Shared SQL Statements / Bind Variables
• The SQL Area / High Load SQL
• Automatic Segment Space Management
• Statement Transformation
• Using SQL Syntax
Module 12: Tuning the Logical Structure
Lessons
• Tablespace Considerations
• Table Considerations
• Free Space Management
• Chaining And Migrated Data
• Choosing The Right Index
• Index Usage Monitoring
• Materialized Views
Module 13: SQL Tuning Tools
Lessons
• 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
Module 14: Application Memory Use
Lessons
• Memory Tuning Goals
• Tuning The Buffer Cache
• Memory Subcaches
• Partitioned Tables And Indexes