ORACLE 11g DBA:

Introduction.

Different types of oracle products and features.

New features in oracle 11g

Differences among oracle9i, oracle 10g and oracle 11g features along with its importance.

Installing oracle database 10g software.

System requirements.

Redhat Linux 5.0 Installation (with and without Vmware workstation)

Installation of multiple oracle servers and multiple oracle databases on Vmware workstation (features and advantages for RAC implementation with Vmware configuration)

Install software with the Oracle Universal Installer on Linux Platform


Creation of an oracle database. : Controlling the database:

• Oracle Database 11g Architecture

• Oracle instance architecture

• Oracle Read Consistency and Concurrency

• Start and stop the enterprise manager database console

• Start and stop the listener

• Startup and shutdown the database


Database Creation. : Storage Structures and architecture of Oracle 11g DBA:

• Manual

• Database Configuration Assistant(DBCA)

• Logical structure Vs Physical structure

• Defining the tablespaces and data files

• Create tablespaces

• Manage tablespaces

• Obtain tablespace information

• Managing Undo Data


File Management.: User Management. :

File Management

Redo Log File Management

Parameter File Management

Obtain tablespace information

• What Is Oracle Data Guard?

• Types of Standby Databases

• Data Guard Broker Framework

• Types of Services

• Benefits of Implementing Oracle Data Guard


Oracle Net Services. Managing schema objects.

• Understand Oracle Net concepts

• Use Oracle Net Manager to create and configure listeners

• Use the listener control utility to control the Oracle Net Listener

• Testing Oracle Net connectivity

• Shared Server: Connection pooling

• Create and modify tables

• Define constraints

• View the attributes of a table

• View the contents of a table

• Create indexes and views


Oracle Backup & Recovery (User Managed). Oracle Backup & Recovery (System Managed: RMAN).

• Introduction

• Design, Testing, Implementation Strategies

• Offline(cold)/Online(hot) backups

• Performing Complete Recovery

• Performing Incomplete Recovery

• Introduction

• RMAN Architecture

• Configuration

• Setting up Catalog

• Online/Offline Backup using RMAN

• Backups Options

• Incremental Backups

• Complete Recovery

• Incomplete Recovery

• Table Space Point in Time Recovery (TSPITR)

• Disaster Recovery


Cloning. Logical Backup & Transporting data between databases.

• RMAN

• Manual

• Introduction Data pump (expdp, impdp)  Utilities

• Exporting/Importing Tables

• Exporting/Importing Schemas

• Exporting/Importing Table space

• Exporting/Importing Database

• Transportable Table space within & across the database and platforms


High Availability (HA). Oracle Enterprise Manager and Performance tuning

• Database Patch Management Introduction

• Applying Interim and Patch set Patches

• Patch History & Documentation

• New features and its analysis of statistics on performance Tuning


Proactive Maintenance Flashback.

• Contents

• Optimizer statistics

• Automatic Workload Repository

• Introduction

• Configuration

• Flashback Query/Table/Drop/Database

• Flashback Version Query

• Creating Restore Points


Automatic Storage Management.

• New features and implementation