Skip to content

Oracle Database 12c Backup & Recovery with RMAN - In-house Training

StayAhead Training

Summary

Price
Enquire to get more info on pricing
Study method
Onsite
Duration
4 days
Qualification
No formal qualification
Additional info
  • Tutor is available to students

Overview

Delegates will learn how to plan and implement a backup and recovery strategy using Recovery Manager. They will perform backup and recovery operations using RMAN and Enterprise Manager. They will use Flashback features to recover from human error.

This Oracle Database 12c Backup & Recovery with RMAN course is suitable for users of Oracle Database 11gR2 and Oracle Database 12c.

The delegate will learn and acquire skills as follows:

  • Planning a backup and recovery strategy and a disaster recovery strategy
  • Creating and managing a recovery catalog database
  • Using 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

Who will the Course Benefit?

The Oracle Database 12c Backup & 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 Database 11gR2 and Oracle Database 12c databases.

Course Objectives

The Oracle Database 12c Backup & Recovery with RMAN course is designed to provide the skills needed to plan and implement backup and recovery strategies for Oracle Database 11gR2 and Oracle Database 12c databases using RMAN and Flashback.

Examinations

Together with the Oracle Database 12c Manage Multitenant Architecture course, the Oracle Database 12c Backup & Recovery with RMAN course is suitable for delegates intending to sit the #1Z0-063 - Oracle Database 12c: Advanced Administration examination.

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.

Description

Course Contents - DAY 1 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

DAY 2 Session 5: CREATE AND CONFIGURE A RECOVERY CATALOG

  • Create a Recovery Catalog
  • Register a Database
  • Unregister a Database
  • Control File Information
  • Virtual Private Catalogues
  • Backup a Recovery Catalogue
  • 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
  • Catalogue 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 Catalogue
  • Use Data Dictionary Tables

Session 9: ENCRYPTED RMAN BACKUPS

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

DAY 3 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 Adviser
  • 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 Adviser

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

DAY 4 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

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

Requirements

A working knowledge of Oracle SQL and Oracle Database Administration is required to attend the Oracle Database 12c Backup & Recovery with RMAN course. This can be obtained by attendance on an Oracle SQL and either the Oracle Database 11g Release 2 DBA - Part I or Oracle Database 12c Administration course.

Pre-Requisite Courses

  • Oracle SQL
  • Oracle Database 12c Administration
  • Oracle Database 11g Release 2 DBA - Part I

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: Database, Development, IT