Oracle Database 19c Administration and Backup Training Course

Course overview

Oracle Database 19c administrators are expected to keep production databases available, recoverable and measurable while handling user access, storage growth, backup failures and performance warnings without introducing avoidable risk. This five-day course equips technical professionals to administer Oracle Database 19c using repeatable operational procedures rather than ad hoc commands. It is designed for teams responsible for business-critical Oracle estates, where recovery objectives, audit requirements and service continuity must be demonstrated to managers and application owners.

Participants work through the core administration lifecycle: instance and database architecture, Oracle Net connectivity, tablespaces and datafiles, user and privilege management, undo and temporary space, and routine monitoring. The course then concentrates on Oracle Recovery Manager (RMAN): configuring the recovery area, creating full and incremental backup strategies, validating backup integrity, cataloguing and reporting backups, and recovering from lost datafiles, control files and archived redo logs. Participants also use Data Pump for logical export and import, and apply practical diagnostic methods using alert logs, dynamic performance views and Oracle Enterprise Manager.

Delivery combines instructor-led explanation with guided labs on Oracle Database 19c environments and realistic operational incidents. Each participant completes administration and recovery runbooks covering their configured database, backup policy, RMAN command sequences, validation checks and recovery decision points. This provides a tangible reference for applying the methods in production under local change-control procedures.

The course is particularly valuable for database administrators, infrastructure engineers and support specialists moving from basic SQL or operational support into accountable Oracle administration responsibilities.

Course objectives

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

• Configure Oracle Database 19c instance parameters, services and Oracle Net connectivity for controlled database operation
• Create and manage tablespaces, datafiles, undo tablespaces and temporary tablespaces using appropriate storage settings
• Administer database users, roles, system privileges and object privileges using least-privilege access controls
• Monitor database health through alert logs, dynamic performance views and Oracle Enterprise Manager metrics
• Design an RMAN backup strategy using full, incremental, archived redo log and control file backups
• Configure the Fast Recovery Area, RMAN retention policies, backup validation and recovery reporting
• Perform RMAN recovery procedures for lost datafiles, control files, spfiles and archived redo logs
• Produce an Oracle 19c administration and backup runbook with operational checks and recovery steps

Benefits of attending

Target competencies

Who should attend

• Oracle Database Administrators — who need structured methods for operating, protecting and recovering Oracle 19c databases
• Junior Database Administrators — who are moving from SQL support into day-to-day database administration duties
• Infrastructure Engineers — who support Oracle platforms and need to coordinate storage, backup and availability controls
• Application Support Engineers — who investigate Oracle-backed application incidents and need to distinguish database causes
• Technical Support Analysts — who require practical escalation evidence from logs, sessions and database health checks
• IT Operations Managers — who oversee database support teams and need staff able to implement auditable backup procedures

Requirements and prerequisites

Participants should have working knowledge of SQL, including SELECT statements, joins and basic DDL such as CREATE TABLE and ALTER TABLE. They should understand relational database concepts, operating-system file paths, processes and command-line navigation on Linux or Windows. Familiarity with an earlier Oracle Database release, SQL*Plus or Oracle SQL Developer is useful but not essential. This is not a course in SQL programming, Linux administration or application development. Participants do not need prior RMAN, Oracle Enterprise Manager, RAC, Data Guard or advanced performance-tuning experience; these are introduced where relevant to administration and backup work.

Training methodology

The instructor demonstrates each administration task in Oracle Database 19c, then participants execute the same procedure in guided lab environments using SQL*Plus, RMAN and Oracle Enterprise Manager. Exercises progress from building a managed database environment to diagnosing alerts, configuring recovery settings and restoring damaged database components. Short incident case studies require learners to select recovery actions from available backups and redo logs, explain their choices and document the result. The final workshop converts lab work into an administration and backup runbook tailored to a participant’s own operational context.

Course outline

Day 1: Oracle 19c architecture and operational setup

• Oracle Database 19c instance, database and memory architecture
• Oracle background processes and server process responsibilities
• Initialization parameter files and parameter management
• Database startup, shutdown and restricted-mode procedures
• Oracle Net Listener configuration and service registration
• SQL*Plus administrative connections and SYSDBA authentication
• Alert log, trace file and diagnostic destination navigation

Workshop: Configure an Oracle 19c instance and listener, establish administrative connections, and produce a startup and diagnostics checklist.

Day 2: Storage, users and routine database administration

• Tablespace architecture and locally managed tablespaces
• Datafile creation, resizing, autoextend and space monitoring
• Undo management and undo retention configuration
• Temporary tablespaces and temporary space troubleshooting
• User account creation, profiles and password controls
• Roles, system privileges and object privilege delegation
• Database resource monitoring with dynamic performance views

Workshop: Create a controlled application schema with storage quotas, roles and profiles, then resolve a simulated tablespace capacity alert.

Day 3: RMAN backup configuration and validation

• RMAN architecture, target database connections and recovery catalog concepts
• Database backup modes and archived redo log management
• Fast Recovery Area configuration and capacity planning
• RMAN full, incremental level 0 and incremental level 1 backups
• Backup sets, image copies, compression and control file autobackups
• Retention policies, obsolete backups and backup piece management
• RMAN LIST, REPORT, VALIDATE and CROSSCHECK commands

Workshop: Configure an RMAN backup policy, create scheduled-equivalent backup command files, and validate the resulting backup inventory.

Day 4: Recovery, restore and data movement

• Recovery scenarios and the role of archived redo logs
• RMAN restore and recover operations for lost datafiles
• Control file and server parameter file recovery procedures
• Incomplete recovery and point-in-time recovery decision criteria
• Block media recovery and corruption detection
• Data Pump export options, dump files and directory objects
• Data Pump import methods for schema and table recovery

Workshop: Respond to a simulated datafile loss incident by selecting an RMAN recovery path and producing a documented recovery record.

Day 5: Monitoring, maintenance and operational runbooks

• Oracle Enterprise Manager database monitoring and incident views
• Performance indicators for sessions, waits, locks and resource consumption
• Automatic Workload Repository reports and baseline interpretation
• Database patching concepts and pre-maintenance checks
• Backup failure investigation using RMAN logs and alert logs
• Administration job scheduling with DBMS_SCHEDULER concepts
• Operational runbook structure, recovery objectives and change evidence

Workshop: Analyse a database operations case, define monitoring and backup actions, and complete an Oracle 19c administration and recovery runbook.

Tools & standards covered

Oracle Database 19c, Oracle Recovery Manager (RMAN), Oracle Enterprise Manager Cloud Control, SQL*Plus

A typical training day

Live online deliveries follow the same structure in the East Africa Time zone, with shorter screen blocks and longer breaks.

What the fee includes

How you can take this course

Certification

Participants who complete the full five days receive the Skillset Development Certificate of Completion, stating the course title, course code, dates and delivery format — suitable for professional-development records and employer reimbursement.

Frequently asked questions