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