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

  • Managing Backup ad Recovery
  •    User Managed Backup(UMB)

  •    UMB Cloning

  •    UMB Recover

  •    System

  •    Undo

  •    Logfile

  •    Datafile

  • Tns(Transparent Network Substrate)/ Listener
  •    DB Link

  •    Materialized View

  • Working on Constraints
  •    Managing constraints

  •    TYPES of Constraints

  •    ON DELETE Cascade option

  • 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

  • Oracle 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

  • Dictionary Views
  •    Introduction to Data Dictionary

  •    Describe the Data Dictionary Structure

  •    Using the Data Dictionary views

  •    Querying the Data Dictionary Views

  • Introduction of Dataguard
  •    Architecture

  •    Configuration of Physical standby

  •    Physical to Logical Conversion

  •    Switchover

  •    Failover

  •    Dgmgrl

  •    Active Standby database

  • Automatic Storage Management(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