SAINORA

HomeCourses Oracle DBA

Oracle DBA

Dataguard

  • Introduction to SDLC
  • Dataguard Architecture
  • Protection Modes
  • Configuration Physical Standby
  • Configuration Logical Standby
  • Switchcover and Failover
  • Cascaded Standby Database
  • Oracle Database Advance Administration

Automatic Storage Management

  • ASM Architecture
  • Configuring ASM
  • Configuring Raw Device
  • Configuring ASM Disks
  • Start and Shutdown ASM
  • Maintaining Disk groups
  • Migrating from and to ASM
  • ASMCMD command Line
  • Workshop with scenarios
  • Assessment

Oracle Real Application Clusters(RAC)

  • RAC components
    • Oracle Clusterware
  • Background processes in RAC
  • Database files in RAC
    • Server parameter file
    • Data files
    • Control files
    • Online redo log files
    • Archived redo log files
    • Other files
  • Maintaining read consistency in RAC
  • Cache Coherency
  • Cache fusion
  • Global Resource Directory
  • Mastering of resources
  • Lock management
  • Multi-instance transaction behaviour
  • Recovery
    • Cache recovery
    • Transaction recovery
    • Online block recovery

Storage Management

  • Disk fundamentals
    • RAID 0
    • RAID 1
    • RAID 0 + 1
    • RAID 1 + 0
    • RAID 5
  • Storage options for RAC
    • RAW devices
    • Clustered file system
    • ASM
  • Configuring RAW Devices
  • Configuring OCFS cluster file system
  • Mounting devices on all nodes
  • Configuring Network file system

Installation and Configuration

  • Optimal Flexible Architecture
    • Installation
    • Preinstallation steps
  • Selecting the Clusterware
  • Operating system configuration
    • Creation of an oracle user account
  • Network configuration
  • NIC bonding
  • Configuring the kernel
  • Configuring the hangcheck timer on Linux systems
  • Configuring and synchronizing the system clock
  • Installing Oracle
    • Oracle Clusterware installation
    • Oracle Software Installation
    • database configuration
    • cluster components
    • OCR backup and restore
    • Setting paths and environment variables

Services and Distributed Workload Management

  • Service framework
    • Types of services
    • Service creation
    • Service tools
  • Fast Application Notification
    • Oracle Notification Services
    • FAN events

Failover and Load-Balancing

  • Failover
    • How does the failover mechanism work?
    • Database/instance recovery
    • Failover of VIP system service
    • Transparent application failover
    • Fast Connect Failover
  • Load-balancing
    • Applications not using connection pooling
    • Applications using connection pooling

Oracle Clusterware Administration

  • Node verification using olsnodes
  • Oracle Control Registry
    • Server control (srvctl) utility
    • Cluster services control (crsctl) utility
    • OCR administration utilities
  • Load-balancing
    • Applications not using connection pooling
    • Applications using connection pooling