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

Suggested Prerequisite

• Knowledge of Oracle Database 12c
• Knowledge of SQL and PL/SQL (for DBA use)

Required Prerequisite

• Oracle Database 12c R2: Install and Upgrade Workshop
• Oracle Database 12c R2: Administration Workshop Ed 3
• Using Oracle Enterprise Manager Cloud Control 13c Ed 1

Audience

• Database Administrators
• Support Engineer
• Technical Consultant
• Technical Administrator
• Data Warehouse Administrator

Course Topics

1. Introduction

• Oracle Maximum Availability Architecture
• Oracle Secure Backup
• Basic Workshop Architecture
• Oracle backup and recovery solutions
• Curriculum Context
• Categories of failures
• Benefits of using Oracle Data Guard
• Assess your recovery requirements

2. Backup Strategies and Terminology

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

3. Using RMAN-Encrypted Backups

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

4. Performing Recovery, Part I

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

5. Using Flashback Technologies

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

6. RMAN Troubleshooting and Tuning

• Interpreting RMAN Message Output
• Tuning Principles
• RMAN Multiplexing
• Diagnosing Performance Bottlenecks
• Restore and Recovery Performance Best Practices

7. Getting Started

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

8. Performing Backups

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

9. Diagnosing Failures

• Automatic Diagnostic Repository
• Handling Block Corruption
• Reducing Problem Diagnosis Time
• Data Recovery Advisor

10. Performing Recovery, Part II

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

11. Using Flashback Database

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

12. Performing Point-in-Time Recovery

• Performing RMAN TS Point-in-time Recovery
• When to use TSPITR
• Recovering Tables from Backups
• TSPITR Architecture

13. Cloud Tooling for Backup and Recovery

• Customize Backup Configuration
• Backup Destinations
• Installing the Backup Module
• Oracle Backup Cloud Service
• On-Demand Backup and Recovery

14. Configuring for Recoverablility

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

15. Using the RMAN Recovery Catalog

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

16. Improving Your Backups

• Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets
• Creating and Managing Archival Backups
• Cataloging Additional Backup Files
• Compressing Backups
• Backup and Restore for Very Large Files
• Backing Up Recovery Files
• Backing Up the Control File to a Trace File
• Using a Media Manager

17. Restore and Recovery Concepts

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

18. RMAN and Oracle Secure Backup

• Configuring Oracle Secure Backup for RMAN
• RMAN Backup and Restore Operations
• RMAN and OSB: Overview and Basic Process Flow
• Displaying OSB log files and transcripts for RMAN activities
• Starting with Oracle Secure Backup
• Oracle Secure Backup Jobs
• Oracle Secure Backup Overview and Interface Options

19. Transporting Data

• Transporting Data Across Platforms
• Database Transport: Using Data Files
• Transporting Data with Backup Sets

20. Duplicating a Database

• Duplicating Database with push anpull techniques
• Understanding the RMAN Duplication Operation
• Choosing Database Duplication Techniques
• Creating a Backup-up Based Duplicate Database
• Using a Duplicate Database

21. Backup and Recovery Workshop

• Workshop Structure and Approach
• Diagnosing the Failures
• Business Requirements for Database Availability and Procedures