(Online Delivery) Oracle 19c Database Administration II (Oracle 19c DBA II)
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