Descripción del curso:
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.
Temas del curso
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.
Introducción
- 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
Lo que aprenderás
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
Requisitos previos
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
Inclusiones
Con CCS Learning Academy, recibirás:
- Capacitación de 3 días dirigida por un instructor certificado
- Manual del Estudiante del Seminario Oficial de Capacitación
- Colaboración con compañeros de clase (actualmente no disponible para cursos a su propio ritmo)
- Escenarios y actividades de aprendizaje del mundo real.
- Soporte para la programación de exámenes*
- Disfrute de asistencia para la colocación laboral durante los primeros 12 meses después de finalizar el curso.
- Este curso es elegible para el programa Learn and Earn de CCS Learning Academy: obtenga un reembolso de la matrícula de hasta 50% si se le coloca en un trabajo a través de CCS Global Tech. División de colocación*
- Precios gubernamentales y privados disponibles.*
*Para más detalles llame al: 858-208-4141 o correo electrónico: formación@ccslearningacademy.com; ventas@ccslearningacademy.com
Spanish 
English