Oracle Database 19c - Backup and Recovery Training Course

Oracle Database 19c is a multi-model database designed to provide comprehensive support for both relational and non-relational data.

This instructor-led, live training (available online or on-site) is tailored for intermediate-level system administrators and database administrators who aim to manage, monitor, secure, back up, and recover Oracle Database 19c in Standard Edition 2 environments. Additionally, participants will learn to plan a clear migration path from 11g to 19c.

By the end of this training, participants will be able to:

• Prepare the environment and execute clean installations and configurations of Oracle Database 19c SE2 for government use.
• Explain key components of the Oracle infrastructure, including the System Global Area (SGA), Program Global Area (PGA), Shared Pool, Database Buffer Cache, and Redo mechanisms.
• Utilize administration tools such as Enterprise Manager (EM Express) and SQL Developer for routine operations.
• Implement best practices for storage management, including the organization of tablespaces, datafiles, and segment space usage.
• Enhance database security through the management of users, roles, privileges, profiles, and auditing mechanisms.
• Develop and execute RMAN-based backup and recovery strategies that align with Recovery Time Objective (RTO) and Recovery Point Objective (RPO) goals.
• Monitor and troubleshoot performance issues using dynamic performance views, SQL tracing, and execution plans.
• Plan and execute the transition or migration from 11g to 19c, utilizing supported upgrade paths and tools.

Format of the Course

• Interactive lecture and discussion sessions.
• Extensive exercises and practice opportunities.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

This instructor-led, live training in US (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database for government.

By the end of this training, participants will be able to:

• Understand the key features and architectural changes in the Oracle database.
• Manage and monitor Oracle databases effectively.
• Optimize the performance of Oracle databases.

This instructor-led, live training in US (online or onsite) is aimed at intermediate-level database administrators who wish to manage and optimize complex, high-availability Oracle database environments for government.

By the end of this training, participants will be able to:

• Achieve a comprehensive understanding of Oracle RAC architecture and Grid Infrastructure, including installation, configuration, and management.
• Develop practical skills in managing Automatic Storage Management (ASM), covering disk group management, instance tuning, and backup/recovery procedures.
• Master advanced RAC performance tuning techniques, disaster recovery configurations, and best practices for ensuring high availability.
• Acquire robust troubleshooting and diagnostic skills to effectively resolve issues in RAC and Grid Infrastructure environments.
• Understand the processes involved in patching and upgrading Oracle RAC and Grid Infrastructure to minimize downtime and maintain system stability.