Oracle 12c Backup Recovery and Tuning

Course Description

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

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