TRAINING CATEGORIES
(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
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

 

ETABS and SAFE. Training 24 CCE 210 5 SAP 2000. Training 25 CCE 305 5 Quality Assurance in Pavement Construction 26 CCE 401 5 Construction Project Management 27 CCE 402 10 Construction Project Management (10 Days) 28 CCE 403 5 Construction Project Management-Intensive 29 CCE 405 5 Principles of Construction Project Management 30 CCE 406 10 Principles of Construction Project Management (10 Days) 31 CCE 410 10 Construction Project and Risk Management (10 days) 32 CCE 411 5 Project & Contract Management for Marine Construction 33 CCE 412 5 Application of GIS in Construction Management 34 CCE 415 4 Sustainable Water Management Techniques, Innovation and Solution (4 Days) 35 CCE 419 5 Construction Management of Hydraulic Projects 36 CCE 420 5 Water Project Management 37 CCE 421 10 Modern Technologies in the Supervision and Quality Control of Irrigation Projects and Dealing with Contractors (10 Days) 38 CCE 422 5 Rapid Earthquake Hazard Evaluation of Buildings 39 CCE 425 10 Practical Application of Computers in Structural Engineering (10 Days) 40 CCE 428 5 Survey & Profile Using Total Station 41 CCE 430 5 Bridge Construction and Maintenance 42 CCE 435 5 Bridge Inspection and Maintenance 43 CCE-A 410 10 إدارة المشاريع الهندسية -10 أيام
21 - TTC - Transportation and Traffic Control
22 - ADV - Architectural Design and Visualization
23 - SRM - Safety and Occupational Health
24 - CSM - Public Relations, Communication Skills & Office Management
25 - TEM - Training and Education Management
26 - CMR - Customer Relations