Live online events
Want to run this event in-house? Enquire about running this event in-house
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
Recent Comments