Oracle Database 18c Backup and Recovery with RMAN

This Oracle Database 18c Backup and Recovery with RMAN course is designed to give an Oracle database administrator practical experience in planning and implementing a backup and recovery strategy using Recovery Manager and Flashback Database. The delegate will learn how to perform backup and recovery operations using RMAN and will learn how to use Flashback features to recover from human error.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Versions supported 12c, 18c and 19c.

Course Objectives

The Oracle Database 18c Backup and Recovery with RMAN course is designed to provide the skills needed to enable a delegate to plan and implement a backup and recovery strategy in the workplace for Oracle Databases using RMAN and Flashback Database technologies

Who will the Course Benefit?

The Oracle Database 18c Backup and Recovery with RMAN course is designed for database administrators, data warehouse administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle databases.

Skills Gained

The delegate will learn and acquire skills as follows:

Plan a backup and recovery strategy and a disaster recovery strategy
Creating and managing a recovery catalog database
Use Recovery Manager to perform backups
Using Recovery Manager to perform recoveries
Monitor and tune Recovery Manager
Performing tablespace point-in-time recovery
Perform an encrypted database backup and restore
Creating a duplicate database
Using Flashback technology to recover from errors

Requirements

A working knowledge of Oracle SQL and Oracle Database Administration is required to attend the Oracle Database 18c Backup and Recovery with RMAN course. This can be obtained by attendance on the Oracle SQL course and a suitable database administration course. The ability to describe and use Oracle built-in packages would be advantageous, but is not essential.

This course is run on a Linux operating system, a basic knowledge of UNIX/Linux is recommended but is not essential.

Where Oracle 18c courses are listed in the Pre-requisite Courses section equivalent Oracle 11g or Oracle 12c courses would also suffice.

Pre-Requisite Courses

Oracle SQL
Oracle Database 18c Administration

Examinations

This course will aid the delegate towards their preparation for the following exam:

Oracle Database Administration II: 1Z0-083

Attending this course together with the following courses will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives:

Oracle Database 18c Install & Upgrade
Oracle Multitenant Administration

Studying this course and its associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course.

• Course content

  Course Introduction

  Administration and Course Materials
  Course Structure and Agenda
  Delegate and Trainer Introductions

  Session 1: BACKUP AND RECOVERY CONSIDERATIONS

  Plan and Implement a Backup and Recovery Strategy
  Define a Disaster Recovery Plan
  Test a Backup and Recovery Plan
  Advantages and Disadvantages of Different Backup Methods
  Backup Methods Comparison
  Data Recovery Strategy
  Backup Strategy
  Validate the Recovery Strategy

  Session 2: ORACLE RECOVERY STRUCTURES AND PROCESSES

  Architectural Components of Backup and Restore
  Physical Database Structures
  Logical Database Structures
  Dynamic Performance Views
  Redo Logs, Checkpoints and Archives
  Use the Flash Recovery Area (FRA)
  The Archivelog Modes of a Database

  Session 3: FLASHBACK

  Configure and Use Flashback Database
  Monitor Flashback Database
  Flash Recovery Area Space Usage
  Flashback Query
  Retrieve Row History with Flashback Versions Query
  Audit or Recover From Transactions with Flashback Transactions Query
  Flashback Table
  Recover Dropped Tables with Flashback Drop
  The Recycle Bin
  Recover Tables to a Point In Time With Flashback Table
  Flashback Database
  Flashback Restore Points
  Flashback Transaction Backout
  Flashback Data Archive

  Session 4: RECOVERY MANAGER OVERVIEW

  RMAN Features and Components
  The sysbackup Privilege
  RMAN Commands
  Connect to RMAN
  Specify the Location of RMAN Output
  Start Up and Shut Down a Target Database Using RMAN
  Issue SQL Commands in RMAN

  Session 5: CREATE AND CONFIGURE A RECOVERY CATALOG

  Create a Recovery Catalog
  Register a Database
  Unregister a Database
  Control File Information
  Virtual Private Catalogs
  Backup a Recovery Catalog
  Use a Flashback Recovery Area with RMAN
  Configure Persistent RMAN Settings
  Set Retention Policies
  Configure Control File Autobackups
  Integrate RMAN with a Media Manager

  Session 6: BACKUP WITH RMAN

  Channel Allocation
  Types of RMAN Backup
  Recovery Manager Commands
  Performing Backups
  Closed and Open Backups
  Incremental Backups
  Fast Incremental Backups using Block Change Tracking
  Backup File Image Copies
  Oracle Suggested Backup
  Validate Backups
  Listing Backups

  Session 7: ADVANCED BACKUP TECHNIQUES

  Create Multisection Backups
  Create Duplexed Backup Sets
  Create Compressed Backups
  Backup the Control File to a Trace File
  Backup Recovery Files
  Backup up ASM Metadata

  Session 8: MAINTAIN A RECOVERY CATALOG

  Change the Availability Status of Backups and Copies
  Catalog Backups Made with Operating System Commands
  Generate Backup Reports and Lists
  Cross Check Backups and Copies
  Delete Backups
  Update the Repository after Backup Deletion
  Drop Database and Archival Backups
  Import and Export the Recovery Catalog
  Use Data Dictionary Tables

  Session 9: ENCRYPTED RMAN BACKUPS

  Create an Encrypted RMAN Backup
  Transparent Encryption
  Password Encryption
  Use Different Encryption Modes

  Session 10: DATABASE FAILURE DIAGNOSTICS

  The Automatic Diagnostic Repository
  The Data Recovery Advisor
  Understanding RMAN Messages and the Error Stack
  Diagnose Data File Loss
  Recovery with RESETLOGS
  Dealing with Block Corruption

  Session 11: OVERVIEW OF RESTORE AND RECOVERY

  Restore and Recover
  Instance Failure and Crash Recovery
  Media Failure
  An Overview of Complete Recovery
  An Overview of Point in Time Recovery
  Recovery with RESETLOGS

  Session 12: BASIC RESTORE AND RECOVER WITH RMAN

  Perform Recovery in Noarchivelog Mode
  Perform Complete Recovery in Archivelog Mode
  Use the Flash Recovery Area for Fast Recovery
  Automatic Tempfile Recovery
  Identify the Database Files to Restore and Recover
  Preview Backups used in Restore Operations
  Apply Incremental Backups to Restore Datafile Image Copies
  The Switch Command
  The Data Recovery Advisor
  Perform Incomplete Recovery (PITR)
  Restore and Recover a tablespace
  Restore and Recover Datafiles
  Recover a Datafile Not Backed Up
  Table Recovery from Backups
  Recover Individual Data Blocks
  The Data Recovery Advisor

  Session 13: ADVANCED RESTORE AND RECOVER WITH RMAN

  Restore the Server Parameter File
  Restore the Control File
  Re-create the Password File
  Handling Redo Log File Loss
  Restore and Recover the Database on a New Host
  Restore RMAN Encrypted Backups
  Disaster recovery

  Session 14: TABLESPACE POINT IN TIME RECOVERY (TSPITR)

  Tablespace-Point-in-Time Overview
  Tablespace-Point-in-Time Example

  Session 15: TRANSPORT DATA

  Transport Tablespaces
  Transport Databases

  Session 16: CREATE A DUPLICATE DATABASE WITH RMAN

  Database Duplication
  Duplication Options
  Create Files for the Duplicate Database
  Prepare the Auxiliary Instance for Duplication
  Create a Duplicate Database
  Clone a Running Database
  An Overview of Using Cloud Control to Clone a Running Database
  Targetless Duplication of a Database
  18c Duplication Enhancements

  Session 17: MONITOR, TUNE AND TROUBLESHOOT BACKUP AND RECOVERY

  Tune Recovery Manager Overview
  Restore and Recovery Performance Best Practices
  Multiplexing in RMAN
  Diagnosing Performance Bottlenecks

  Session 18: OVERVIEW OF RMAN AND ORACLE SECURE BACKUP

  Oracle Secure Backup Overview
  Oracle Secure Backup Interfaces
  Oracle Secure Backup Architecture
  Oracle Secure Backup Jobs with RMAN
  Backup the Fast Recovery Area to Tape
  RMAN Backup to Tape
  Overview of Integration with Cloud Control

  Session 19: OVERVIEW OF BACKUP AND RESTORE TO TAPE

  Schedule Backups with Enterprise Manager
  Oracle Suggested Backup Strategy
  Perform Backups to Tape
  Manage Tape Backups
  Perform Recovery from Tape
  RMAN Automatic Failover to Previous Backup