CREATING REGULAR CDBs AND PDBs

– Configure and create a CDB

– Create a new PDB from the CDB seed

– Exploring the PDB structure

MANAGING CDBs AND PDBs

–  Manage PDB service names and connections

– Manage the startup, shutdown and availability of CDBs and PDBs.

– Modify the different modes and parameters of PDBs

– Evaluate the impact of parameter value changes

– Manage CDB and PDB performance

– Monitor CDB and PDB resource usage with Oracle Resource Manager.

BACKUPS AND DUPLICATIONS

– Perform backups and recover CDBs and PDBs

– Duplicate an active PDB

– Duplicating a database

–  Upgrading and transporting regular CDBs and PDBs

– Upgrade an Oracle database

– Transporting data

APPLICATION PDB MANAGEMENT

– Explain the purpose of the application root and the application seed.

– Define and create application PDBs

– Install, upgrade and patch applications

– Create and administer application PDBS

– Clone PDBs and application containers

– Connect and disconnect operations with PDBs and application containers

– Comparison of local and shared undo mode

MANAGING SECURITY IN SHARED DATABASES

– Manage security in multitenant databases

– Manage PDB locking profiles

– Audit users in CDBs and PDBs

– Manage other types of policies in application containers

RECOVERY AND FLASHBACK

– Restore and recover databases with RMAN

– Perform CDB and PDB flashback

BACKUP STRATEGIES AND TERMINOLOGY

– Perform full and incremental backups and restores

– Compress and encrypt RMAN backups

– Using a media manager

– Create multi-section backups of very large files

– Create duplex backup sets

– Create archive backups

– Backing up recovery files

– Backing up non-database files

– Backing up ASM metadata

RESTORATION AND RECOVERY CONCEPTS

– Employ the best Oracle Database recovery technology for your failure situation

– Describe and use crash, full recovery and point-in-time recovery technology

USE FLASHBACK TECHNOLOGIES

– Configure your database to support flashback

– Perform flashback operations

DUPLICATE A DATABASE

– Duplicate databases

CONFIGURING AND USING RMAN

– Configure RMAN and the database for recoverability

– Configure and use a RMAN recovery catalog

TROUBLESHOOTING

– Detect and repair database and database block corruption

– Diagnose database problems

PERFORM RECOVERY

– Restore and recover databases with RMAN

– Perform database recovery without RMAN

TRANSPORT DATA

– Transporting data

TROUBLESHOOTING AND TUNING OF RMAN

– Interpret RMAN message output

– Diagnose RMAN performance problems

INSTALL GRID INFRASTRUCTURE AND ORACLE SGBD

– Install Grid Infrastructure for a standalone server

– Install Oracle database software

UPDATE GRID INFRASTRUCTURE AND ORACLE SGBD

– Update Grid Infrastructure and Oracle DBMS

ORACLE GRID INFRASTRUCTURE UPGRADE

– Upgrade Oracle Grid Infrastructure

ORACLE DBMS 18c: NEW FEATURES

– Image and RPM based database installation

DATABASE CONFIGURATION USING THE CONFIGURATION WIZARD (DBCA)

– Create, delete and configure databases using DBCA

ORACLE RESTART

– Configure and use Oracle Restart to manage components

UPGRADE AN ORACLE DATABASE

– Upgrade Plan for an Oracle Database

– Upgrade an Oracle Database

– Perform post upgrade tasks

GRID INFRASTRUCTURE INSTALLATION FOR A STANDALONE SERVER

– Rapid Home Provisioning (RHP)

USING GENERAL DATABASE ENHANCEMENTS

– Install Oracle Database software

– Create, delete and configure databases using DBCA

– Create regular CDBs and PDBs

– Use the various new features of version 19c

– Create, delete and configure databases using DBCA

USING AVAILABILITY ENHANCEMENTS

– Using a RMAN recovery catalog

– Using the Flashback database

USING DIAGNOSTIC ENHANCEMENTS

– Using the new diagnostic features

MONITORING AND TUNING DATABASE PERFORMANCE

– Managing Memory Components

– Understanding the Automatic Workload Repository (AWR)

– Understanding the Advisory Framework

– Monitoring wait events, sessions and services

– Manage metric thresholds and alerts

– Understand and use the performance tuning methodology

– Performance planning

– Understanding Automatic Database Diagnostic Monitor (ADDM)

SQL TUNING INSTRUCTIONS

– Understanding the Oracle Optimizer

– Using SQL Tuning Advisor

– Managing Optimizer Statistics

– Using the SQL Access Advisor

– Understanding the SQL Tuning Process

Duration: 16 days

PRE-REQUISITES

Good knowledge of the Oracle DBMS and the SQL language. It is necessary but not mandatory to be certified Oracle Database Administration I: 1Z0-082.