Your Cart Is Empty
Home > Technical Courses > Oracle Database > Oracle Database 19c Administration II (Oracle DBA II)
Explore Next-Level DBA Skills: Backup & Recovery, Working with Grid Infrastructure, Upgrading Oracle and More
Geared for participants experienced with Oracle 19c DBA essentials Oracle 19c Database Administration Workshop II expands their understanding of Oracle database administration. Throughout the course students will explore coverage of Multitenant (CDB/PDB), database tuning, SQL tuning, and backup and recovery: the skills needed to keep a database running reliably and efficiently. The current release of the database is used for exercises and demonstrations, and the content back-ported as necessary for previous releases.NOTE: This training is NOT Official Oracle University training. This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas. This course is for 19c. It is also available for earlier editions (11g, 12c, etc). Please inquire for details.
Category
ID
Duration
Level
Price
Oracle Database
13058
5 Day(s)
Intermediate
$2,625.00
Objectives
Working in a hands-on learning environment led by our expert facilitator, students will explore:· 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
Creating CDBs and Regular PDBs· Configure and create a CDB· Create a new PDB from the CDB seed· Explore the structure of PDBs Manage CDBs and PDBs· Manage PDB service names and connections· Manage startup, shutdown and availability of CDBs and PDBs· Change the different modes and settings of PDBs· Evaluate the impact of parameter value changes· Performance management in CDBs and PDBs· Control CDB and PDB resource usage with the Oracle Resource Manager Backup and Duplicate· Perform Backup and Recover CDBs and PDBs· Duplicate an active PDB· Duplicate a Database Upgrading and Transporting CDBs and Regular PDBs· Upgrade an Oracle Database· Transport Data Backup Strategies and Terminology· Perform Full and Incremental Backups and Recoveries· Compress and Encrypt RMAN Backups· Use a media manager· Create multi-section backups of exceptionally large files· Create duplexed backup sets· Create archival backups· Backup of recovery files· Backup non database files· Back up ASM meta data Restore and Recovery Concepts· Employ the best Oracle Database recovery technology for your failure situation· Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery Using Flashback Technologies· Configure your Database to support Flashback· Perform flashback operations Duplicating a Database Install Grid Infrastructure and Oracle Database· Install Grid Infrastructure for a Standalone server· Install Oracle Database software Patching Grid Infrastructure and Oracle Database Upgrading to Oracle Grid Infrastructure Oracle Database 18c: New Features· Image and RPM based Database Installation Using General Overall Database Enhancements· Install Oracle Database software· Create, Delete and Configure Databases using DBCA· Creating CDBs and Regular PDBs· Use Miscellaneous 19c New Features Monitoring and Tuning Database Performance· Managing Memory Components· Understanding the Automatic Workload Repository (AWR)· Understanding the Advisory Framework· Monitoring Wait Events, Sessions, and Services· Managing Metric Thresholds and Alerts· Understanding and Using the Performance Tuning Methodology· Performing Performance Planning· Understanding the Automatic Database Diagnostic Monitor (ADDM) Manage Application PDBs· Explain the purpose of application root and application seed· Define and create application PDBs· Install, upgrade and Patch applications· Create and administer Application PDBS· Clone PDBs and Application containers· Plug and unplug operations with PDBs and application containers· Comparing Local Undo Mode and Shared Undo Mode Manage Security in Multitenant databases· Manage Security in Multitenant databases· Manage PDB lockdown profiles· Audit Users in CDBs and PDBs· Manage other types of policies in application containers Recovery and Flashback· Restore and Recovering Databases with RMAN· Perform CDB and PDB flashback Configuring and Using RMAN· Configure RMAN and the Database for Recoverability· Configure and Using an RMAN recovery catalog Diagnosing Failures· Detect and repair database and database block corruption· Diagnosing Database Issues Performing Recovery· Restore and Recovering Databases with RMAN· Perform Non RMAN database recovery Transporting Data RMAN Troubleshooting and Tuning· Interpret the RMAN message output· Diagnose RMAN performance issues Creating an Oracle Database by using DBCA· Create, Delete and Configure Databases using DBCA Oracle Restart· Configure and use Oracle Restart to manage components Upgrade the Oracle Database· Plan for Upgrading an Oracle Database· Upgrade an Oracle Database· Perform Post-Upgrade tasks Install Grid Infrastructure for a Standalone server· Rapid Home Provisioning Using Availability Enhancements· Use an RMAN recovery catalog· Use Flashback Database Tuning SQL Statements· Understanding the Oracle Optimizer· Using the SQL Tuning Advisor· Managing Optimizer Statistics· Using the SQL Access Advisor· Understanding the SQL Tuning Process
Questions?
Oracle Certified Associate (OCA)
Oracle Database 19c Administration
Oracle Database 19c Administration II (Oracle DBA II)
Class Schedule
Course Overview
Training Delivery Methods
With Productivity Point, you will have a spectrum of delivery methods to choose from... when where and how you like it. Whether it's in a classroom or online, we have a delivery option to meets your needs.
Classroom Live
Classroom Virtual
Live Online
Private Group
On Demand
Classroom Live Training
Get in-person, hands-on instruction with live lab exercises taught by subject matter experts who deliver authorized and industry-leading content.
With classrooms in almost every major U.S. city, Productivity Point has something for users of every level, so you can earn the most popular industry certifications. You get hands-on learning experience with live lab exercises taught by experienced instructors. We proudly advocate our learning services to be hosted by the best-qualified trainers in terms of technical knowledge and teaching skills.
Classroom Virtual Training
Prefer to have a dedicated classroom for your virtual experience? Attend live, hands- on training via remote instructor from one of Productivity Point’s multiple locations.
Enjoy a focused and professional training environment, including all technical equipment provided along with administrative and technical support at your fingertips. With over 150 locations to choose from, review our course catalog or contact your personal Productivity Point Account Manager to see if the course you have in mind is delivered at one of our dedicated virtual classrooms in your area.
Live Online Training
Blend the best from traditional face-to-face instructor-led training with the latest in conferencing technology.
Private Group Training
Your private group classroom experience will not only take place in the location of your choice (including any of our training centers), but you will enjoy the following amenities:
On-Demand Learning
On-Demand is an IT training solution designed around your schedule, budget, and learning needs. Combining high-quality video, reading, and knowledge checks in a self-paced format, On-Demand helps you build skills as your schedule allows—all at once or five minutes at a time.
With On-Demand, you learn at your own pace and in the convenience of your own space.
With Learn at your own pace…
Productivity Point Learning Solutions evolved out of a desire to increase our outreach both nationally and internationally.
Productivity Point Headquarters 1580 Sawgrass Corporate Parkway Suite 205 Sunrise, Florida 33323 United States
Contact T 1-844-238-8607 P 1-954-425-6141 F 1-954-928-9057 E info@productivitypointls.com