• What is DBA
  • Why a Company needs a DBA?
  • Roles & Responsibilities of DBA
  • Identify the oracle product
  • Oracle Architecture
  • Physical and Logical Phase of Database

  • System requirements.
  • Redhat Linux Installation
  • Install software with the Oracle Universal Installer on Linux Platform
  • Identify System Requirements
  • Optimal Flexible Architecture (OFA)
  • Discuss Oracle Base
  • Discuss Oracle Home
  • Configure Ms Windows Installation
  • Prerequisite Checks and Fixup Utility

  • More About Database Instances
  • What is Instance and SGA
  • General Database Architecture
  • General Database Architecture
  • Instance Background Processes
  • Discuss about New Feature Parameters
  • About PGA and Server Process

  • Discuss about Control files
  • How to manage the Control files
  • Multiplexing the Control files
  • Multiplexing the online redo log files
  • Brief about online redo log files.
  • More About Datafiles concepts
  • Brief About Parameter files
  • Discuss about Password files.
  • How to create spfile and pfile
  • What is spfile
  • Difference between spfile and pfile

  • Database Configuration Assistant(DBCA)
  • Create A New Database
  • Configure An Existing Database
  • Drop A Database
  • Manually Create A Database
  • More About The Database Files

  • Starting and Stopping Database Control
  • Different Startup Modes
  • Different Shutdown Modes
  • Starting and Stopping The Listener
  • Sysdba

  • What are segments
  • What are extents
  • What is Blocks
  • Estimation of Extents
  • Dictionary Managed Table space
  • Locally Managed Table space
  • About Tablespaces
  • Tablespace Management
  • Autoextend Options
  • Drop Tablespace
  • Alter Tablespace
  • Tablespace Encryption

  • More About Temporary Tablespaces
  • Using V$Sort_Segment
  • About Temporary Tablespace Groups
  • Temporary Groups
  • More About Permanent Tablespaces
  • About Database_Properties
  • More About Bigfile Tablespaces
  • More About The Sysaux Tablespace

  • Managing Data Files
  • Managing Temp Files
  • Enable Oracle-Managed Files (OMF)
  • Renaming a data file
  • Temporary Groups

  • About Undo Space Management
  • Configure Undo Management
  • Undo_Management
  • Undo_Tablespace
  • Undo_Retention
  • Guarantee Undo Retention
  • Monitor Undo Space
  • Use The Undo Advisor

  • Create and manage database user accounts
  • Create and manage roles
  • Grant and revoke privileges
  • Control resource usage by using Profiles
  • Auditing Of Database Activity
  • Audit_Trail Parameter
  • Enhanced Default Security Settings
  • Create and Manage Database Accounts
  • Grant and Revoke Database Privileges
  • Resource Limits Via Profiles
  • Alter Profile
  • Drop Profile
  • Password Management Via Profiles
  • About Role-Based Security
  • With Admin Option
  • With Admin Option and System Privileges
  • With Grant Option and Object Privileges
  • Alter User...Default Role
  • Set Role
  • Enhanced Default Security Settings
  • Sec_Case_Sensitive_Logon Setting

  • Understand Oracle Net concepts
  • Use Oracle Net Manager to create and configure listeners
  • Use the listener control utility to control the Oracle Net Listener
  • Start and stop Listener concepts
  • Listener.ora
  • Tnsnames.ora
  • Concept about Database Links
  • Use the Oracle Net Manager to configure client and middle-tier connection
  • Use TNSPING to test Oracle Net connectivity

  • 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
  • Discuss New features concept 11g

  • Introduction
  • Design, Testing, Implementation Strategies
  • Offline(cold)/Online(hot) backups
  • Performing Complete Recovery
  • Performing Incomplete Recovery

  • Introduction
  • RMAN Architecture & Rman commands
  • Configuration
  • Setting up Catalog
  • Online/Offline Backup using RMAN
  • Backups Options
  • Incremental Backups
  • Scripts
  • Complete Recovery
  • Incomplete Recovery
  • Table Space Point in Time Recovery (TSPITR)
  • Disaster Recovery
  • Recovery of Corrupted DB-Blocks
  • RMAN 11g new features

  • Database Refresh Using RMAN
  • Database refresh Using Manual
  • DB refresh Using Expdp and Empdp
  • Migration Using Expdp and Impdp
  • Migration Using Rman

  • Introduction
  • Configuration
  • Flashback Query/Table/Drop/Database
  • Flashback Version Query
  • Creating Restore Points
  • Flashback Archive(11g)

  • Database Patch Management Introduction
  • Applying Interim and Patch set Patches
  • Patch History & Documentation

  • Introduction
  • Architecture
  • Configuring Standby database
  • Types of Standby databases
  • Performing Switch Over and Fail Over
  • Monitoring & Troubleshooting
  • 11g New features in Data Guard
  • Types of Protection modes
  • Active standby/snapshot standby(11g)

  • Basic Automatic Storage Management Concepts
  • Disk Groups
  • Automatic Storage Management Files
  • Automatic Storage Management Templates
  • Automatic Storage Management Disks
  • Failure Groups
  • Automatic Storage Management Instances
  • Benefits of Using Automatic Storage Management

  • Why Tuning required
  • Types of Tuning
  • Proactive Vs Reactive Tuning
  • Tuning through effective DB Configurations
  • Health Management/Periodical Checkup
  • DB Defragmentation
  • Database Tuning
  • Application Tuning
  • SQL Tuning
  • Memory Tuning
  • Network Tuning
  • Partitioning and Indexes
  • Tuning Memory, Disk I/O
  • AWR/ASH/ASMM/ADDM
  • Resource Intensive SQL
  • Managing the DB Statistics ( for CBO)
  • Managing the AWR Snapshots
  • Generating/ Interpreting the AWR Report

  • Introduction
  • Architecture
  • Installation & Configuration
  • Managing the multiple database nodes using OEM grid control

  • Oracle installation process
  • Patching Activity
  • Upgradation Process
  • Migration Process
  • Rman Refresh & cloning Process
  • Resume Preparation
  • Dataguard scenario
  • Performance Tunning Troubleshoot
  • Project related scenario.
  • Real time scenario.