(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 | 30 December 2024 | 5 Days | Istanbul | Registration Form Link |
IT-D 105 | 20 January 2025 | 5 Days | Istanbul | Registration Form Link |
IT-D 105 | 17 March 2025 | 5 Days | Istanbul | Registration Form Link |
IT-D 105 | 12 May 2025 | 5 Days | Istanbul | Registration Form Link |
IT-D 105 | 07 July 2025 | 5 Days | Istanbul | Registration Form Link |
IT-D 105 | 01 September 2025 | 5 Days | Istanbul | Registration Form Link |
IT-D 105 | 27 October 2025 | 5 Days | Istanbul | Registration Form Link |
IT-D 105 | 22 December 2025 | 5 Days | Istanbul | Registration Form Link |
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