ORACLE Core DBA 19c
1. Introduction
What is DBA?
Why a Company needs a DBA?
Roles & Responsibilities of DBA
Identify the oracle product
Oracle Database Architecture
Physical and Logical Phase of Database
2. Installing oracle database 19c software
System requirements.
Redhat Linux Installation (Cent OS)
Install software with the Oracle Universal Installer on Linux Platform
Identify System Requirements
Optimal Flexible Architecture (OFA)
Discuss Oracle Base
Discuss Oracle Home
Configure Ms Windows Installation
Prerequisite Checks and Fixup Utility
3. Exploring The Oracle Database Architecture: General
More About Database Instances
What is Instance and SGA
General Database Architecture
Instance Background Processes
Discuss about New Feature Parameters
About PGA and Server Process
4. Exploring The Oracle Database Physical Architecture: (c,r,d)
Discuss about Control files
How to manage the Control files
Multiplexing the Control files
Brief about online redo log files.
More About Datafiles concepts
Brief About Paramter files
Discuss about Password files.
How to create spfile and pfile
What is spfile?
Difference between spfile and pfile
5. Create an oracle database
Database Configuration Assistant(DBCA)
Create A New Database
Configure An Existing Database
Drop A Database
Manually Create A Database
More About The Database Files
6. Manually Starting and Stopping Database Services
Starting and Stopping Database Control
Different Startup Modes
Different Shutdown Modes
Starting and Stopping The Listener
Sysdba
7. Manage Database Storage Structures: Tablespaces(small file
tablespace – 8PB)
What are segments?
What are extents?
What is Blocks?
Estimation of Extents
Dictionary Managed Table space
Locally Managed Table space
About Tablespaces
Tablespace Management
Auto extend Options
Drop Tablespace
Alter Tablespace
8. Manage Database Storage Structures: Advanced Tablespaces
(8EB) Bigfile Tablespaces
More About Temporary Tablespaces
About Temporary Tablespace Groups
Temporary Groups
More About Permanent Tablespaces
About Database_Properties
More About Bigfile Tablespaces
More About The Sysaux Tablespace
9. Manage Database Storage Structures: OMF
Managing Data Files
Managing Temp Files
Enable Oracle-Managed Files (OMF)
Renaming a data file
Temporary Groups
10. Managing Undo Data
About Undo Space Management
Configure Undo Management
Undo_Management
Undo_Tablespace
Undo_Retention
Guarantee Undo Retention
Monitor Undo Space
11. Security: Administering User Security
Create and manage database user accounts
Create and manage roles
Grant and revoke privileges
Control resource usage by using Profiles
Enhanced Default Security Settings
Create and Manage Database Accounts
Grant and Revoke Database Privileges
Resource Limits Via Profiles
Alter Profile
Drop Profile
Password Management Via Profiles
With Admin Option
With Admin Option and System Privileges
With Grant Option and Object Privileges
Alter User...Default Role
Enhanced Default Security Settings
Sec_Case_Sensitive_Logon Setting
Database Auditing
12. Oracle Net Services
Understand Oracle Net concepts
Use Oracle Net Manager to create and configure listeners
Use the listener control utility to control the Oracle Net Listener
Start and stop Listener concepts
Listener.ora
Tnsnames.ora
Use TNSPING to test Oracle Net connectivity
13. Create indexes and views Logical Backup & Restore
Introduction Data pump (expdp, impdp) Utilities
Exporting/Importing Tables
Exporting/Importing Schemas
Exporting/Importing Table space
Exporting/Importing Database
Discuss New features concept 12c
14.. Oracle Backup & Recovery (System Managed: RMAN)
Introduction
RMAN Architecture & Rman commands
Configuration
Setting up Catalog
Online/Offline Backup using RMAN
Backups Options
Incremental Backups,
Complete Recovery
Incomplete Recovery
Disaster Recovery
RMAN 12c new features
15. Cloning & Refresh
Database cloning Using RMAN
Database refresh Using Manual
DB refresh Using Expdp and impdp
Migration/Upgrades Using Expdp and Impdp
16. Flashback Database Concept
Introduction
Configuration
Flashback Query/Table/Drop/Database
Flashback Version Query
Creating Restore Points
Flashback Archive(11g)
17. Patching Activity
Database Patch Management Introduction
Applying Interim and Patch set Patches
Patch History & Documentation
18. Oracle Performance Tuning
Why Tuning required?
Types of Tuning
Proactive Vs Reactive Tuning
Database Tuning
Gather stats
Application Tuning
SQL Tuning
Memory Tuning
Network Tuning
Tuning Memory, Disk I/O
AWR/ASH/ASMM/ADDM
Resource Intensive SQL
Managing the DB Statistics ( for CBO)
Managing the AWR Snapshots
Generating/ Interpreting the AWR Report
Tuning through effective DB Configurations
Health Management/Periodical Checkup
19. Oracle 12c/19c CDB & PDB Architecture and Management (Multi-tenant
architecture) – RDBMS – database
20 Oracle database 19c new features.
21. Oracle database upgrade 12c/19c
