[thim-heading title=”Oracle Database 12c: Backup And Recovery” line=””]

Upon Completion Of this Course you will have good understanding on:

  • Develop appropriate backup and recovery procedures to address your business needs.
  • Implement backup and recovery settings and perform backup operations to disk and tape
  • Learn How to perform complete recovery without data loss
  • Learn How to perform incomplete recovery ie with data loss.
  • Employ Oracle Database recovery procedures to recover from media and other failures.
  • Diagnose and repair data failures.
  • Use Flashback Technologies and data duplication to complement backup and recovery procedures.

Introduction

  • Assess your Recovery Requirements
  • Categories of failures
  • Oracle Backup and Recovery Solutions
  • Oracle Maximum Availability Architecture
  • Benefits of using Oracle Data Guard

 

Getting Started

  • Core Concepts of the Oracle Database, Critical for Backup and Recovery
  • Oracle DBA Tools for Backup and Recovery
  • Connecting to Oracle Recovery Manager (RMAN)
  • Quick Start: A Problem-Solution Approach

 

Configuring for Recoverability

  • RMAN commands
  • Configuring and managing persistent settings
  • Using the Fast Recovery Area (FRA)
  • Control File
  • Redo Log File
  • Archiving Logs

 

Using the RMAN Recovery Catalog

  • Creating and Configuring the Recovery Catalog
  • Managing Target Database Records in the Recovery Catalog
  • Using RMAN Stored Scripts
  • Maintaining and Protecting the Recovery Catalog
  • Virtual Private Catalogs

 

Backup Strategies and Terminology

  • Backup Solutions Overview and Terminology
  • Balancing Backup and Restore Requirements
  • Backing Up Read-Only Tablespaces
  • Best Practices for Data Warehouse Backups
  • Additional Backup Terminology

 

Performing Backups

  • RMAN Backup Types
  • Incrementally Updated Backups
  • Fast Incremental Backup
  • Block Change Tracking
  • Oracle-Suggested Backup
  • Reporting on Backups
  • Managing Backups

 

Improving Your Backups

  • Compressing Backups
  • Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets
  • Creating and Managing Archival Backups
  • Backing Up Recovery Files
  • Backing Up the Control File to a Trace File
  • Cataloging Additional Backup Files
  • Backing Up ASM Disk Group Metadata

 

Using RMAN-Encrypted Backups

  • Creating RMAN-Encrypted Backups
  • Using Transparent-Mode Encryption
  • Using Password-Mode Encryption
  • Using Dual-Mode Encryption

 

Diagnosing Database Failures

  • Reducing Problem Diagnosis Time
  • Automatic Diagnostic Repository
  • Interpreting RMAN Message Output and Error Stacks
  • Data Recovery Advisor
  • Diagnosing Data File Loss (file system and ASM)
  • Handling Block Corruption

 

Restore and Recovery Concepts

  • Restoring and Recovering
  • Instance Failure and Instance/Crash Recovery
  • Media Failure
  • Complete Recovery (Overview)
  • Point-in-Time Recovery (Overview)
  • Recovery Through RESETLOGS

 

Performing Recovery, Part 1

  • RMAN Recovery in NOARCHIVELOG Mode
  • Performing Complete Recovery (of critical and noncritical data files)
  • Restoring ASM Disk Groups
  • Recovery with Image Files
  • Performing Point-in-Time (PITR) or Incomplete Recovery
  • Table Recovery from Backups

 

Performing Recovery, Part 2

  • Recovery of Server Parameter File, Control File
  • Redo Log File Loss and Recovery
  • Password Authentication File Re-creation
  • Index, Read-Only Tablespace, and Tempfile Recovery
  • Restoring the Database to a New Host
  • Disaster Recovery
  • Restoring RMAN Encrypted Backups

 

Using Flashback Technologies

  • Flashback Technology: Overview and Setup
  • Using Flashback Technology to Query Data
  • Flashback Table
  • Flashback Transaction (Query and Backout)
  • Flashback Drop and the Recycle Bin
  • Flashback Data Archive

 

Using Flashback Database

  • Flashback Database Architecture
  • Configuring Flashback Database
  • Performing Flashback Database
  • Best Practices for Flashback Database

 

Managing Backup Space or Transporting Data

  • Transporting Tablespaces
  • Transporting Databases

 

Duplicating a Database

  • Using a Duplicate Database
  • Choosing Database Duplication Techniques
  • Creating a Backup-up Based Duplicate Database
  • Understanding the RMAN Duplication Operation
  • Using Cloud Control to Clone a Database

 

RMAN Performance and Tuning

  • Tuning Principles
  • RMAN Multiplexing
  • Diagnosing Performance Bottlenecks

 

Backup and Recovery Workshop

  • Workshop Structure
  • Workshop Approach to Solving Failure Scenarios
  • Business Requirements for Database Availability and Procedures

Duration of the course : 30 hrs

Please note :

  • This is the approximate duration .We love more discussion with students and  depending on the interaction , the duration may increase
  • This is the time for the class delivery . Please reserve more  time for your practice

Course Prerequisite

  • Good Understanding on Oracle Database Concepts
  • Good Understanding on Linux OS and Commands

Recommended Prerequisite Courses

  • Oracle 12c Database Administration
  • Linux Operating System For DBAs

This Training is an instructor led training . Along with training we will give the following study materials ,which are provided via our elearning portal

  •  Video Tutorials
  • Student guide
  • PowerPoint Presentations
  • We provide individual lab servers for our students .
  • They students can access the lab for 2 months even after completion of the class
  • We also help students in setting up their laptop / desktop for study purpose
[thim-list-events layout=”layout-2″ text_link=”View All Events”]