Oracle
DBA 11g Course Contents
1. Architecture
Ø Identify the oracle product
Ø Describe the basic concept of a relational
database
Ø Defining an Oracle
Server, Database, Instance
Ø Understanding
Physical Structure, Memory Structure, Process Structure,
Ø Logical Structure, Execution
of SQL Statements
2. Creating a New Oracle Database
Ø Planning & Designing the database
Ø Managing & organizing the database
Ø Planning Database file Locations
Ø Create Database using command line & DBCA
Ø Changing Initialization Parameters file SGA size, Processes
Ø TS Naming Conventions,
Block Sizes
Ø No. of users the DB
has to support, etc, dropping a Database.
Understanding TS
3.
Managing an Oracle Database
Ø Creating and Managing
Initialization files – PFILE and SPFILE,
Ø Adv. of SPFILE over
PFILE
Ø Managing Database Instance
Ø Identifying the
various states/options of Instance Startup/Shutdown,
Ø DB Mount/Open stages
Ø Start and stop the agent
Ø Start and stop the enterprise manager database console
Ø Start and stop the listener
Ø Monitoring Alert and
Trace Files in udump, bdump and cdump
Ø Configuring System
Global Area (SGA) – DB Buffer Cache, Log Buffer and Shared Pool
Ø Understanding
Background Processes – Mandatory/Optional and the jobs performed by
them using the Data Dictionary to retrieve
information about the database – V$, DBA_ views
4. Managing Tablespaces and Datafiles.
Ø
Creating
and Altering Tablespaces, adding, resizing, renaming and relocating a Datafile
Ø
Renaming
Tablespace, drop a tablespace
Ø
Tablespace
– offline, online, readonly, readwrite, Temporary tablespace groups
Ø
Multiblock
size at tablespace level
Ø
Creating
and Managing a Tablespace when using OMF and the advantages of OMF
Ø
Extent
management- Dictionary Managed and Locally Managed Tablespaces
Ø
(AUTOALLOCATE,
UNIFORM) and advantages of locally managed over dictionary
Ø
managed
tablespaces
Ø
Big
File Tablespace, Temporary Tablespace Group.
5. Storage Management
Ø Creating, Maintaining
tables using appropriate storage settings – initial, minextents,
pctfree, etc
Ø Obtaining table
information like avg. row length, chained rows, etc after analyzing the
tables
Ø Managing, Listing
diff. types of Indexes and their uses
Ø Creating B-Tree and
Bitmap Indexes, Maintaining Indexes
Ø Identifying unused
Indexes, Obtaining Index Information
6.
User Management
Ø Database user accounts creating a user
Ø Profiles and users
Ø Authenticating Users
Ø Default and Temporary tablespaces
Ø Privileges
Ø System Privileges
Ø Object Privileges
Ø Assigning Quota to users
Ø Assigning Roles to users
7. Managing Undo Segments
Ø Understanding Oracle Undo
Segments, Retention Policy
Ø Retention
Gurantee/Nogurantee, Switching Undo Tablespaces
8.
Maintaining the Control File, Redo Log File and Archive Log Files
Ø Importance, Role,
Sizing, Contents
Ø Multiplexing and
Backing up of the Control File
Ø Purpose of and how
online redo log files work with their associated Background
Processes
Ø Controlling log
switches and checkpoints
Ø Multiplexing and
Archiving online redo log files
9. Oracle Net Services.
Ø Oracle Net
Architecture – Explaining the key components, Role in Client/Server Connections
Ø Oracle Net Services
Server-side Configuration, Oracle Net Services Client-Side configuration
Ø Use the listener control utility to control the
Oracle Net Listener
Ø Use TNSPING to test Oracle Net connectivity
Ø Configuring and
Maintaining Distributed DBs by creating DB Links
Ø Materialized Views
Ø Usage and
Configuration of Oracle Shared Server, Components of the Oracle Shared Server
Ø Configuring Shared
Servers and Dispatchers
Ø Understand Oracle Net concepts
Ø Use Oracle Net Manager to create and configure
listeners
10. Logical
Backups
Ø Main Tasks of Exports
and Imports
Ø Incremental,
Cumulative and Complete Export and Import
11.
Oracle Data Pump
Ø Introduction,
Benefits of Data Pump Export and Import
Ø Data Pump Export and
Import modes
Ø Managing, Transport
of Tablespace across different platforms
12. Oracle Backup & Recovery (User Managed
& RMAN).
Ø Describing the basics of DB Backup, Restore
and Recovery
Ø Listing the types of
Failures that may occur in an Oracle Environment
Ø Defining Backup and
Recovery Strategies
Ø Instance and Media
Recovery Structures – Describing the Oracle Processes
Ø Memory Structures and
Files related to Recovery
Ø Identifying the
importance of Checkpoints, Redo Log Files and Archived Log Files
Ø Describing the ways
to tune Instance Recovery
Ø User Managed Backups
and Recoveries – Backup and Recovery Operations, Closed and
Ø Open DB Backups (Hot
and Cold), Complete Recovery
Ø Identifying the
situations which require Incomplete Recovery
Ø Creating Clone DBs
Ø Oracle Recovery
Manager (RMAN) – Features and Components, Repository, Channel
Ø Allocation,
Configuring RMAN Environment, Backup Commands and Scripts for Backup
Ø Sets, Image copies
Ø Complete and
Incomplete Recovery and Full/Incremental Compressed backups
Ø Incremental backups
with block change tracking.
Ø Recovery from loss of
a controlfile
Ø Recovery from loss of
a Redologfile
Ø Recovery from loss of
system data files in Archivelog mode.
Ø TSPITR using RMAN
Ø Recovery of Corrupted DB-Blocks
Ø Cloning using RMAN
13. Availability
Ø Dataguard - Maximum Protection/Performance/Availability
modes,
Ø Performing Fail Over and Switch Over
Ø Logminer – Read and
Analyze the contents of redo log files, obtain info about DML
Ø
activities on standard tables,
14. Flashback
Ø