Oracle Database Administration 19c

Learn to install Oracle 19c release 3 on CentOS using the Oracle Universal Installer, verify memory and swap prerequisites, set Oracle base and Oracle home, and create an enterprise database.

Learn Oracle architecture, including memory structures (SGA and PGA) and processes, and the storage layout (data files, control files, redo logs) with listeners and sessions.

Explore Oracle 19c new features, including automatic fixup script execution, remote pdb cloning with Dbca silent mode, and data pump enhancements for faster transports.

Discover how to create a schema only account in Oracle 19c, a passwordless, no-direct-connection user governed by roles and grants, usable via proxy connections or apps.

Demonstrate Oracle 21c multitenant architecture with CDB and PDBs, showing how to connect to roots and PDBs, view services, manage open modes, and basic troubleshooting.

Explore Oracle's multitenant architecture by creating and comparing container and pluggable databases (CDB and PDB), using 19c and 21c with templates, fast recovery area, listeners, and memory management.

Clone a pdb in Oracle 19c with dbca in silent mode, using a remote user and db link, while automating pdb startup with a trigger for all pdbs.

Explore Oracle 19c's new feature to duplicate a CDB using DBCA in silent mode, enabling on host or remote duplication with a unique database name and silent configuration.

Explore relocating a PDB to another CDB in Oracle 19c with DBCA in silent mode, a new feature that performs silent relocations using a remote database link.

Connect to the Oracle database instance over the network, start user sessions after authentication, and use essential tools such as sql plus and sql developer.

Learn to use oracle database flashback features, restore points, and flashback table to recover data, explore guaranteed flashback, timestamp-based restores, and recycle bin semantics.

Master Oracle database maintenance by configuring the listener, tnsnames.ora, service names, and environment variables, and connecting via sqlplus, sql developer, or OEM.

Identify how the service name and listener route requests, using port 1521 or 1539. Register the service name with the listener and connect to PDBs in multi-tenant environments.

Explore Oracle 19c hybrid partitioning that combines internal and external partitions in a single table, enabling fast access and efficient management of data across internal storage and external sources.

Learn how to export and import with data pump in Oracle 19c using transportable tablespaces, including read-only preparation and importing into PDBs within a CDB.

Explore Oracle flashback, including point in time recovery, flashback table, and query level rollback, while understanding row movement, archiving considerations, and when to restore dropped objects.

Enable and verify flashback mode, set flashback retention targets, and configure RMAN related backup options, including auto backup, control file auto backup, and recovery area retention policies.