oracle9i database Real Application Clusters on Linux

oracle9i database Real Application Clusters on Linux Powerpoint Presentation

oracle9i database Real Application Clusters on Linux

Read more...

Managing RAID on Linux

Description

Managing RAID on Linux covers everything system administrators need to know to put together a system that can support RAID. You will learn about the different types of RAID, along with associated technologies and issues, and how to choose the best RAID system for your needs. With a step-by-step, hands-on approach, the author guides you through the installation of either Linux software RAID or a hardware RAID card. 

Redundant Array of Independent Disks (RAID) technology is becoming a standard feature of computer systems that support mission-critical services like file sharing, mail exchange, or Web servers. RAID offers two benefits to these essential systems: improved I/O performance and fail-safe data storage.

Although bandwidth problems on networks are well documented, the internal data transfer bottleneck that exists at the hardware level in each system can also leave you with perplexing performance issues. RAID is a cost-effective and easy-to-manage way to alleviate this bandwidth problem by distributing the I/O load seamlessly across multiple disks and controllers.

RAID also provides uninterrupted data access through disk mirroring and parity algorithms. That means systems can remain online even during a disk or controller failure. RAID is scalable, making it robust enough for large, high-traffic sites and small, critical systems. By using RAID, system administrators can combine single disks into terabytes worth of data storage.

Managing RAID on Linux covers everything system administrators need to know to put together a system that can support RAID. You will learn about the different types of RAID, along with associated technologies and issues, and how to choose the best RAID system for your needs. With a step-by-step, hands-on approach, the author guides you through the installation of either Linux software RAID or a hardware RAID card. The book shows how to build an array and optionally install a high-performance file system. Contents include:

• An introduction to RAID and Linux
• Planning and architecture of your RAID system
• Building a software RAID
• Software RAID tools and references
• Building a hardware RAID
• Performance and tuning of your RAID system

RAID has become the low-cost solution of choice to deal with the ever-increasing demand for data storage space. Written for system administrators, power users, tech managers, and anyone who wants to learn about RAID technology, Managing RAID on Linux sidesteps the often-confusing vendor-specific approach you'll find elsewhere to give you the straight story on RAID. Even non-Linux users will find this book full of valuable material.

Managing RAID on Linux

 

Read more...

D17276GC10 Oracle Database 10gReal Application Clusters Vol 2

D17276GC10 Oracle Database 10gReal Application Clusters Vol 2

Read more...

D17276GC10 Oracle Database 10g Real Application Clusters Vol-1

What you will learn

This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 1 for Oracle Real Application Clusters (RAC).

Students learn how to configure and administer a database for use with Real Application Clusters. The course also explains how to setup and use Automatic Storage Management (ASM) in a Real Application Clusters environment. Lectures are reinforced with hands-on practices designed to walk the student through the RAC administration.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.


Audience
Database Administrators

Course Objectives
Identify Real Application Clusters components
Install, create, administer, and monitor a Real Application Clusters database
Use configuration and management tools for Real Application Clusters databases
Migrate your database storage to Automatic Storage Management
Setup services for workloads management, and applications high availability
Develop a backup and recovery strategy for Real Application Clusters databases
Review high availability best practices

Course Topics

Introduction
Define a cluster
Define Oracle Real Application Clusters
List the advantages of using RAC
Define scalability
High availability and RAC

Architecture and Concepts
List the various components of Cluster Ready Services (CRS) and Real Application Clusters (RAC)
Describe the various types of files used by a RAC database
Describe the various techniques used to share database files across a cluster
Describe the purpose of using services with RAC

RAC Installation and Configuration Part I
Outline Oracle 10g RAC Installation
Preinstallation Tasks
Cluster Setup Tasks
Installing OCFS
Installing Cluster Ready Services

RAC Installation and Configuration Part II
Install Database Software
Launching VIPCA with root.sh
Database Precreation Tasks
Creating the Cluster Database
Database Postinstallation Tasks
Administering Enterprise Manager Jobs in Real Application Clusters
Node Addition and Deletion and the SYSAUX Tablespace
AWR snapshots in RAC

RAC Database Instances Administration
Understand the EM Cluster Database Home Page
Starting and Stopping RAC Instances
RAC Initialization Parameter Files
Adding a Node to a Cluster
Deleting Instances from a RAC Database
Quiescing RAC Databases
Administering Alerts with Enterprise Manager

Administering Storage in RAC Part I
Describe automatic storage management (ASM)
Install the ASM software
Set up initialization parameter files for ASM and database instances
Start up and shut down ASM instances
Add ASM instances to the target list of Database Control
Use Database Control to administer ASM in a RAC environment

Administering Storage in RAC Part II
Manage redo log groups in a RAC environment
Manage undo tablespaces in a RAC environment
Use SRVCTL to manage ASM instances
Migrate database files to ASM
Manage and recover the OCR file and voting disk

Services
Configure and manage services in a RAC environment
Use services with client applications
Use services with the Database Resource Manager
Use services with the Scheduler
Set performance-metric thresholds on services
Configure services aggregation and tracing

High Availability of Connections
Configure client side connect-time load balancing
Configure client side connect-time failover
Configure server side connect-time load balancing
Benefit from Fast Application Notification (FAN)
Configure server-side callouts
Configure the server and client-side ONS
Configure Transparent Application Failover (TAF)

Managing Backup and Recovery in RAC
Configure RAC Recovery Settings with EM
Configure RAC Backup Settings with EM
Initiate Archiving
Configuring RMAN
RAC Backup and Recovery Using EM

RAC Performance Tuning
Determine RAC specific tuning components
Tune instance recovery in RAC
Determine RAC specific wait events, global enqueues, and system statistics
Implement most common RAC tuning tips
Use the Cluster Database Performance pages
Use Automatic Workload Repository and Automatic Database Diagnostic Monitor in RAC

Design for High Availability
Design a Maximum Availability Architecture in your environment
Determine the best RAC and Data Guard topologies for your environment
Configure the Data Guard Broker configuration files in a RAC environment
Patch your RAC system in a rolling fashion

D17276GC10 Oracle Database 10g Real Application Clusters

Read more...

Oracle9i Real Application Clusters D34316 Oracle9i Real Application Clusters

Contents

What's New in Real Application Clusters?

Part I Cluster Database Processing Fundamentals

1 Introduction to Real Application Clusters

    What Is Real Application Clusters?
    The Benefits of Real Application Clusters

        Lower Overall Cost of Ownership
        Expanded Scalability
        High Availability
        Transparency
        Buffer Cache Management
        Row Locking
        Multiversion Read Consistency
        Recovery Manager, Online Backups, and Archiving

2 Real Application Clusters Systems Architecture

    Overview of Cluster Database System Components

        Nodes and Their Components
        Cluster Interconnect and Interprocess Communication (Node-to-Node)

    Memory, Interconnect, and Storage
    The High-Speed IPC Interconnect
    Shared Disk Storage and the Cluster File System Advantage

3 Real Application Clusters Software Architecture

    The Operating System-Dependent Clusterware

        The Cluster Manager
        The Node Monitor
        The Interconnect

    Real Application Clusters Shared Disk Components
    Real Application Clusters-Specific Daemon and Instance Processes

        The Global Services Daemon
        Instance Processes Specific to Real Application Clusters

    The Global Cache and Global Enqueue Service

        Application Transparency
        Global Resource Directory with Distributed Architecture
        Resource Mastering and Affinity
        GCS and GES Interaction with the Cluster Manager

4 Scalability in Real Application Clusters

    Scalability Features of Real Application Clusters
    All System Types Benefit from Real Application Clusters

        Transaction Systems and Real Application Clusters
        Data Warehouse Systems and Real Application Clusters

    Levels of Scalability

        Network Scalability
        Network Scalability and Client/Server Connectivity
        Operating System Scalability

Part II Resource Coordination in Real Application Clusters
5 Real Application Clusters Resource Coordination

    Overview of Real Application Clusters Resource Coordination

        The Contents of the Global Resource Directory
        Real Application Clusters Synchronization Processes
        Enqueues
        Past Images

    Resource Modes and Roles

        Resource Modes
        Resource Roles
        Global Cache Service Operations

    System Change Number Processing

        Lamport SCN Generation

6 Cache Fusion and the Global Cache Service

    Overview of Cache Fusion Processing

        Concurrent Reads on Multiple Nodes
        Concurrent Reads and Writes on Different Nodes
        Concurrent Writes on Different Nodes
        Write Protocol and Past Image Tracking

    Resource Control, Cache-to-Cache Transfer, and Cache Coherency
    Block Access Modes and Buffer States
    Cache Fusion Scenarios

        Requesting a Changed Block for a Modification Operation
        Writing Blocks to Disk

    Real Application Clusters Recovery and Cache Fusion

7 Resource Coordination by the Global Enqueue Service

    Global Enqueue Service Processing
    Global Enqueue Concurrency Control
    Resources Managed by the Global Enqueue Service

        Dictionary Cache Locks
        Library Cache Locks

Part III Implementing Real Application Clusters
8 Real Application Clusters Storage Considerations

    Overview of Storage in Real Application Clusters
    Datafiles in Real Application Clusters

        Datafile Verification in Real Application Clusters
        Adding Datafiles in Real Application Clusters

    Parameter File Storage in Real Application Clusters

        Location of the Server Parameter File

    Redo Log File Storage in Real Application Clusters
    Automatic Segment-Space Management
    Managing Undo Space in Real Application Clusters

        Private and Public Rollback Segments

9 Manageability Tools for Real Application Clusters Environments

    Overview of Manageability in Real Application Clusters
    Manageability for Real Application Clusters Installation, Setup, and Configuration
    Manageability for Real Application Clusters Administration

        Oracle Enterprise Manager
        The Database Configuration Assistant
        The Server Control (SRVCTL) Utility
        Global Services Daemon Administration Commands

    Manageability for Real Application Clusters Performance Monitoring

        Monitoring Performance with Oracle Enterprise Manager
        Monitoring Performance with Statspack

    Manageability for Real Application Clusters Backup and Recovery

Part IV High Availability and Real Application Clusters
10 High Availability Concepts and Best Practices in Real Application Clusters

    Understanding High Availability
    Configuring Real Application Clusters for High Availability

        Cluster Components and High Availability

    Disaster Planning
    Failure Protection Validation
    Failover and Real Application Clusters

        Failover Basics
        Client Failover
        Uses of Transparent Application Failover
        Server Failover

    Failover Processing in Real Application Clusters

        Detecting Failure
        Reorganizing Cluster Membership
        Performing Database Recovery

    High Availability Configurations

        Default N-Node Configurations
        Basic High Availability Configurations
        Shared High Availability Node Configurations
        Full Active Configurations with Real Application Clusters Guard II

    Deploying High Availability

Part V Reference
A Restrictions

    Compatibility
    Restricted SQL Statements
    Maximum Number of Datafiles

B Using Multi-Block Lock Assignments (Optional)

    When to Use Locks
    How to Use Locks
    Lock Granularity
    Understanding Lock Management

Oracle9i Real Application Clusters D34316 Oracle9i Real Application Clusters

Read more...