• No products in the cart.

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.

PRIVATE
Course Access

Unlimited Duration

Last Updated

March 4, 2021

Students Enrolled

Total Reviews

Posted by
Certification

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
    • Upgrade an Oracle Database 00:00:00
    • Transport Data 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
    • Employ the best Oracle Database recovery technology for your failure situation 00:00:00
    • Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery 00:00:00
    • Configure your Database to support Flashback 00:00:00
    • Perform flashback operations 00:00:00
    • Duplicate Databases 00:00:00
    • Install Grid Infrastructure for a Standalone server 00:00:00
    • Install Oracle Database software 00:00:00
    • Patch Grid Infrastructure and Oracle Database 00:00:00
    • Upgrade Oracle Grid Infrastructure 00:00:00
    • Image and RPM based Database Installation 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
    • Managing Memory Components 00:00:00
    • Understanding the Automatic Workload Repository (AWR) 00:00:00
    • Understanding the Advisory Framework 00:00:00
    • Monitoring Wait Events, Sessions, and Services 00:00:00
    • Managing Metric Thresholds and Alerts 00:00:00
    • Understanding and Using the Performance Tuning Methodology 00:00:00
    • Performing Performance Planning 00:00:00
    • Understanding the Automatic Database Diagnostic Monitor (ADDM) 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
    • Manage Security in Multitenant databases 00:00:00
    • Manage PDB lockdown profiles 00:00:00
    • Audit Users in CDBs and PDBs 00:00:00
    • Manage other types of policies in application containers 00:00:00
    • Restore and Recovering Databases with RMAN 00:00:00
    • Perform CDB and PDB flashback 00:00:00
    • Configure RMAN and the Database for Recoverability 00:00:00
    • Configure and Using an RMAN recovery catalog 00:00:00
    • Detect and repair database and database block corruption 00:00:00
    • Diagnosing Database Issues 00:00:00
    • Restore and Recovering Databases with RMAN 00:00:00
    • Perform Non RMAN database recovery 00:00:00
    • Transport Data 00:00:00
    • Interpret the RMAN message output 00:00:00
    • Diagnose RMAN performance issues 00:00:00
    • Create, Delete and Configure Databases using DBCA 00:00:00
    • Configure and use Oracle Restart to manage components 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
    • Rapid Home Provisioning 00:00:00
    • Use an RMAN recovery catalog 00:00:00
    • Use Flashback Database 00:00:00
    • Understanding the Oracle Optimizer 00:00:00
    • Using the SQL Tuning Advisor 00:00:00
    • Managing Optimizer Statistics 00:00:00
    • Using the SQL Access Advisor 00:00:00
    • Understanding the SQL Tuning Process 00:00:00

    Course Reviews

    Profile Photo
    ashar hafeez
    0
    62

    Students

    About Instructor

    Pak

    Course Events

    [wplms_eventon_events]

    More Courses by Insturctor

    © 2021 Ernesto.  All rights reserved.  
    X