RAC for Administrators

培訓(xùn)課時(shí)：32課時(shí)（脫產(chǎn)班4天、雙休班：4天、晚班8個(gè)晚上）

培訓(xùn)費(fèi)用：7800元/人（送培訓(xùn)資料）

適合人群：已學(xué)完Oracle Database 10g：管理I和管理II課程的學(xué)員

培訓(xùn)目標(biāo)：

• 掌握RAC基本概念

• 掌握如何搭建RAC

• 掌握如何維護(hù)RAC

• 掌握RAC數(shù)據(jù)庫(kù)備份恢復(fù)

• 掌握RAC調(diào)優(yōu)

課程大綱：

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培訓(xùn)在杭州乃至浙江地區(qū)占有75%的市場(chǎng)份額。浙大網(wǎng)新、浙大快威、浙江移動(dòng)、杭州移動(dòng)、溫州移動(dòng)、吉林移動(dòng)、浙江愛(ài)特、杭州榮志、浙大圖靈、浙江煙草、杭州煙草、金華煙草、麗水煙草、蕭山國(guó)際機(jī)場(chǎng)、浙江工商管理局、*民生銀行、*銀行、杭州銀行、交通銀行、開(kāi)發(fā)銀行、IBM、惠普、聯(lián)想、西門(mén)子、諾基亞、杭州市海關(guān)等行政*、企業(yè)客戶以及數(shù)以十計(jì)的系統(tǒng)集成商和Oracle代理商成為杭州威特教育的企業(yè)會(huì)員，*杭州威特教育作為Oracle培訓(xùn)提供商。良好的口碑來(lái)源于威特教育一貫的對(duì)培訓(xùn)質(zhì)量負(fù)責(zé)的態(tài)度和優(yōu)質(zhì)的教學(xué)質(zhì)量的保障。

威特教育之——服務(wù)

1、終生不限次數(shù)免費(fèi)重聽(tīng)所報(bào)課程，試聽(tīng)制度保障

2、強(qiáng)調(diào)動(dòng)手能力，實(shí)戰(zhàn)能力，重視理論聯(lián)系實(shí)際

獲得Oracle認(rèn)證的實(shí)力保障

1、完備的實(shí)驗(yàn)環(huán)境，加強(qiáng)實(shí)驗(yàn)環(huán)節(jié)，切實(shí)提高學(xué)員的動(dòng)手能力。

2、資深技術(shù)實(shí)力、工作經(jīng)驗(yàn)豐富、多家企業(yè)和電信運(yùn)營(yíng)商首席數(shù)據(jù)庫(kù)工程師OCM或者實(shí)力遠(yuǎn)超OCP的講師授課，將講師的一些數(shù)據(jù)系統(tǒng)的實(shí)踐經(jīng)驗(yàn)，與學(xué)員進(jìn)行交流，達(dá)到學(xué)以至用，學(xué)有所成。

3、引進(jìn)國(guó)際*的“技術(shù)沙龍式”案例分析教學(xué)法,學(xué)生與講師面對(duì)面地分析實(shí)際案例,在講師步步引導(dǎo)下,由學(xué)員分析引發(fā)故障的諸多可能性,并提出對(duì)應(yīng)的排查對(duì)策,最終解決問(wèn)題,從而切實(shí)提高學(xué)員的實(shí)際分析問(wèn)題-解決問(wèn)題的能力

a．具有豐富的專業(yè)技術(shù)和實(shí)踐經(jīng)驗(yàn)

b．長(zhǎng)期為客戶定制培訓(xùn)、善于聯(lián)系實(shí)際、因材施教

c．和藹可親，風(fēng)趣幽默，善于調(diào)動(dòng)課堂氣氛，具有高超的培訓(xùn)技巧和生動(dòng)活潑的授課風(fēng)格

d．引進(jìn)國(guó)際*的業(yè)界培訓(xùn)理念

備注：

1、 上課期間人手一臺(tái)計(jì)算機(jī)，理論與實(shí)驗(yàn)相結(jié)合，充分提高學(xué)員動(dòng)手能力

2、 課余時(shí)間標(biāo)準(zhǔn)實(shí)驗(yàn)室長(zhǎng)期免費(fèi)開(kāi)放，并有講師專門(mén)輔導(dǎo)

3、 教學(xué)32課時(shí)，個(gè)人上機(jī)實(shí)驗(yàn)不限時(shí)

威特教育之——考試相關(guān)

威特教育是Vue授權(quán)的指定的Oracle考試報(bào)名點(diǎn)，歡迎各位參加IT認(rèn)證考試的朋友前來(lái)報(bào)名參加培訓(xùn)及考試。報(bào)名考試即送*版題庫(kù)，題庫(kù)覆蓋率均為95%以上。

 

開(kāi)班詳情請(qǐng)拔打熱線：400-8888-780 400-8888-780