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