RAC for Administrators

RAC for Administrators

培训课时：32课时（脱产班4天、双休班：4天、晚班8个晚上）

培训费用：7800元/人（送培训资料）

适合人群：已学完Oracle Database 10g：管理I和管理II课程的学员

培训目标：

• 掌握RAC基本概念

• 掌握如何搭建RAC

• 掌握如何维护RAC

• 掌握RAC数据库备份恢复

• 掌握RAC调优

课程大纲：

1、 Architecture and Concepts

• Complete Integrated Cluster Ware

• RAC Software Principles

• RAC Software Storage Principles

• OCR Architecture

• RAC Database Storage Principles

• RAC and Shared Storage Technologies

• Oracle Cluster File System

• Automatic Storage Management

• Raw or CFS?

• Typical Cluster Stack with RAC

• RAC Certification Matrix

• The Necessity of Global Resources

• Global Resources Coordination

• Global Cache Coordination

• Write to Disk Coordination

• RAC and Instance/Crash Recovery

• Instance Recovery and Database Availability

• Efficient Inter-Node Row-Level Locking

• Additional Memory Requirement for RAC

• Parallel Execution with RAC

• Global Dynamic Performance Views

• RAC and Services

• Virtual IP Addresses and RAC

• Database Control and RAC

2、 RAC Installation and Configuration (Part I)

• Oracle Database 10g RAC Installation

• Preinstallation Tasks 

• Hardware Requirements

• Network Requirements

• RAC Network Software Requirements

• Package Requirements

• hangcheck-timer Module Configuration

• Required UNIX Groups and Users

• The oracle User Environment

• User Shell Limits

• Configuring User Equivalency

• Required Directories for the Oracle Database Software

• Linux Kernel Parameters

• Cluster Setup Tasks

• Obtaining OCFS

• Installing the OCFS RPM Packages

• Starting ocfstool

• Generating the ocfsconf File

• Preparing the Disks

• Loading OCFS at Startup

• Mounting OCFS on Startup

• Using Raw Partitions

• Binding the Partitions

• Raw Device Mapping File

• Installing Cluster Ready Services

• Specifying the Inventory Directory

• File Locations and Language Selection 2

• Cluster Configuration

• Private Interconnect Enforcement

• Oracle Cluster Registry File

• Voting Disk File

• Summary and Install

• Running the rootsh Script on All Nodes

• Verifying the CRS Installation

3、 RAC Installation and Configuration (Part II)

• OUI Database Configuration Options

• Install the Database Software

• Specify File Locations

• Specify Cluster Installation 3

• Select Installation Type

• Products Prerequisite Check

• Select Database Configuration

• Check Summary

• The rootsh Script

• Launching the VIPCA with rootsh

• VIPCA Network Interface Discovery

• VIP Configuration Data and Summary

• Installation Progress

• End of Installation

• Database Preinstallation Tasks

• Creating the Cluster Database

• Node Selection

• Select Database Type

• Database Identification

• Cluster Database Management Method

• Passwords for Database Schema Owners

• Storage Options for Database Files

• Database File Locations

• Flash Recovery Area

• Database Components

• Database Services

• Initialization Parameters

• Database Storage Options

• Create the Database

• Monitor Progress

• Manage Default Accounts

• Postinstallation Tasks

• Patches and the RAC Environment

• Inventory List Locks

4、 RAC Database Instances Administration

• The EM Cluster Database Home Page

• Cluster Database Instance Home Page

• Cluster Home Page

• The Configuration Section

• Operating System Details Page

• Performance and Targets Pages

• Starting and Stopping RAC Instances

• Starting and Stopping RAC Instances with EM

• Starting and Stopping RAC Instances with SQL*Plus

• Starting and Stopping RAC Instances with SRVCTL

• RAC Initialization Parameter Files

• SPFILE Parameter Values and RAC

• EM and SPFILE Parameter Values

• RAC Initialization Parameters

• Parameters Requiring Identical Settings

• Parameters Requiring Unique Settings

• Adding a Node to a Cluster

• Adding a Node to an Existing Cluster

• Adding the RAC Software to the New Node

• Reconfigure the Listeners

• Add an Instance by Using DBCA

• Deleting Instances from a RAC Database

• Node Addition and Deletion and the SYSAUX Tablespace

• Quiescing RAC Databases

• How SQL*Plus Commands Affect Instances

• Administering Alerts with Enterprise Manager

• Viewing Alerts

• Blackouts and Scheduled Maintenance

5、 Administering Storage in RAC (Part I)

• What Is Automatic Storage Management?

• ASM: Key Features and Benefits

• ASM: New Concepts

• ASM: General Architecture

• ASM Instance and Crash Recovery in RAC

• ASMLibs

• Oracle Linux ASMLib Installation

• Oracle Linux ASMLib Installation

• ASM Library Disk Creation

• ASM Administration

• ASM Instance Functionalities

• ASM Instance Creation

• ASM Instance Initialization Parameters

• RAC and ASM Instances Creation

• ASM Instance Initialization Parameters and RAC

• Discovering New ASM Instances with EM

• Accessing an ASM Instance

• Dynamic Performance View Additions

• ASM Home Page

• ASM Performance Page

• ASM Configuration Page

• Starting Up an ASM Instance

• Shutting Down an ASM Instance

• ASM Administration

• ASM Disk Group

• Failure Group

• Disk Group Mirroring

• Disk Group Dynamic Rebalancing

• ASM Administration Page

• Create Disk Group Page

• ASM Disk Groups with EM in RAC

• Disk Group Performance Page and RAC

• Create or Delete Disk Groups

• Adding Disks to Disk Groups

• Miscellaneous Alter Commands

• Monitoring Long-Running Operations Using V$ASM_OPERATION

• ASM Administration

• ASM Files

• ASM File Names

• ASM File Name Syntax

• ASM File Name Mapping

• ASM File Templates

• Template and Alias

• Retrieving Aliases

• SQL Commands and File Naming

• DBCA and Storage Options

• Database Instance Parameter Changes

6、 Administering Storage in RAC (Part II)

• ASM and SRVCTL with RAC

• Migrating to ASM: Overview

• Migration with Extra Space: Overview

• Tablespace Migration

• Migrate an SPFILE to ASM

• ASM Disk Metadata Requirements

• ASM and Transportable Tablespaces

• ASM and Storage Arrays

• ASM Scalability

• Redo Log Files and RAC

• Automatic Undo Management and RAC

7、 Services

• Traditional Workload Dispatching

• Grid Workload Dispatching

• What Is a Service?

• High Availability of Services in RAC

• Possible Service Configuration with RAC

• Service Attributes

• Service Types

• Creating Services

• Creating Services with DBCA

• Creating Services with SRVCTL

• Preferred and Available Instances

• Everything Switches to Services

• Using Services with Client Applications

• Using Services with Resource Manager

• Services and Resource Manager with EM

• Services and Resource Manager: Example

• Using Services with Scheduler

• Services and Scheduler with EM

• Services and Scheduler: Example

• Using Services with Parallel Operations

• Using Services with Metric Thresholds

• Changing Service Thresholds Using EM

• Services and Metric Thresholds: Example

• Service Aggregation and Tracing

• Cluster Database: Top Services

• Service Aggregation Configuration

• Service Aggregation: Example

• The trcsess Utility

• Service Performance Views

• Managing Services

• Managing Services with EM

• Managing Services: Example

8、 High Availability of Connections

• Types of Workload Distribution

• Client Side Connect-Time Load Balancing

• Client Side Connect-Time Failover

• Server Side Connect-Time Load Balancing

• Fast Application Notification: Overview

• Fast Application Notification Benefits

• FAN-Supported Event Types

• FAN Event Status

• FAN Event Reasons

• FAN Event Format

• Server-Side Callouts Implementation

• Server-Side Callout Parse: Example

• Server-Side Callout Filter: Example

• Configuring the Server-Side ONS

• Configuring the Client-Side ONS

• JDBC Fast Connection Failover: Overview

• JDBC Fast Connection Failover Benefits

• Transparent Application Failover: Overview

• TAF Basic Configuration: Example

• TAF Preconnect Configuration: Example

• TAF Verification

• FAN Connection Pools and TAF Considerations

• Restricted Session and Services

9、 Managing Backup and Recovery in RAC

• Protecting Against Media Failure

• Configure RAC Recovery Settings with EM

• Configure RAC Backup Settings with EM

• Initiate Archiving

• Archived Log File Configurations

• RAC and the Flash Recovery Area

• Oracle Recovery Manager

• Configuring RMAN

• RMAN Default Autolocation

• User-Managed Backup Methods

• Offline User-Managed Backup

• Online User-Managed Backup

• Channel Connections to Cluster Instances

• Distribution of Backups

• One Local Drive CFS Backup Scheme

• Multiple Drives CFS Backup Scheme

• Non-CFS Backup Scheme

• RAC Backup and Recovery Using EM

• Restoring and Recovering

• Parallel Recovery in Real Application Clusters

• Fast-Start Parallel Rollback in Real Application Clusters

• Managing OCR: Overview

• Recovering the OCR

• Recovering the Voting Disk

10、RAC Performance Tuning

• CPU and Wait Time Tuning Dimensions

• RAC-Specific Tuning

• Analyzing Cache Fusion Impact in RAC

• Typical Latencies for RAC Operations

• Wait Events for RAC

• Wait Event Views

• Global Cache Wait Events: Overview

• way Block Request: Example

• way Block Request: Example

• way Grant: Example

• Considered “Lost” Blocks: Example

• Global Enqueue Waits: Overview

• Session and System Statistics

• Most Common RAC Tuning Tips

• Index Block Contention Considerations

• Oracle Sequences and Index Contention

• Undo Block Considerations

• High-Water Mark Considerations

• Cluster Database Performance Page

• Cluster Cache Coherency Page

• Database Locks Page

• Automatic Workload Repository: Overview

• AWR Tables

• AWR Snapshots in RAC

• Generating and Viewing AWR Reports

• AWR Reports and RAC: Overview

• Statspack and AWR

• Automatic Database Diagnostic Monitor

• ADDM Problem Classification

• RAC-Specific ADDM Findings

• ADDM Analysis: Results

• ADDM Recommendations 

威特教育之——特色

威特教育的Oracle培训在杭州乃至浙江地区占有75%的市场份额。浙大网新、浙大快威、浙江移动、杭州移动、温州移动、吉林移动、浙江爱特、杭州荣志、浙大图灵、浙江烟草、杭州烟草、金华烟草、丽水烟草、萧山国际机场、浙江工商管理局、*民生银行、*银行、杭州银行、交通银行、开发银行、IBM、惠普、联想、西门子、诺基亚、杭州市海关等行政*、企业客户以及数以十计的系统集成商和Oracle代理商成为杭州威特教育的企业会员，*杭州威特教育作为Oracle培训提供商。良好的口碑来源于威特教育一贯的对培训质量负责的态度和优质的教学质量的保障。

威特教育之——服务

1、终生不限次数免费重听所报课程，试听制度保障

2、强调动手能力，实战能力，重视理论联系实际

获得Oracle认证的实力保障

1、完备的实验环境，加强实验环节，切实提高学员的动手能力。

2、资深技术实力、工作经验丰富、多家企业和电信运营商首席数据库工程师OCM或者实力远超OCP的讲师授课，将讲师的一些数据系统的实践经验，与学员进行交流，达到学以至用，学有所成。

3、引进国际*的“技术沙龙式”案例分析教学法,学生与讲师面对面地分析实际案例,在讲师步步引导下,由学员分析引发故障的诸多可能性,并提出对应的排查对策,最终解决问题,从而切实提高学员的实际分析问题-解决问题的能力

a．具有丰富的专业技术和实践经验

b．长期为客户定制培训、善于联系实际、因材施教

c．和蔼可亲，风趣幽默，善于调动课堂气氛，具有高超的培训技巧和生动活泼的授课风格

d．引进国际*的业界培训理念

备注：

1、 上课期间人手一台计算机，理论与实验相结合，充分提高学员动手能力

2、 课余时间标准实验室长期免费开放，并有讲师专门辅导

3、 教学32课时，个人上机实验不限时

威特教育之——考试相关

威特教育是Vue授权的指定的Oracle考试报名点，欢迎各位参加IT认证考试的朋友前来报名参加培训及考试。报名考试即送*版题库，题库覆盖率均为95%以上。

 

开班详情请拔打热线：400-8888-780 400-8888-780