(Online Delivery) Oracle 19c Database Administration II (Oracle 19c DBA II)

Live online events

Hide filters

5 days, 08:30 AM EST - 04:30 PM EST

Online

  • $3,995.00 excl.

Description

 Course Description

This advanced Oracle Database 19c administration course builds on foundational database administration skills and focuses on enterprise-level management tasks. Students learn advanced storage management, multitenant database administration, backup and recovery strategies, performance tuning, security implementation, automation, and high-availability planning.

Prerequisites

Students should have completed Oracle Database Administration Part 1 or possess equivalent experience with:

  • Oracle architecture
  • Database creation and configuration
  • User and privilege management
  • Basic tablespace administration
  • Oracle networking fundamentals
  • SQL fundamentals

Learning Objectives

Upon completion of this course, students will be able to:

  • Manage Oracle multitenant environments
  • Configure advanced storage structures
  • Implement RMAN backup and recovery solutions
  • Perform database recovery operations
  • Monitor and tune database performance
  • Secure Oracle databases using advanced features
  • Automate administrative tasks
  • Support high availability and disaster recovery initiatives

Day 1: Advanced Storage and Multitenant Administration

Module 1: Oracle Multitenant Architecture Review

  • CDB and PDB architecture
  • Resource management in multitenant environments
  • Administrative considerations

Module 2: Managing Pluggable Databases

  • Creating PDBs from seed databases
  • Cloning PDBs
  • Unplugging and plugging databases
  • Refreshable PDBs
  • PDB relocation

Module 3: Advanced Storage Management

  • Oracle Managed Files
  • Bigfile tablespaces
  • Temporary tablespace groups
  • Undo management
  • Space management and monitoring

Labs

  • Create and clone PDBs
  • Relocate a PDB
  • Configure advanced tablespace options

Day 2: Backup and Recovery with RMAN

Module 4: Backup Architecture

  • Recovery objectives
  • ARCHIVELOG mode
  • Flash Recovery Area
  • Backup planning

Module 5: RMAN Administration

  • RMAN architecture
  • Full backups
  • Incremental backups
  • Image copies
  • Backup optimization

Module 6: Recovery Catalog Management

  • Creating a recovery catalog
  • Registering databases
  • Catalog maintenance

Labs

  • Configure RMAN
  • Create backup schedules
  • Manage recovery catalog operations

Day 3: Advanced Recovery Techniques

Module 7: Database Recovery Operations

  • Instance recovery
  • Crash recovery
  • Media recovery
  • Lost control file recovery
  • Lost redo log recovery

Module 8: Flashback Technologies

  • Flashback Query
  • Flashback Table
  • Flashback Database
  • Recycle Bin management

Module 9: Point-in-Time Recovery

  • Database PITR
  • Tablespace PITR
  • Object recovery techniques

Labs

  • Recover lost data files
  • Perform Flashback operations
  • Execute point-in-time recovery

Day 4: Performance Monitoring and Tuning

Module 10: Performance Monitoring Framework

  • Wait events
  • Performance views
  • Metrics and alerts

Module 11: Automatic Diagnostic Tools

  • AWR
  • ADDM
  • ASH
  • SQL Monitoring

Module 12: SQL and Memory Tuning

  • Identifying inefficient SQL
  • Optimizer concepts
  • Memory advisors
  • Resource Manager

Labs

  • Analyze AWR reports
  • Tune SQL statements
  • Optimize memory settings

Day 5: Security, Automation, and High Availability

Module 13: Advanced Security Administration

  • Unified Auditing
  • Privilege analysis
  • Transparent Data Encryption
  • Security best practices

Module 14: Automation and Maintenance

  • Oracle Scheduler
  • Automated maintenance tasks
  • Health monitoring
  • Maintenance windows

Module 15: High Availability and Disaster Recovery Concepts

  • Oracle Data Guard architecture
  • Physical and logical standby databases
  • Fast-Start Failover concepts
  • Business continuity planning

Capstone Administration Workshop

  • Create and manage a PDB
  • Configure secure access
  • Implement RMAN backups
  • Recover from simulated failures
  • Analyze performance bottlenecks
  • Automate routine maintenance

Labs

  • Configure auditing
  • Schedule maintenance jobs
  • Implement backup and recovery scenarios
  • Analyze performance issues