Oracle Database 19c: Backup and Recovery
Course code
19cDB-BR
Duration
4 Days, 32 Acad. Hours
Course Overview
Objectives
Prerequisites
Course Outline
Course Overview
Course overview
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.
Objectives
Course Objectives
Upon completion of this course, the student should be able to:
- Develop appropriate backup and recovery procedures to address your business needs.
- Implement backup and recovery settings and perform backup operations to disk and tape.
- Employ Oracle Database recovery procedures 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 your database by appropriate backup and recovery strategies.
Prerequisites
Prerequisites
- 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
Audience:
- Administrator
- Database Administrator
Course Outline
Course Outline
- Backup and Recovery: Overview
- Backup and Recovery Configuration
- Using Recovery Manager (RMAN)
- Backup Strategies
- Creating Database Backups
- Using Optional Backup Features
- Tuning RMAN Backup Performance
- Recovery Catalog: Overview
- Creating a Recovery Catalog
- Managing Target Database Records
- Using Stored Scripts
- Creating and Using Virtual Private Catalogs
- Restore and Recovery Concepts
- Diagnosing Failure
- Performing Complete Recovery
- Performing Point-in-Time Recovery
- Performing Block Media Recovery
- Performing Additional Recovery Operations
- Oracle Flashback Technology: Overview
- Using Logical Flashback Features
- Using Flashback Database
- Using PDB Snapshot
- Database Duplication Overview
- Creating a Backup-Based Duplicate Database
