Oracle 12c Database Backup and Recovery

Overview

Course Description

In this course, you’ll learn about backup and recovery techniques, which includes hands-on exercises 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

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
  • 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
• 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

Register for Course

Tuition
Available Registrations: Unlimited
The Tuition ticket is sold out. You can try another ticket or another date.

Cost

$1,850.00

Course Code

FRCORA-27

Course Duration

3

Instructions Method

Instructor Led
Category
REGISTER