Oracle Database 12c: Backup and Recovery Workshop (D78850) – Outline

Detailed Course Outline

Introduction
  • Curriculum Context
  • Assess your recovery requirements
  • Categories of failures
  • Oracle backup and recovery solutions
  • Oracle Maximum Availability Architecture
  • Oracle Secure Backup
  • Benefits of using Oracle Data Guard
  • Basic Workshop Architecture
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 Recoverablility
  • 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
  • Data Warehouse Backup and Recovery: Best Practices
  • 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
  • Using a Media Manager
  • Backup and Restore for Very Large Files
  • 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
Using RMAN-Encrypted Backups
  • Creating RMAN-Encrypted Backups
  • Using Transparent-Mode Encryption
  • Using Password-Mode Encryption
  • Using Dual-Mode Encryption
Diagnosing Failures
  • Reducing Problem Diagnosis Time
  • Automatic Diagnostic Repository
  • Data Recovery Advisor
  • 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 with the RESETLOGS Option
Performing Recovery, Part I
  • 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
Performing Recovery, Part II
  • Recovery of Server Parameter File, Control File (One and All)
  • 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
RMAN and Oracle Secure Backup
  • Oracle Secure Backup Overview and Interface Options
  • RMAN and OSB: Overview and Basic Process Flow
  • Starting with Oracle Secure Backup
  • Configuring Oracle Secure Backup for RMAN
  • RMAN Backup and Restore Operations
  • Oracle Secure Backup Jobs
  • Displaying OSB log files and transcripts for RMAN activities
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
Transporting Data
  • Transporting Data Across Platforms
  • Transporting Data with Backup Sets
  • Database Transport: Using Data Files
Performing Point-in-Time Recovery
  • When to use TSPITR
  • TSPITR Architecture
  • Performing RMAN TS Point-in-time Recovery
  • Recovering Tables from Backups
Duplicating a Database
  • Using a Duplicate Database
  • Duplicating Database with "push" an"pull" techniques
  • Choosing Database Duplication Techniques
  • Creating a Backup-up Based Duplicate Database
  • Understanding the RMAN Duplication Operation
RMAN Troubleshooting and Tuning
  • Interpreting RMAN Message Output
  • Tuning Principles
  • Diagnosing Performance Bottlenecks
  • RMAN Multiplexing
  • Restore and Recovery Performance Best Practices
Cloud Tooling for Backup and Recovery
  • Backup Destinations
  • Customize Backup Configuration
  • On-Demand Backup and Recovery
  • Oracle Backup Cloud Service
  • Installing the Backup Module
Backup and Recovery Workshop
  • Workshop Structure and Approach
  • Business Requirements for Database Availability and Procedures
  • Diagnosing the Failures