COURSE OBJECTIVE
This Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You’ll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. In this course, you will be introduced to Oracle Database Cloud Service.
WHO CAN BENEFIT
- Technical Administrator
- Database Administrators
- Database Designers
- Support Engineer
GAINING SKILLS
After completing this course, students will be able to:
- 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.
COURSE CERTIFICATION
OCP
PREREQUISITE
Before attending this course, students must have:
- Knowledge of SQL and PL/SQL
- Knowledge of Oracle Database 12c
COURSE CONTENT
- Introduction
- Getting Started
- Configuring for Recoverablility
- Using the RMAN Recovery Catalog
- Backup Strategies and Terminology
- Performing Backups
- Improving Your Backups
- Using RMAN-Encrypted Backups
- Diagnosing Database Failures
- Restore and Recovery Concepts
- Diagnosing Database Failures
- Performing Recovery, Part 1
- Performing Recovery, Part 2
- RMAN and Oracle Secure Backup
- Performing Tape Backups and Restores
- Using Flashback Technologies
- Using Flashback Database
- Managing Backup Space or Transporting Data
- Duplicating a Database
- RMAN Performance and Tuning
- Backup and Recovery Workshop
ABOUT INSTRUCTOR
