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
Hi, Nadhan, thanks for sharing the knowledge, this is really helpful to us as we provide Oracle EBS implementation this will be helpful for us.
ReplyDelete