Scribd
Upload
25 views3 pages

Oracle DBA Concepts and Architecture Guide

This document provides an overview of several key Oracle database concepts including Oracle architecture, Data Guard, Automatic Storage Management (ASM), Oracle Real Application Clusters (RAC), installation and configuration of RAC, storage management options for RAC, and services for distributed workload management. Specific topics covered include storage components, Data Guard configuration and failover modes, ASM architecture and configuration, RAC components and cache coherency, installation using Optimal Flexible Architecture, storage options such as RAW devices and clustered file systems, and services for fast application failover and load balancing.

Uploaded by

Srinivasa Daasan
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
25 views3 pages

Oracle DBA Concepts and Architecture Guide

This document provides an overview of several key Oracle database concepts including Oracle architecture, Data Guard, Automatic Storage Management (ASM), Oracle Real Application Clusters (RAC), installation and configuration of RAC, storage management options for RAC, and services for distributed workload management. Specific topics covered include storage components, Data Guard configuration and failover modes, ASM architecture and configuration, RAC components and cache coherency, installation using Optimal Flexible Architecture, storage options such as RAW devices and clustered file systems, and services for fast application failover and load balancing.

Uploaded by

Srinivasa Daasan
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

Introduction to Oracle and Internal concepts Oracle Architecture - in detail Storage components - Physical and Logical Data guard

Data guard Architecture Protection Modes Configuration Physical Standby Configuration Logical Standby Switchover and Failover Cascaded Standby Database Oracle Database Advance Administration Practical scenarios

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

Oracle Real Application Clusters(RAC)

RAC components 1. Oracle Clusterware Background processes in RAC Database files in RAC 1. Server parameter file 2. Datafiles 3. Control files 4. Online redo log files 5. Archived redo log files 6. Other files Maintaining read consistency in RAC Cache Coherency Cache fusion Global Resource Directory Mastering of resources Lock management Multi-instance transaction behavior Recovery 1. Cache recovery

2. 3.

Transaction recovery Online block recovery

Installation and Configuration

Optimal Flexible Architecture 1. Installation 2. Pre-installation steps Selecting the clusterware Operating system configuration 1. Creation of an oracle user account Network configuration NIC bonding Configuring the kernel Configuring the hang check timer on Linux systems Configuring and synchronizing the system clock Installing Oracle 1. Oracle Clusterware installation 2. Oracle Software Installation 3. database configuration 4. cluster components 5. OCR backup and restore 6. Setting paths and environment variables

Storage Management

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

Services and Distributed Workload Management Fast Application Notification 1. Oracle Notification Services 2. FAN events Failover and Load-Balancing Failover 1. How does the failover mechanism work?

2. Database/instance recovery 3. Failover of VIP system service 4. Transparent application failover 5. Fast Connect Failover Load-balancing

You might also like