Menu

Tel: 01423 534630    Email: info@tts-uk.com

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

Duration: 4 days
Price: £1695 + VAT

Payment logos


Book Now Enquire now

Share Course:

Register to attend

    All fields with * are mandatory.