Oracle 10g &11g DBA (Linux&Solaris)

Prerequisites

Unix/Linex, SQL (Free courses for oracle DBA)

Sql Overview

Basic Sql Statements like DML, DDL, TCL, DCL

Where Clause, Order by Clause, Operators,Sql Functions, Subqueries

Joins,Constraints,Views.

Linux Introduction

Linux Installation

Linux Architecture, File System

Creating Files, Directories,Changing Permissions, Ownerships, CP + MV

Commands

Wildcard Characters, Vi Editor commands, Redirections Symbols, Search

Commands.

Soft Link, Hard Link, Process killing, Cpu Utilization.

Oracle DBA overview

Oracle database Over View,Introduction to DBA,

DBA Responsibilities.

Oracle Architecture

Understanding Oracle Architectural components,

Instance,Database, Logical structures,User&Server Processes

New Features in Oracle 10g

Managing an Oracle Instance

Database admin Tools,Database Adminisration users, Authentication

Methods for DBAs, Understanding Data Dictonary Contents, Initialization

Parameter files,Understanding Option of Startup & Shutdown

Monitoring Alert Log files, Background trace files and User Trace files.

Oracle Installation &Database Creation

Installation of Oracle 10g on RedHat Enterprise Linux advanced Server.

Remote Installation of Oracle 10g

Oracle Database Creation usingDBCA (database Configuration Assistant)

Creating the Database Manually

Managing Tablespaces&Datafiles

Managing Tablespaces,Datafiles,Understanding Dictonary& Locally

Managed Tablespaces,Converting DMT to LMT &vice versa,

Temporary Tablespaces, Temporary Tablespaces groups,BigFile Tablespaces

Configuring OMF tablespaces creataion,Altering Tablespace status

Storage Structures

Using appropriate storage settings,Type of segments,

Automatic segment space management, Creating&Maintaining

Indexes, Rebuilding Indexes.

Managing Undo Data

Understanding undo segments

Retention policy, Switching Undo tablespaces, Flashback queries.

Managing Controlfiles &Redo Log Files

Managing Controlfiles, Multiplexing.Understanding Redo Log files,

Adding and Dropping Redo Log groups and members.

User Management

Managing Users,Tablespaces quota, Managing Resources with profiles,

Managing Privileges & Roles.

Networking Overview

Understanding Client/server,Oracle net Architecture & key components,

Oracle net services server side configuration, Configuring the Listener,

Understanding static & Dynamic service registrations, Understanding &

Configuring Bequeath & Redirect sessions, Listener Control utility,

Oracle net services client side configurations, Creating DB Links,

Dedicated & Shared servers, Configuring Shared servers & Dispatchers

Backup & Recovery Overview

Backup & Recovery issues,categories of failures, Backup & Recovery

Strategies

Instance & Media Recovery Structures

Undrestanding Background processes, Memoryu structure and Files related

To recovery, phases for instance recovery.

Database Utilities(Data Migration/Local Backups)

Using Import & Export, Using Data Pump, Using SQL Loader

Configuring Archive Log mode

Configuring the Database Archive Log mode, Changing the Archive mode,

Enabling Automatic Archiving, Manually Archiving Redo Log files.

Configuring Flash back Database

Understanding Flashback Database, Configuring Flashback Database,

Recovery using Flashback Database.

RMAN(Recovery Manager) Overview & Configuration

Understanding RMAN,Features &Components,Repository,

Configuring the environment,Maintenance commands.

Backup &Recovery Using RMAN

Backup using RMAN, Differential Incremental & Cumulative Incremental

Backups,Conpressed backups.

Complete & Incomplete Recovery using RMAN.

Recovery Catalog Creation & Maintance

Advantages of using Recovery Catalog, Creating & Managing the

Recovery Catalog.

User Managed Backup & Recovery

User managed Closed & Open Database (Cold & Hot) backups,

Complete& incomplete Recovery.

Database Cloning

Transportable Tablespaces

Configuring ASM (Raw devices & ASM libs)

Creating ASM Instance using DBCA

Creating ASM Instance Manually

Managing ASM Disk Groups

Migrating Database to ASM

Implementing Data guard (standby)

Understanding Physical and logical standby

Implementing standby

Switch over, fail over

Role changing

Database Upgradation & Patching

Understanding from oracle 9i to 10g

Understanding from oracle 10g to 11g

Upgrade using Patch and set

Using Opatch and applying patches

Managing Inventory

Performance Tuning

Gather Optimizer statistics

View performance metrics

Manage the automatic workload repository (AWR)

Using ADDM (Automatic Database Diagnostic Monitor)

Set warning and critical alert thresholds.

Using TKPROF, SQL trace

Implementing Oracle Database Security

Audit Database activity

Implement fine-Grained Auditing

Installation and configuration of 11g

Differences between 10g & 11g

Real time Scenarios

Job Oriented Training

OCP guidance

Oracle 10g RAC

Introduction to High Availability

Implementing ASM

Implementing Stand using Dataguard

Introduction to RAC

RAC architecture and components

Understanding OCFS and ASM

Pre Installation tasks

Installation and configuration of RAC

Installation of 10g RDBMS software

Creation of database

Startup and Shutdown of RAC

RAC Internals and Overview of Cache Fusion

Managing Cluster Nodes

Managing RAC DB

Adding new nodes

Deleting existing nodes

RAC Backup Recovery

TAF and load Balancing

Standby Databases with RAC

Upgrading DB under RAC