Oracle Database 12c R2 - Backup and Recovery Workshop Ed 3

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

Core Concepts of the Oracle Database, critical for Backup and Recovery

Oracle DBA Tools for Backup and Recovery

Connecting to Oracle Recovery Manager (RMAN)

RMAN commands

Configuring and managing persistent settings

Using the Fast Recovery Area (FRA)

Control File

Redo Log File

Archiving Logs

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 Solutions Overview and Terminology

Balancing Backup and Restore Requirements

Backing Up Read-Only Tablespaces

Data Warehouse Backup and Recovery: Best Practices

Additional Backup Terminology

RMAN Backup Types

Incrementally Updated Backups

Fast Incremental Backup

Block Change Tracking

Oracle-Suggested Backup

Reporting on Backups

Managing Backups

Compressing Backups

Using a Media Manager

Backup and Restore for Very Large Files

Creating RMAN Multi-section 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

Creating RMAN-Encrypted Backups

Using Transparent-Mode Encryption

Using Password-Mode Encryption

Using Dual-Mode Encryption

Reducing Problem Diagnosis Time

Automatic Diagnostic Repository

Data Recovery Advisor

Handling Block Corruption

Restoring and Recovering

Instance Failure and Instance/Crash Recovery

Media Failure

Complete Recovery (Overview)

Point-in-Time Recovery (Overview)

Recovery with the RESETLOGS Option

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

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 Temp file Recovery

Restoring the Database to a New Host

Disaster Recovery

Restoring RMAN Encrypted Backups

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

Flashback Technology: Overview and Setup

Using Flashback Technology to Query Data

Flashback Table

Flashback Transaction (Query and Back out)

Flashback Drop and the Recycle Bin

Flashback Data Archive

Flashback Database Architecture

Configuring Flashback Database

Performing Flashback Database

Best Practices for Flashback Database

Transporting Data Across Platforms

Transporting Data with Backup Sets

Database Transport: Using Data Files

When to use TSPITR

TSPITR Architecture

Performing RMAN TS Point-in-time Recovery

Recovering Tables from Backups

Using a Duplicate Database

Duplicating Database with 'push' and 'pull' techniques

Choosing Database Duplication Techniques

Creating a Backup-up Based Duplicate Database

Understanding the RMAN Duplication Operation

Interpreting RMAN Message Output

Tuning Principles

Diagnosing Performance Bottlenecks

RMAN Multiplexing

Restore and Recovery Performance Best Practices

Backup Destinations

Customize Backup Configuration

On-Demand Backup and Recovery

Oracle Backup Cloud Service

Installing the Backup Module

Workshop Structure and Approach

Business Requirements for Database Availability and Procedures

Diagnosing the Failures