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

Ø