Oracle Database Backup and Recovery Using RMAN

Oracle Database Backup and Recovery Using RMAN

by Ahmed Baraka
Released November 2023
Publisher(s): Packt Publishing
ISBN: 9781835461938

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Information presented in this course provides Oracle Database Administrators with the knowledge and experience to perform backup and recovery activities on Oracle databases.

Starting with the Oracle RMAN architecture, you will seamlessly progress from fundamental database backups to the implementation of advanced options.

Then, you will discover and practically execute diverse RMAN backup strategies, covering whole/partial, full/incremental, complete/incomplete, and online/offline backups. Dive into advanced options such as compression, encryption, multisection, duplexing backups, and archival backups for a holistic understanding.

You will also simulate common recovery scenarios, from critical file losses to application data and non-critical file losses. Uncover additional RMAN capabilities such as the RMAN Recovery Catalog, cross-platform data transportation, and database cloning, ensuring a comprehensive skill set.

Beyond technical proficiency, you will gain insights into developing effective backup and recovery plans with a focus on best practices. Stay abreast of cutting-edge technology with coverage of Oracle's latest advancements, including the Oracle Database Backup Cloud Service.

By the end of the course, you will be able to perform and manage backup and recovery activities on Oracle 12c databases using RMAN.

What you will learn

  • Use RMAN with Oracle Database Backup Cloud Service
  • Perform all supported cross-platform transportation techniques
  • Perform all supported database duplication techniques
  • Manage RMAN Recovery Catalog and produce encrypted backups
  • Learn how to use RMAN in Oracle RAC and multitenant databases
  • Handle corrupted blocks and use Data Recovery Advisor

Audience

This course caters to Oracle database administrators seeking to proficiently design and execute a comprehensive backup and recovery plan for Oracle databases utilizing RMAN. It is also tailored for Oracle database administrators aspiring to acquire the skills necessary for the management of backup and recovery activities. You would need familiarity with Oracle database administration concepts and a foundational understanding of the basics of the Linux operating system. You require a PC with Windows 7,8, or 10 64-bit, memory 16 GB, Fee HDD 280 GB, and a connection to the Internet.

About the Author

Ahmed Baraka:

Ahmed Baraka has 25 years of extensive experience in the computer industry, with a focus on Oracle database administration technologies used in complex and high-availability environments. Baraka's expertise is designing and maintaining database solutions for complex business needs using a wide selection of technologies, such as Oracle RAC, ASM, Data Guard, GoldenGate, WebLogic, Database Appliance, and Enterprise Manager. He has worked with international firms in Australia and Abu Dhabi. His hobbies are soccer (football) and listening to soft music.

Table of contents

  1. Chapter 1 : Introduction
    1. Introduction
  2. Chapter 2 : Preparing the Course Practice Environment
    1. Practice 1 - Preparing the Course Practice Environment (Part 1 of 4)
    2. Practice 1 - Preparing the Course Practice Environment (Part 2 of 4)
    3. Practice 1 - Preparing the Course Practice Environment (Part 3 of 4)
    4. Practice 1 - Preparing the Course Practice Environment (Part 4 of 4)
  3. Chapter 3 : Introducing Backup and Recovery in RMAN
    1. Introduction to Oracle Backup and Recovery Solutions
    2. Configuring Oracle Database for Backup and Recovery
    3. Introduction to Recovery Manager (RMAN)
    4. Practice 2 - Introducing RMAN
  4. Chapter 4 : Performing Backups in RMAN
    1. Performing RMAN Backups - Part I
    2. Practice 3 - Performing RMAN Backups - Part I
    3. Performing RMAN Full Backups - Part II
    4. Practice 4 - Performing RMAN Backups - Part II
    5. Performing Incremental Backups
    6. Practice 5 - Performing Incremental Backups (Part 1 of 2)
    7. Practice 5 - Performing Incremental Backups (Part 2 of 2)
    8. Configuring RMAN Persistent Settings
    9. Practice 6 - Configuring RMAN Persistent Settings
  5. Chapter 5 : Retrieve Information about RMAN Backups and Jobs
    1. Reporting and Monitoring RMAN Backups and Jobs (Part 1 of 2)
    2. Reporting and Monitoring RMAN Backups and Jobs (Part 2 of 2)
    3. Practice 7 - Reporting and Monitoring RMAN Backups and Jobs (Part 1 of 3)
    4. Practice 7 - Reporting and Monitoring RMAN Backups and Jobs (Part 2 of 3)
    5. Practice 7 - Reporting and Monitoring RMAN Backups and Jobs (Part 3 of 3)
  6. Chapter 6 : Improving Backups
    1. Improving Backups (Part 1 of 3)
    2. Improving Backups (Part 2 of 3)
    3. Improving Backups (Part 3 of 3)
    4. Practice 8 - Improving Backups
  7. Chapter 7 : Managing RMAN Recovery Catalog
    1. Using RMAN Recovery Catalog (Part 1 of 2)
    2. Using RMAN Recovery Catalog (Part 2 of 2)
    3. Practice 9 - Using RMAN Recovery Catalog
  8. Chapter 8 : Securing RMAN Backups
    1. Using RMAN-Encrypted Backups
    2. Practice 10 - Using RMAN-Encrypted Backups
  9. Chapter 9 : Common Backup Practices
    1. Common Backup Practices (Part 1 of 2)
    2. Common Backup Practices (Part 2 of 2)
  10. Chapter 10 : Performing Recovery Scenarios in RMAN
    1. Introducing RESTORE and RECOVER Commands
    2. Performing Recovery Part I - Performing Full Recovery
    3. Practice 11 - Performing Recovery - Part I
    4. Performing Recovery - Part II (Switching Data Files and Performing PITR)
    5. Practice 12 - Performing Recovery - Part II
    6. Performing Recovery - Part III (Performing PITR on Tablespaces and Tables)
    7. Practice 13 - Performing Recovery - Part III
    8. Performing Recovery - Part IV (Recovering Control File and SPFILE)
    9. Practice 14 - Performing Recovery - Part IV
    10. Performing Recovery - Part V (Recovering from Losing Redo Log Files)
    11. Practice 15 - Performing Recovery - Part V (Part 1 of 2)
    12. Practice 15 - Performing Recovery - Part V (Part 2 of 2)
    13. Performing Recovery - Part VI (Miscellaneous Recovery Scenarios)
    14. Practice 16 - Performing Recovery - Part VI
  11. Chapter 11 : Using Data Recovery Advisor
    1. Using Data Recovery Advisor
    2. Practice 17 - Using Data Recovery Advisor
    3. Handling Corrupted Blocks
    4. Practice 18 - Handling Corrupted Blocks
  12. Chapter 12 : Performing Cross-Platform Data Transportation
    1. Introduction to Cross-Platform Data Transportation
    2. Cross-Platform Data Transport Using Image Copies (Part 1 of 2)
    3. Cross-Platform Data Transport Using Image Copies (Part 2 of 2)
    4. Practice 19 - Cross-Platform Data Transport Using Image Copies (Part 1 of 2)
    5. Practice 19 - Cross-Platform Data Transport Using Image Copies (Part 2 of 2)
    6. Cross-Platform Data Transport Using Backup Sets (Part 1 of 2)
    7. Cross-Platform Data Transport Using Backup Sets (Part 2 of 2)
    8. Practice 20 - Cross-Platform Data Transport Using Backup Sets
  13. Chapter 13 : Duplicating a Database Using RMAN
    1. Duplicating a Database Using RMAN - Part I
    2. Duplicating a Database Using RMAN - Part II
    3. Practice 21 - Duplicating a Database Using RMAN
  14. Chapter 14 : RMAN Troubleshooting and Performance Tuning
    1. RMAN Troubleshooting
    2. RMAN Performance Tuning (Part 1 of 2)
    3. RMAN Performance Tuning (Part 2 of 2)
  15. Chapter 15 : Using RMAN in Oracle Multitenant Databases
    1. Using RMAN in Oracle Multitenant Databases
    2. Practice 22 - Using RMAN in Oracle Multitenant Databases (Part 1 of 2)
    3. Practice 22 - Using RMAN in Oracle Multitenant Databases (Part 2 of 2)
  16. Chapter 16 : Using RMAN in Oracle RAC
    1. Using RMAN in Oracle RAC
    2. Using RMAN in Oracle RAC - Demonstration
  17. Chapter 17 : Using Oracle Database Backup Cloud Service
    1. Using Oracle Database Backup Cloud Service
    2. Practice 23 - Using Oracle Database Backup Cloud Service

Product information

  • Title: Oracle Database Backup and Recovery Using RMAN
  • Author(s): Ahmed Baraka
  • Release date: November 2023
  • Publisher(s): Packt Publishing
  • ISBN: 9781835461938