Module 1: Prepertive Environment

• Product and Editions
• Release 5 values
• Licensing
• OLAP/OLTP
• Tier Architecture
• Operating System
• Databases
• Future of DBA

Module 2: Linux for Oracle DBA

• Preparing Environment
• Linux Installation
• Oracle database installation
• Silent mode installation
• Automatic Startup and Shutdown
• Xming

Module 3: Database Concepts

• Architecture,
• Query Flow
• SGA,
• PGA
• BG Process,
• Startup and Shutdown
• Manual db creation,
• Startup & Shutdown
• Dbca Creation,
• Controlfile
• Logfile,
• Archive logfile,
• Manage Tablespaces and Datafiles,
• Storage parameters,
• Space parameters,
• DBMS_STATS,
• Undo
• Temp
• Partition
• Fragmentation,
• Flashback
• Index
• Roles and Profiles
• Dbms Jobs and Scheduler

Module 4: Introduction of Backup

• Umb Backup
• Umb Cloning
• Umb Recover
• System
• Undo
• Logfile
• Datafile

Module 5: Tns/Listener

• DB Link
• Materialized View

Module 6: Logical Backup

• Export Parameter
• Import Parameter
• Exp Cloning
• Expdp Parameter
• Impdp parameter
• Datapump Cloning

Module 7: Rman Introduction

• Configuration
• Commands
• Backup
• Rman Cloning
• Catalog Cloning
• No catalog Cloning
• Active Cloning
• Rman recovery
• PTTR
• Incremental Backup & Recovery

Module 8: Introduction of Tuning

• Sql Tuning
• TKprof
• Stats Pack
• ASH
• ADDM
• AWR
• Wait events

Module 9: Utilities

• Nid
• Cscan
• Log miner
• Orapwd
• Dbv
• Oerr

Module 10: Patches And Upgradation

• Opatch utilities
• Version Patch
• CPU/PSU Patching
• Bundle Patching
• Interim Patches
• Upgrading database from 11g to 12c

Module 11: Introduction of Data Guard

• Architecture
• Configuration of Physical standby
• Physical to Logical Conversion
• Switchover
• Failover
• Dgmgrl
• Active Standby database

Module 12: Introduction of ASM

• Asm Architecture
• Bg process
• Asm with grid installation
• Adding and Deleting Disks
• Creating database files using asm
• Asm to Non-asm
• Non-asm to Asm
• Asm disk rebalancing operation
• Disk failure