ORACLE PROGRAMMING AND DBA

ORACLE DATABASE ADMINISTRATION


Preparing Environment
  • Product and Editions
  • Release 5 values
  • Licensing
  • OLAP/OLTP
  • Tier Architecture
  • Operating System
  • Databases
  • Future of DBA
Linux for Oracle DBA
  • Preparing Environment
  • Linux Installation
  • Oracle database installation
  • Silent mode installation
  • Automatic Startup and Shutdown
  • Xming
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
  • System/Sysaux
  • Storage parameters
  • Space parameters
  • DBMS_STATS
  • Undo
  • Temp
  • Partition
  • Fragmentation
  • Flashback
  • Index
  • Roles and Profiles
  • Dbms Jobs and Scheduler
Introduction of Backup
  • Umb Backup
  • Umb Cloning
  • Umb Recover
  • System
  • Undo
  • Logfile
  • Datafile
Tns/ Listener
  • DB Link
  • Materialized View
Logical Backup
  • Export Parameter
  • Import Parameter
  • Exp Cloning
  • Expdp Parameter
  • Impdp parameter
  • Datapump Cloning
Rman Introduction
  • Configuration
  • Commands
  • Backup
  • Rman Cloning
  • Catalog Cloning
  • No catalog Cloning
  • Active Cloning
  • Rman recovery
  • PTTR
  • Incremental Backup & Recovery
Introduction of Tuning
  • Sql Tuning
  • TKprof
  • Stats Pack
  • ASH
  • ADDM
  • AWR
  • Wait events
Utilities
  • Nid
  • Cscan
  • Log miner
  • Orapwd
  • Dbv
  • Oerr
Patches And Upgradation
  • Opatch utilities
  • Version Patch
  • CPU/PSU Patching
  • Bundle Patching
  • Interim Patches
  • Upgrading database from 11g to 12c
Introduction of Dataguard
  • Architecture
  • Configuration of Physical standby
  • Physical to Logical Conversion
  • Switchover
  • Failover
  • Dgmgrl
  • Active Standby database
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

Next Course(Oracle - RAC)

RELATED VIDEOS

Example of Embedding YouTube Video inside Bootstrap Modal

Enrolled Students

8565

Education Awards

120

Certified Teachers

193

Library and Labs

150