ORACLE DATABASE 11gR2 & 12C CONTENT
Pre-Requisite: UNIX, SQL
Basics
Introduction
to Oracle Database
§ Introduction of Database
§ About the Database Server
§ Process & Storage
Architecture
§ Overview
§ Exploring the Oracle Database
Architecture
§ Instance & Storage
§ Logical and Physical Storage
structures
§ Parameter Files
Installation
§ Installing Oracle Software
§ Oracle Universal Installer OUI
§ Creation of Oracle Database and it’s
components
§ Bash Profiles
§ Access the Database
Managing the Database
§ Planning the Database
§ Password Management
§ Managing the Oracle Database Instance
§ Using DBCA to delete a Database
Startup & Shutdown Stages
§ Access Dynamic Performance view
§ Describe the stages of Database
Startup
§ Describe the Database Shutdown
Options
§ Start and Stop Database Components
§ View the alert log and Trace
§ Pfile & Spfile Creation
§ Introduction to the Parameters
§ Working with Spfile
§ Status Views
Control File Management
§ File Structure
§ Backup of Control file
§ Recreating Control file
§ Control file Multiplexing
§ Control File Views
Redo Log File Management
§ Change Vectors
§ File Structure
§ Adding/Deleting a logfile
§ Redolog Groups & Members
§ Log Switch
§ Redo Log Views
Data File Management
§ File Structure
§ Adding & Dropping Datafiles
§ Resize
§ Datafiles Shrinking
§ Data File Views
Password File Management
§ File Structure
§ Creating and Administering PWD
File
§ Copy PWD file from Source to
Target
Networking
§ Introduction to Networking
§ Location of Networking Files
§ Parameters
§ User Enterprise Manager to
create and configure the Listener
§ Start and stop Listener
§ Use tnsping to test Oracle Net Connectivity
Storage Structure
§ Block
§ Managing Database Storage
Structures
§ How Table Data is Stored
§ Extent Management
§ Segment Management
Tablespace Management
§ Overview of Tablespace Management
§ Space Management in Tablespace
§ Tablespaces in the Pre-Configured
Database
§ Actions with Tablespaces
§ Add Space to the Tablespace
§ Temporary Tablespace
§ Undo Tablespace
§ Managing Undo Data
§ Transactions and Undo Data
§ Undo Retentions
§ Oracle Managed Files OMF
§ Auto Extend Management
§ Tablespace Views
Archive Log File Management
§ Overview
§ Archive log and No Archive log
Modes
§ Archive log Destinations
User Management
§ Administering User Security
§ Database User Accounts
§ Roles
§ Implementing User Profiles
§ Reset User Passwords
§ Space Allocation to The User
§ Views
Backup & Recoveries
§ Introduction of Backups
§ Types of Backups
§ Backing up the Control files to
Trace
§ Archive log files
§ Recovery Manager RMAN
§ RMAN channels & Configurations
§ Backup scripts
§ Configuring Backup Settings
§ Performing Database Recovery
Moving Data
§ Describe ways to Move Data
§ Create and use Directory Objects
§ Use SQL * Loader to Move Data
§ Export and Import
§ Data pump
Flashback Technology
§ Using Flashback Technology
§ Flashback Drop and the Recycle
Bin
§ Flashback on/off
Automatic Storage Management
§ Asm Storage Components
§ Manage the ASM Instance
§ Startup and Shutdown ASM
instances
§ ASMCMD Utilities
§ Administer ASM Disk Groups
Patching
§ Introduction to Patching
§ Types of Patches
§ OPatch Utility
§ Applying CPU & PSU
Cloning or Refresh the Database
§ Purpose and Methods of Cloning a
Database
§ Pre-Clone Steps
§ Snap Clone
§ Using RMAN to Create a Duplicate
Database
§ Cloning a Database from Backup
§ Cloning from DR and PROD
§ Post Clone Steps
Data Guard or DR
§ Introduction of DR
§ Types of DR
§ Managing DR Databases
§ Protection Modes
§ MRP and RFS Process
§ Troubleshooting DR Lag Issues
Database Upgrade
§ Overview of Upgrade
§ Upgrade Project plan and
workbook
§ Pre-Upgrade tasks
§ Upgrade Database
§ Post Upgrade steps
Database Version 12c or 19c Architecture
§ Overview
§ Exploring the Pluggable Database
§ Instance & Storage
§ Logical and Physical Storage
structures
§ CDB and PDB Datafiles
§ Seeded PDB
Startup and Shutdown Methods on
Pluggable Database
§ Startup & Shutdown CDB
§ Managing Pluggable Database
§ Rename PDB
§ Managing Data on PDB
Cloning on 19c Pluggable
Databases
§ Overview of Pluggable Database
clone
§ Cloning through DB link
§ CDB Snap Clone
§ RMAN Cloning Method
Working With Support
§ Introduction
§ Log Service Request SR
§ Work With Oracle Support
§ Update and Connect with Support
Team