(Click Category to List Courses)

38 - IT-D Information Technology - Databases and Related Technologies

IT-D 105 - Oracle Database 12c: Backup and Recovery

Code Start Date Duration Venue
IT-D 105 25 September 2023 5 Days Istanbul Registration Form Link
IT-D 105 20 November 2023 5 Days Istanbul Registration Form Link
IT-D 105 11 December 2023 5 Days Istanbul Registration Form Link
Please contact us for fees


Course Description

This course introduces participants to Oracle Database backup and recovery with Oracle Recovery Manager (RMAN). After completion of the course, participants should be familiar with the basic concepts of Oracle Database backup and recovery operations, know how to implement a disk-based backup strategy, and perform simple repairs to database files.

Course Objectives

  • Use the Data Recovery Advisor to diagnose and repair failures.
  • Use Oracle Flashback Technologies to recover from human error.
  • Perform an encrypted database backup and restore.
  • Perform tablespace point-in-time recovery.
  • Describe additional high availability features such as Oracle Data Guard.
  • Gain an understanding of the Oracle Database Cloud Service
  • Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure.
  • Describe the Oracle Database architecture components related to backup and recovery operations.
  • Plan effective backup and recovery procedures.
  • Configure the database for recoverability.
  • Use Recovery Manager (RMAN) to create backups and perform recovery operations.

Who Should Attend?

  • Administrator
  • Database Administrator

Course Details/Schedule

Day 1

  • Introduction to Backup and Recovery
  • Getting Started with RMAN
  • Starting and Configuring RMAN and Flashback Database
  • Recovery Manager Architecture
  • Starting and Interacting with the RMAN Client
  • Configuring the RMAN Environment
  • Configuring the RMAN Environment: Advanced Topics
  • Using Flashback Database and Restore Points

Day 2

  • Backing Up and Archiving Data
  • RMAN Backup Concepts
  • Backing Up the Database
  • Backing Up the Database: Advanced Topics
  • Managing RMAN Backups
  • Reporting on RMAN Operations
  • Maintaining RMAN Backups and Repository Records
  • Managing a Recovery Catalog

Day 3

  • Diagnosing and Responding to Failures
  • RMAN Data Repair Concepts
  • Diagnosing and Repairing Failures with Data Recovery Advisor
  • Validating Database Files and Backups
  • Performing Complete Database Recovery
  • Performing Flashback and Database Point-in-Time Recovery
  • Performing Block Media Recovery
  • Performing RMAN Recovery: Advanced Scenarios
  • Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)
  • Recovering Tables and Table Partitions from RMAN Backups

Day 4

  • Tuning and Troubleshooting
  • Tuning RMAN Performance
  • Troubleshooting RMAN Operations
  • Transferring Data with RMAN
  • Duplicating a Database
  • Duplicating a Database: Advanced Topics
  • Creating Transportable Tablespace Sets
  • Transporting Data Across Platforms

Day 5

  • Performing User-Managed Backup and Recovery
  • Making User-Managed Database Backups
  • Performing User-Managed Database Flashback and Recovery
  • Performing User-Managed Recovery: Advanced Scenarios