Introduction to ERP

• Oracle  DBA  11g R2

Oracle DBA overview

• Oracle database Overview,
• Introduction to DBA,
• DBA Responsibilities.

Oracle Architecture

• Understanding Oracle Architectural components
• User & Server Processes.
• Instance
• Database
• Logical Structures

Managing an Oracle Instance

• Database Admin Tools
• Database Administration users
• Authentication Methods for DBAs
• Os authentication, password file authentication
• Understanding Data Dictionary Contents
• Initialization Parameter files
• Pfile and spfile and working with parameters
• Understanding Options of Startup & Shutdown
• Monitoring Alert Log files
• Background trace files and User Trace files.

Oracle Installation & Database Creation

• Installation of 11g r2 on linux
• Silent installations using response files
• Deinstalling  Oracle
• Oracle Database Creation using DBCA
• Creating the Database Manually
• Deleting Database
• Changing DBID, changing Database Name

Managing Tablespaces & Datafiles

• Managing Tablespaces, Datafiles,
• Understanding Dictionary & Locally
• Managed Tablespaces,Temporary Tablespaces,
• Temporary Tablespace groups,
• Big File Tablespaces,
• Configuring OMF for tablespace creation,
• Altering Tablespace status.

Managing Undo Data

• Understanding undo segments, Automatic undo management,
• Retention policy, Switching Undo tablespaces, Flashback queries.

Managing Controlfiles & Redo Log Files

• Managing Controlfiles, Multiplexing & Recreating Control Files.
• Understanding Redo Log files,
• Adding and Dropping Redo Log groups and members.

User Management

• Managing Users
• Tablespace 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,
• Listener control utility,
• Oracle client software installations
• Oracle net services client side configurations
• Configuring Shared servers & Dispatchers

Backup & Recovery Overview

• Backup & Recovery issues
• categories of failures
• Backup & Recovery strategies

Database Utilities (Data Migration or Logical Backups)

• Using  Export & Import
• Using parfile
• Compressing the dumpfiles
• Using Data Pump
• Stoping and resuming datapump jobs

Transportable Tablespaces

• Transporting Tablespaces

Instance & Media Recovery Structures

• Understanding Background processes
• Memory structures and Files related   to recovery
• Phases for instance recovery.

Configuring Archive Log mode

• Configuring the Database Archive Log mode
• Changing the Archive mode,
• Enabling Automatic Archiving
• Manually Archiving Redo Log files.

Configuring Flashback Database 

• Understanding Flashback Database
• Configuring Flashback Database,
• Recovery using Flashback Database.

RMAN(Recovery Manager) Overview & Configuration

• Understanding RMAN
• Configuring the environment
• Maintenance commands.

Recovery Catalog Creation & Maintance

• Advantages of using Recovery Catalog
• Creating & Managing the Recovery Catalog.
• Recovery catalog upgrade
• Virtual private catalog

Backup & Recovery Using RMAN

• Backups using RMAN
• Differential Incremental & Cumulative Incremental backups
• Compressed backups.
• Encrypted backups
• Complete & Incomplete Recovery using RMAN.
• Recovery Scenarios

User Managed Backup & Recovery

• User managed Closed & Open Database (Cold & Hot) backups,
• Complete & Incomplete Recovery.
• Recovery Scenarios

Cross platform DB Migration (linux to solaris)
Database Cloning

• Cloning Oracle Home
• Cloning using DBCA
• Cloning Using Cold Backup
• Cloning using hot backup
• Cloning Using Rman
• Active Database cloning in 11g

Configuring ASM

• ASM overview
• Creating ASM Instance
• ASMCMD, ASM views
• Managing ASM Disk Groups
• Migrating Database to ASM using RMAN

Implementing Dataguard (Stnadby)

• Introduction to Data Guard
• Physical and logical standby
• Standby parameters
• Implementing standby
• Standby Database Administration
• switch over, fail over
• snapshot standby

Database Upgradation & Patching

• Using Opatch and applying patches
• Upgrading from oracle 10g to 11g

Performance Tuning

• Performance tuning overview
• Gather Optimizer statistics
• View performance metrics
• Manage the automatic workload repository (AWR)
• Using ADDM (Automatic Database Diagnostic Monitor)
• Using TKPROF, SQL trace,Explain Plan
• Row Migration and row chaining

Configuring Enterprise Manager

• Enterprise Manager Configurations

• Creating DB Links
• Materialized views
• Managing Schema Objects
• 11g New Features

• Faculty : (18+ yrs exp)

• Duration : 40 HOURS