Tel: 01423 534630 • Email: info@tts-uk.com
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.
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
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.
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
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.
Oracle SQL
Oracle Database 18c Administration
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.
Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions
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
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
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
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
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
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
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
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
Create an Encrypted RMAN Backup
Transparent Encryption
Password Encryption
Use Different Encryption Modes
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
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
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
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
Tablespace-Point-in-Time Overview
Tablespace-Point-in-Time Example
Transport Tablespaces
Transport Databases
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
Tune Recovery Manager Overview
Restore and Recovery Performance Best Practices
Multiplexing in RMAN
Diagnosing Performance Bottlenecks
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
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