Course Description:
Oracle Database 19c Backup and Recovery is a comprehensive, hands-on course that allows DBAs to develop appropriate backup and recovery procedures to address their business model and requirements. Students will explore how to implement basic backup and recover procedures, move data between databases and files, and employ basic monitoring procedures. Students will also learn how to secure the availability of their database by using appropriate backup and recovery strategies.
Course Topics
Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most. Topics, agenda and labs are subject to change, and may adjust during live delivery based on audience needs and skill-level.
Introduction
- Oracle Maximum Availability Architecture
- Assess your recovery requirements
- Categories of failures
- Basic Workshop Architecture
- Curriculum Context
- Oracle backup and recovery solutions
- Overview of Oracle Secure Backup and Oracle Data Guard
- Getting Started
- Oracle DBA tools for backup and recovery
- Connecting to Oracle Recovery Manager (RMAN)
- Review of Oracle Database architecture
Configuring for Recoverability
- Configuring and managing persistent settings
- Multiplexing the control file
- RMAN commands
- Archiving redo log files
- Using the Fast Recovery Area (FRA)
- Multiplexing redo log files
Using the RMAN Recovery Catalog
- Creating and Configuring the Recovery Catalog
- Using RMAN Stored Scripts
- Using Virtual Private Catalogs
- Managing Target Database Records in the Recovery Catalog
- Maintaining and Protecting the Recovery Catalog
Backup Strategies and Terminology
- Backing Up Read-Only Tablespaces
- Balancing Backup and Restore Requirements
- Backup Terminology
- Data Warehouse Backup and Recovery: Best Practices
Performing Backups
- RMAN Backup Types
- Oracle-Suggested Backup
- Reporting on Backups
- Managing Backups
- Fast Incremental Backup
- Incrementally Updated Backup
What You'll Learn
Our engaging instructors and mentors are highly-experienced practitioners who bring years of current “on-the-job” experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will learn to:
- Implement backup and recovery settings and perform backup operations to the media of your choice.
- Move data between databases and files
- Use Oracle Database recovery processes to recover from media and other failures.
- Diagnose and repair data failures
- Use flashback technologies and data duplication to complement backup and recovery procedures
- Secure the availability of their database using backup and recovery strategies
Prerequisites
Incoming students should possess:
- Knowledge of SQL and PL/SQL (for DBA use)
- Knowledge of Oracle Database 18c or newer
- Linux skills, including familiarity with command-line options such as ls, cd, cp, and su
Inclusions
With CCS Learning Academy, you’ll receive:
- 3 Day Certified Instructor-led training
- Official Training Seminar Student Handbook
- Collaboration with classmates (not currently available for self-paced course)
- Real-world learning activities and scenarios
- Exam scheduling support*
- Enjoy job placement assistance for the first 12 months after course completion.
- This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
- Government and Private pricing available.*
*For more details call:Â 858-208-4141Â or email:Â training@ccslearningacademy.com; sales@ccslearningacademy.com