Introduction to Database & Oracle DBA 

• What is Database? 
• Why do we need of Database? 
• List of major Databases and Database vendors 
• Tasks of Database Administrator (DBA) 
• Database related tools and utilities. 

Oracle Database Instance Architecture & Storage Structure

• What is Oracle Database 19c?

• What is Database Instance? 
• Oracle Database Instance Memory Architecture (SGA & PGA) 
• Subcomponents of Shared/System Global Area (SGA) 

• Oracle Database Process Architecture [PMON (CLMN), SMON, LREG, CKPT, LGWR, MMON…] 

Oracle Database Instance Architecture & Storage Structure(Contd..)

• Oracle Database Storage Structure 
• Oracle DB Logical Storage Structure [OS Block, Oracle Data block, Extents, Segment, Table-space] 
• Oracle DB Physical Storage Structure [Control file, Data files, Online Redo log files, Parameter files] 
• Oracle Database Multitenant Architecture 
• Oracle Database Container Database [CDB$ROOT] & Non Container Database 
• Oracle Database SEED Database [PDB$SEED] 
• Oracle Database Pluggable database [Application Container Database] 

Oracle Software Installation & Database Creation 

• Understand prerequisites for a successful Oracle RDBMS software installation. 
• Installation of Oracle 19c database software 
• Planning for Oracle Database Creation 
• Database Creation using DBCA (Database Configuration Assistance) GUI 
• Database Creation using script manually with CREATE DATABASE statement 
• Exploring the Database components Logical & Physically 

Oracle Database Start & Stop and Parameter 

• Oracle Database Startup modes [STARTUP, STARTUP NOMOUNT, STARTUP MOUNT, OPEN, FORCE] 
• Oracle Database Open Read Only & Restricted Modes 
• Oracle Database Shutdown modes [SHUTDOWN NORMAL, TRANSACTIONL, IMMEDIATE, ABORT]—- Parameters —- 
• Initialization Parameters 
• Static & Dynamic Parameters 
• System & Session Level Parameters 
• Parameter files (Initialization Parameter & Server Parameter files) 
• Changing the Parameter Value—-Data Dictionary—- 
• Understanding Data Dictionary 
• Static & Dynamic Performance Views [V$…,X$……, DBA_, ALL_, USER_] 
• Using Data Dictionary Views [ DICT, V$FIXED_TABLE]

User Management & Database Security 

• Types of Database Users on the basis of Authentication [Database & External (OS) User] 
• Database 12c Common (C##Username) User & Local User 
• Create the Database Common User & Local User 
• Alter the Database Common User &Local User 
• Types of Privileges [System Level & Object Level Privileges] & Roles 
• Grant and Revoke the Privileges from Database Users 
• What is profile? 
• Assign the Profile to Database User 
• Create & Alter the Profile 
• Killing the Session of the Connected User

Table-space Administration & Data file Administration

• Create, Alter & Drop the Permanent Table-space 
• Add & Resize the data files 
• Understand Segment space management 
• Understand the Extent Management 
• Create Big File Tablespace 
• Table-space Quotas 
• Configuring the Multi-block Table-space support 
• Tablespace related views [DBA_Tablespaces, DBA_Data_Files, V$Tablespace, V$Datafile] 

Undo Table-space Create Undo Table-space and add data file to undo Table-space 

• Change the Undo Tablespace on the Database level 
• Managing the Transaction & Undo Data 
• Configuring the Undo Table-space 

Temporary Table-space Create Temporary Table-space 

• Adding and Resize the temporary file 
• Temporary Tablespace Group 
• Temporary Table-space views [DBA_temp_files, V$tempfile] 

Managing the Control File Understanding Control Files 

• Control file related view (V$controlfile) 
• Multiplexing Control Files 
• Backing up Control Files 

Managing Online Redo log files Redo Log Files & Archiving 

• Online & Archived Redo Log Files 
• Managing Online Redo Log Files 
• Fast Recovery Area (FRA) 
• Configuring Database Archive mode 
• Views related Log [V$LOG, V$LOG_FILE, V$LOGSTDBY, V$LOG_HISTORY, V$RECOVERY_LOG, V$STANDBY_LOG] 

Oracle Net Service Architecture 

• Overview of Oracle Net Services & It’s component 
• How Oracle Net Service works? 
• The Oracle Net Listener 
• Types of Listener & Oracle Listener configuration [Dynamic and Static Listeners] 
• Oracle netca (Network Configuration Assistant) utility to Create Listener 
• Oracle netmgr (Network Manager) utility to Create & Configure the Listener 
• Oracle Dedicated Server Architecture 
• Oracle Shared Server Architecture 
• Oracle Listener Administration and TNS_ADMIN environment variable 

Oracle Database Link 

• Overview about Oracle Database Link 
• Type of Database Link [Private & Public Database link] 
• How to create Oracle Database Link 
• How to Drop the Oracle Database Link

Oracle Database Data Export/Import Utilities: 

• Data Pump Export (Export) expdp & exp 
• Data Pump Import (Import) impdp & imp 
• Oracle Data Pump Components DBMS_DATAPUMP & DBMS_METADATA Package 
• Export & Import Table, Schema, Tablespace, Database

Backup, Restore & Recovery

• Introduction Backup and Recovery 
• Introduction to RMAN (Recovery Manager) Architecture 
• Configuring the RMAN Environment 
• RMAN Backup Concepts like Backup Sets & Image Copy Backup 
• RMAN Control file & Parameter file backup 
• RMAN full database & Incremental Backup 
• RMAN Backup Retention Policy 
• List out the Archive log backup & Database Backups 
• RMAN related Views * Concept of Repository Catalog Database 
• Benefit & Use of Repository Database 

RMAN backup CDB & PDB Databases

Oracle Database Flashback & Restore Point 

• Overview of Flashback Database 
• Prerequisites for Flashback Database and Guaranteed Restore Points 
• Using Normal and Guaranteed Restore Points 
• Restore Points and Guaranteed Restore Points 
• About Logging for Flashback Database and Guaranteed Restore Points 
• Using Flashback Database, Table-space, Table

Oracle Database RMAN Duplicate Cloning 

• Cloning Concept & Consideration 
• Cloning Oracle Home 
• RMAN Duplicate Database Cloning
• Cloning Technologies

Oracle Database Disaster Setup (Standby Database/ Data Guard)

• Oracle Data Guard Overview
• Introduction Oracle Data Guard
• Oracle Data Guard Architecture 
• Types of Standby Databases & Data Guard Services 
• Difference between Physical, Logical & Snapshot Standby databases 
• Processes related to Primary & Standby Databases 
• Creating Physical Standby Database using SQL & RMAN Duplicate command 
• Open The Physical Standby database to Real Time Apply

RAC  And Grid architecture  

•  Grid Set Up 
•  Installation and configuration of Grid 
•  ASM configuration 
•  DISK management 
•  Single node cluster Srvctl and crsctl usages 
•  Node addition and deletion
•  Migration From standalone to grid and RAC 
•  Node eviction and split-brain syndrome 
•  Backups/recovery of OCR and VOT disk 
•  Stand by for cluster environment 
•  HA and DR scenarios in cluster environment

Oracle Database Performance Tuning – to handle real scenarios

• Oracle databases wait events 
• How to define size of Oracle database memory structures for optimal performance
• Explain Oracle temporary space internals and sizing. 
• How to trace database sessions using DBMS_MONITOR and DBMS_SESSION packages 
• How to format SQL trace files using the tkprof utility 
• Index Monitoring and internals of index maintenance by Oracle 
• Statistics data collection for Oracle database optimizer * What is Oracle automatic workload repository (AWR) and how to obtain AWR reports
• V$ dynamic views for performance monitoring and analysis

Oracle Database Patching 

• Introduction to Oracle versions and how to understand a version 
• Learn about Oracle Interim Patch Installer (OPATCH)
• What are Oracle interim patches? 
• How to apply SPU patches (Security Patch Updates). 
• How to apply a Patch Set Update (PSU) 
• How to upgrade from one patch-set to another patch-set within the same maintenance release