Oracle Database: Backup and Recovery Workshop

Oracle

Oracle Database: Backup and Recovery Workshop

Share This Learning Path

The student begins by gaining a deeper understanding of possibly the most important job of a DBA - backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication.

Audience Profile

This course is intended for administrators, consultants, engineers who are interested in using Oracle Database.

Prerequisites

Course outline

Module 1: Introduction and Configuration

Module Overview

This module gives you the knowledge and skills needed to develop appropriate backup and recovery procedures to address your business needs, to Implement backup and recovery settings and perform backup operations to disk and tape, to employ Oracle Database recovery procedures to recover from media and other failures, to diagnose and repair data failures, to use flashback technologies and data duplication to complement backup and recovery procedures, to secure the availability of your database by appropriate backup and recovery strategies.

Lessons

Introduction
Getting Started
Configuring for Recoverablility
Using the RMAN Recovery Catalog

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Describe the Oracle Database architecture components related to backup and recovery operations.
Configure the database for recoverability.

Module 2: Backup

Module Overview

Lessons

Backup Strategies and Terminology
Performing Backups
Improving Your Backups
Using RMAN-Encrypted Backups

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Plan effective backup and recovery procedures.
Use Recovery Manager (RMAN) to create backups and perform recovery operations.

Module 3: Recovery

Module Overview

Lessons

Diagnosing Failures
Restore and Recovery Concepts
Performing Complete Recovery
Performing Point-in-Time Recovery
Performing Additional Recovery Operations

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure.
Use the Data Recovery Advisor to diagnose and repair failures.
Perform tablespace point-in-time recovery.

Module 4: Additional Technologies

Module Overview

Lessons

Using Flashback Technologies
Using Flashback Database
Transporting Data
Duplicating a Database
RMAN Troubleshooting and Tuning

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Use Oracle Flashback Technologies to recover from human error.
Perform an encrypted database backup and restore.

Module 5: Hands-On

Module Overview

Lessons

Backup and Recovery Workshop

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

How to backup and recovery workshop.

Book Your Seat

Find Learning Paths

Course 20703-1-B: Administering System Center Configuration Manager

Join our community of certified professionals

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Policy for the Prevention and Combating of Violence and Harassment in the Workplace.

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Contact Us

International Computer Training Center