I. Overview:

Oracle Database 19c: Multitenant Architecture Course Overview

The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. Through a blend of hands-on labs and interactive lectures you will explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs).

Oracle Database 19c: Backup and Recovery Course Overview

Enroll for the 5-day Oracle Database 19c: Backup and Recovery from Koenig Solutions accredited by Oracle. This course is designed to give an Oracle database administrator practical experience in planning and implementing a backup and recovery strategy using Recovery Manager and Flashback Database.

Through a blend of hands-on labs and interactive lectures you will also learn how to perform backup and recovery operations using RMAN and also various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures

II. Duration: 5 days (40 hours)

III. Objectives:

After completing Oracle Database 19c: Multitenant Architecture Course, you will be able to:

• Core concepts of regular PDBs
• Creating a CDB, and then using different methods to create PDBs.
• How to start and shut down a CDB and how to open and close a PDB.
• Security aspects in CDBs and PDBs in various areas like privileges and roles, lockdown profiles, auditing, Database Vault, and encryption.
• Availability through backup, duplicate, recovery, and flashback topics and then performance, monitoring, and resources allocation management in CDBs and PDBs.
• How you can move data from a non-CDB environment to a PDB.
• How to move data between PDBs by using utilities such as the export and import features of Oracle Data Pump, SQL*Loader, external tables, and Oracle Recovery Manager.

The Oracle Database 19c: Backup and Recovery course is designed to provide the skills needed to enable a delegate to plan and implement a backup and recovery strategy in the workplace for Oracle Databases using RMAN and Flashback Database technologies.

After completing the Oracle Database 19c: Multitenant Architecture, Backup and Recovery (OCP) course, students will be able to pass exams: 1z0-083: Oracle Database Administration II. The second exam in a two exam path to obtain the Oracle Certified Professional (OCP) 19c certification.

The Oracle Certified Professional (OCP) 19c certification includes two exams: 1Z0-082: Oracle Database Administration I and 1Z0-083: Oracle Database Administration II.

IV. Intended Audience:

• Database administrators
• IT professionals looking to update their knowledge on Oracle Database
• System analysts and engineers
• IT managers handling database solutions
• Data warehouse administrators
• Technical consultants
• Tech-savvy individuals who want to expand their skill envelope Individuals seeking Oracle Database certification.

V. Prerequisites:

There are several prerequisites for attending this courses. Candidates should have the following:

• Basic understanding SQL
• Knowledge in Linux Operating System

VI. Course outlines:

ORACLE DATABASE 19C: BACKUP AND RECOVERY

Module 1: Backup and Recovery: Overview

Module 2: Backup and Recovery Configuration

Module 3: Using Recovery Manager (RMAN)

Module 4: Backup Strategies

Module 5: Creating Database Backups

Module 6: Using Optional Backup Features

Module 7: Tuning RMAN Backup Performance

Module 8 Recovery Catalog: Overview

Module 9: Creating a Recovery Catalog

Module 10: Managing Target Database Records

Module 11: Using Stored Scripts

Module 12: Creating and Using Virtual Private Catalogs

Module 13: Restore and Recovery Concepts

• Perform Recovery in Noarchivelog Mode
• Perform Complete Recovery in Archivelog Mode
• Use the Flash Recovery Area for Fast Recovery
• Automatic Tempfile Recovery
• Identify the Database Files to Restore and Recover
• Preview Backups used in Restore Operations
• Apply Incremental Backups to Restore Datafile Image Copies
• The Switch Command
• The Data Recovery Advisor
• Perform Incomplete Recovery (PITR)
• Restore and Recover a tablespace
• Restore and Recover Datafiles
• Recover a Datafile Not Backed Up
• Table Recovery from Backups
• Recover Individual Data Blocks
• The Data Recovery Advisor

Module 14: Diagnosing Failure

Module 15: Performing Complete Recovery

Module 16: Performing Point-in-Time Recovery

Module 17: Performing Block Media Recovery

Module 18: Performing Additional Recovery Operations

Module 19: Oracle Flashback Technology: Overview

Module 20: Using Logical Flashback Features

Module 21: Using Flashback Database

Module 22: Using PDB Snapshot

Module 23: Database Duplication Overview

Module 24: Creating a Backup-Based Duplicate Database

ORACLE DATABASE 19C: MULTITENANT ARCHITECTURE

Module 1: Multitenant Architecture

• CDB Basics
• CDB and Regular PDBs
• Application PDBs and Application Installation

Module 2: PDB Creation

• PDB Creation
• CDB and PDB Management
• Storage

Module 3: Security

• Security
• Backup and Duplicate
• Recovery and Flashback
• Performance
• Resources Allocation

Module 4: Data Movement

• Data Movement
• Upgrade Methods
• Miscellaneous