Learn Oracle 18c & Data Guard: On-Premises and Oracle Cloud

Download and set up the Oracle database 18c, Oracle VirtualBox, and Oracle Linux Enterprise 7.1 by following browser steps, license acceptance, and signing in to Oracle Software Delivery Cloud.

Learn to configure a virtual machine in VirtualBox and install Oracle Linux 7 with a GUI, allocate memory and 64 GB storage, and set static IP for Oracle 18c deployment.

Configure the operating system for Oracle 18c by disabling firewall, performing host configuration, and preparing groups and users for the Oracle AT&T installation with prerequisite packages installed via yum.

Copy and install Oracle 18c, install and compile components, create the listener, then use scripts to create a single instance enterprise edition database.

Configure the listener with default settings through a step-by-step network configuration process; finish the first listener setup and prepare for the next lecture.

Log in as Oracle user and run dbca to generate scripts that create a database with advanced configuration, choosing non pluggable or pluggable options and defining global database name.

Connect to a container database, and switch to a pluggable database, verify services, and navigate between CDB and PDB using command line and DNS in Oracle 18c.

Learn to configure data guard on Oracle Cloud Service using Oracle 18c on premises, including prerequisites, software only installation, listener setup, primary and standby databases, and broker coordinated switchover.

Create a free Oracle Cloud account by registering for the trial, verify your phone, and add a payment method to receive three hundred dollars in cloud credit for thirty days.

Generate a public and private key pair on Windows 10 using the PuTTY Key Generator, save the private key as a .ppk, and copy the public key.

Create a cloud service and provision an Oracle database instance by configuring name, region, database type, and instance size; receive email notifications and manage via enterprise manager.

Learn to log in to an Oracle 18c database instance from Windows via SSH with a private key, using the public IP and hostname, and access PDB two.

Learn to navigate Oracle Cloud infrastructure, log in to the OCI console, and create an identity compartment, laying the groundwork for a virtual cloud network and database VM.

Create a virtual cloud network in Oracle Cloud Infrastructure, configure subnets, internet gateway, and dynamic routing gateway, and review the service gateway and routing tables.

Create a database VM on Oracle Cloud by configuring a virtual network and public and private keys, then launch the VM with a database admin and hostname.

Configure Data Guard on Oracle Cloud using Oracle 18c by creating a single instance with standby, setting name, password, storage, and public access.

Learn to perform a database switchover between primary and standby in Oracle 18c, verify configuration and logs, switch back, and ensure continuity without data loss using Data Guard.

Learn how to perform failover to a standby database, activate it as the primary, reinstate the database with flashback recovery, and handle manual recreation if flashback is unavailable.

Demonstrate converting a physical standby database to a snapshot standby, then switching it back to a physical standby with step-by-step commands and a practical demo.