Formation ORACLE 19C DATABASE ADMINISTRATION II (ORACLE DBA II)

Module 1: Container and Pluggable Database Creation

Setup and configure a Container Database (CDB)

Creation of Pluggable Databases (PDBs) from CDB seed

Exploration of PDB structure and functionality

Module 2: CDB and PDB Management

Administration of PDB service names and connections

Management of CDB and PDB startup, shutdown, and availability

Adjustment of PDB modes and settings

Assessment of parameter value changes and performance management in CDBs and PDBs

Resource usage control with Oracle Resource Manager

Module 3: Backup and Duplication

Backup and recovery procedures for CDBs and PDBs

Duplication of active PDBs and entire databases

Module 4: Upgrade and Data Transport

Oracle Database upgrade process

Data transportation methods between databases

Module 5: Backup Strategies and Terminology

Full and incremental backup strategies

Compression and encryption techniques for RMAN backups

Utilization of media managers and multi-section backups

Management of archival and non-database file backups

Backup of ASM metadata

Module 6: Restoration and Recovery Concepts

Application of appropriate recovery technology for various failure scenarios

Crash, complete, and point-in-time recovery methodologies

Module 7: Flashback Technologies

Configuration and usage of flashback features for database recovery

Module 8: Database Duplication

Techniques for duplicating databases

Module 9: Grid Infrastructure and Oracle Database Installation

Installation procedures for Grid Infrastructure and Oracle Database software

Module 10: Grid Infrastructure and Database Patching and Upgrading

Patching and upgrading processes for Grid Infrastructure and Oracle Database

Module 11: Oracle Database 18c: New Features

Installation techniques for Oracle Database 18c

Module 12: General Database Enhancements

Miscellaneous features and enhancements in Oracle Database 19c

Database creation, deletion, and configuration using Database Configuration Assistant (DBCA)

Module 13: Performance Monitoring and Tuning

Memory management

Automatic Workload Repository (AWR) usage

Advisory framework utilization

Wait events, sessions, and services monitoring

Performance tuning methodology

Performance planning

Automatic Database Diagnostic Monitor (ADDM) understanding

Module 14: Application PDB Management

Creation, installation, and administration of application PDBs

Clone and plug/unplug operations with PDBs and application containers

Comparison of local and shared undo modes

Module 15: Multitenant Database Security Management

Security management in multitenant databases

PDB lockdown profiles and user auditing

Module 16: Recovery and Flashback Operations

Restoration and recovery procedures with RMAN

CDB and PDB flashback operations

Module 17: RMAN Configuration and Troubleshooting

RMAN configuration for database recoverability

Troubleshooting RMAN performance issues

Module 18: Database Creation using DBCA

Database creation, deletion, and configuration using Database Configuration Assistant (DBCA)

Module 19: Oracle Restart Configuration

Configuration and usage of Oracle Restart for component management

Module 20: Oracle Database Upgrade

Planning and execution of Oracle Database upgrades

Post-upgrade tasks implementation

Module 21: Grid Infrastructure Installation for Standalone Servers

Rapid Home Provisioning techniques

Module 22: Availability Enhancements

RMAN recovery catalog utilization

Flashback Database usage

Module 23: SQL Statement Tuning

Understanding Oracle Optimizer behavior

SQL Tuning Advisor and SQL Access Advisor usag

Optimizer statistics management and SQL tuning process understanding