ratingsÂ
Geared for participants experienced with Oracle 19c DBA essentials Oracle 19c Database Administration Workshop II (Oracle DBA II) expands their understanding of Oracle database administration.
Unlimited Duration
March 4, 2021
This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. In this course you will learn about,
· Creating CDBs and Regular PDBs
· Managing CDBs and PDBs
· Backup and Duplicate
· Upgrading and Transporting CDBs and Regular PDBs
· Backup Strategies and Terminology
· Restore and Recovery Concepts
· Using Flashback Technologies
· Duplicating a Database
· Installing Grid Infrastructure and Oracle Database
· Patching Grid Infrastructure and Oracle Database
· Upgrading to Oracle Grid Infrastructure
· Oracle Database 18c: New Features
· Using General Overall Database Enhancements
· Monitoring and Tuning Database Performance
· Managing Application PDBs
· Managing Security in Multitenant databases
· Recovery and Flashback
· Configuring and Using RMAN
· Diagnosing Failures
· Performing Recovery
· Transporting Data
· RMAN Troubleshooting and Tuning
· Creating an Oracle Database by using DBCA
· Oracle Restart
· Upgrading the Oracle Database
· Installing Grid Infrastructure for a Standalone server
· Using Availability Enhancements
· Tuning SQL Statements
Course Curriculum
-
- Configure and create a CDB 00:00:00
- Create a new PDB from the CDB seed 00:00:00
- Explore the structure of PDBs 00:00:00
-
- Manage PDB service names and connections 00:00:00
- Manage startup, shutdown and availability of CDBs and PDBs 00:00:00
- Change the different modes and settings of PDBs 00:00:00
- Evaluate the impact of parameter value changes 00:00:00
- Performance management in CDBs and PDBs 00:00:00
- Control CDB and PDB resource usage with the Oracle Resource Manager 00:00:00
- Perform Backup and Recover CDBs and PDBs 00:00:00
- Duplicate an active PDB 00:00:00
- Duplicate a Database 00:00:00
- Perform Full and Incremental Backups and Recoveries 00:00:00
- Compress and Encrypt RMAN Backups 00:00:00
- Use a media manager 00:00:00
- Create multi-section backups of exceptionally large files 00:00:00
- Create duplexed backup sets 00:00:00
- Create archival backups 00:00:00
- Backup of recovery files 00:00:00
- Backup non database files 00:00:00
- Back up ASM meta data 00:00:00
- Configure your Database to support Flashback 00:00:00
- Perform flashback operations 00:00:00
- Install Grid Infrastructure for a Standalone server 00:00:00
- Install Oracle Database software 00:00:00
- Upgrade Oracle Grid Infrastructure 00:00:00
- Install Oracle Database software 00:00:00
- Create, Delete and Configure Databases using DBCA 00:00:00
- Creating CDBs and Regular PDBs 00:00:00
- Use Miscellaneous 19c New Features 00:00:00
- Explain the purpose of application root and application seed 00:00:00
- Define and create application PDBs 00:00:00
- Install, upgrade and Patch applications 00:00:00
- Create and administer Application PDBS 00:00:00
- Clone PDBs and Application containers 00:00:00
- Plug and unplug operations with PDBs and application containers 00:00:00
- Comparing Local Undo Mode and Shared Undo Mode 00:00:00
- Restore and Recovering Databases with RMAN 00:00:00
- Perform CDB and PDB flashback 00:00:00
- Detect and repair database and database block corruption 00:00:00
- Diagnosing Database Issues 00:00:00
- Transport Data 00:00:00
- Create, Delete and Configure Databases using DBCA 00:00:00
- Plan for Upgrading an Oracle Database 00:00:00
- Upgrade an Oracle Database 00:00:00
- Perform Post-Upgrade tasks 00:00:00
- Use an RMAN recovery catalog 00:00:00
- Use Flashback Database 00:00:00
Course Reviews

Students