Oracle Database 19c Administration

Oracle Database Architecture
· Oracle Database Server Architecture
· Oracle Database Instance Configurations
· Connecting to the Database Instance
· Oracle Database Memory Structures
 
Creating DBCS Database Deployments
· Automated Database Provisioning
· Creating a Database Deployment
 
Accessing an Oracle Database
· Connecting to an Oracle Database Instance
· Oracle Database Tools
· SQL*Plus
· Oracle SQL Developer
· SQL Developer Command Line (SQLcl)
· Database Configuration Assistant (DBCA)
· Oracle Enterprise Manager Database Express
· Enterprise Manager Cloud Control 13c Features
 
Managing DBCS Database Deployments
· Managing the Compute Node
· Scaling a Database Deployment
· Patching DBCS
 
Managing Database Instances
· Working with Initialization Parameters
· Starting the Oracle Database Instance
· Shutting Down an Oracle Database Instance
· Opening and Closing PDBs
· Alert Log
· Trace Files
· DDL Log File
 
Oracle Net Services
· Oracle Net Services
· Oracle Net Listener
· The Default Listener
· Establishing Oracle Network Connections
· Connecting to an Oracle Database
 
User Security
· Database User Accounts
· Oracle-Supplied Administrator Accounts
· Creating Oracle Database Users in a Multitenant Environment -9
· Schema-Only Account
· Authenticating Users
· System Privileges for Administrators
· Object Privileges
· Granting Privileges in a Multitenant Environment
· Granting and Revoking System Privileges
· Granting and Revoking Object Privileges
 
Creating PDBs
· Creating a New PDB from PDB$SEED
· Cloning PDBs
· Unplugging and Plugging in PDBs
· Plugging an Unplugged Regular PDB into a CDB
 
Creating and Managing Tablespaces
· Creating Tablespaces
· Creating Permanent Tablespaces in a CDB
· Altering and Dropping Tablespaces
· Viewing Tablespace Information
· Tablespace Encryption by Default in DBCS
 
Managing Storage Space
· Space Management Features
· Block Space Management
· Row Chaining and Migration
· Types of Segments
· Allocating Extents
 
Managing Undo Data
· Undo Data

Moving Data
· Oracle Data Pump
· SQL Loader
 
Backup and Recovery Concepts
· Types of Failures
· Instance Recovery
· The Checkpoint (CKPT) Process
· Redo Log Files and the Log Writer (LGWR)
· Automatic Instance Recovery or Crash Recovery
· Using the MTTR Advisor
· Complete Recovery Process
· The Point-in-Time Recovery Process
· Flashback
 
Backup and Recovery Configuration
· Configuring for Recoverability
· Redo Log Files
 
Creating Database Backups
· RMAN Backup
· Backing Up Databases on DBCS
 
Performing Database Recovery
· Data Recovery Advisor
· Loss of a Control File
· Loss of a Redo Log File
· DBCS: Performing Recovery by Using the Console
· dbaascli Utility
 
Monitoring and Tuning Database Performance
· Automatic Workload Repository (AWR)
· Automatic Database Diagnostic Monitor (ADDM)
· Advisory Framework
 
Tuning SQL
· SQL Tuning Process
· Oracle Optimizer
· Optimizer Statistics
· SQL Plan