學(xué)員參加完本門OCM課程培訓(xùn)后，可以掌握RAC技術(shù)，RAC是Oracle核心技術(shù)。搭建了RAC后可以實現(xiàn)系統(tǒng)的高可用性、以及系統(tǒng)的負(fù)載均衡，讓數(shù)據(jù)庫更加、穩(wěn)定地提供響應(yīng)請求。

已經(jīng)修完Oracle Database 10g：管理課程練習(xí) I和Oracle Database 10g：管理課程練習(xí) II課程的學(xué)員

學(xué)完本課程后，學(xué)員將具備以下能力：
1、掌握RAC基本概念
2、掌握如何搭建RAC
3、掌握如何維護(hù)RAC
4、掌握RAC數(shù)據(jù)庫備份恢復(fù)
5、掌握RAC調(diào)優(yōu)

章.?Architecture and Concepts
1.1.?Complete Integrated Cluster Ware
1.2.?RAC Software Principles
1.3.?RAC Software Storage Principles
1.4.?OCR Architecture
1.5.?RAC Database Storage Principles
1.6.?RAC and Shared Storage Technologies
1.7.?Oracle Cluster File System
1.8.?Automatic Storage Management
1.9.?Raw or CFS?
1.10.?Typical Cluster Stack with RAC
1.11.?RAC Certification Matrix
1.12.?The Necessity of Global Resources
1.13.?Global Resources Coordination
1.14.?Global Cache Coordination
1.15.?Write to Disk Coordination
1.16.?RAC and Instance/Crash Recovery
1.17.?Instance Recovery and Database Availability
1.18.?Efficient Inter-Node Row-Level Locking
1.19.?Additional Memory Requirement for RAC
1.20.?Parallel Execution with RAC
1.21.?Global Dynamic Performance Views
1.22.?RAC and Services
1.23.?Virtual IP Addresses and RAC
1.24.?Database Control and RAC
第二章.?RAC Installation and Configuration (Part I)
2.1.?Oracle Database 10g RAC Installation:
2.2.?Preinstallation Tasks?
2.3.?Hardware Requirements?
2.4.?Network Requirements?
2.5.?RAC Network Software Requirements?
2.6.?Package Requirements?
2.7.?hangcheck-timer Module Configuration?
2.8.?Required UNIX Groups and Users?
2.9.?The oracle User Environment?
2.10.?User Shell Limits?
2.11.?Configuring User Equivalency?
2.12.?Required Directories for the Oracle Database Software?
2.13.?Linux Kernel Parameters?
2.14.?Cluster Setup Tasks?
2.15.?Obtaining OCFS?
2.16.?Installing the OCFS RPM Packages?
2.17.?Starting ocfstool?
2.18.?Generating the ocfsconf File?
2.19.?Preparing the Disks?
2.20.?Loading OCFS at Startup?
2.21.?Mounting OCFS on Startup?
2.22.?Using Raw Partitions?
2.23.?Binding the Partitions?
2.24.?Raw Device Mapping File?
2.25.?Installing Cluster Ready Services?
2.26.?Specifying the Inventory Directory?
2.27.?File Locations and Language Selection 2
2.28.?Cluster Configuration?
2.29.?Private Interconnect Enforcement?
2.30.?Oracle Cluster Registry File?
2.31.?Voting Disk File?
2.32.?Summary and Install?
2.33.?Running the rootsh Script on All Nodes?
2.34.?Verifying the CRS Installation
第三章.?RAC Installation and Configuration (Part II)
3.1.?OUI Database Configuration Options?
3.2.?Install the Database Software?
3.3.?Specify File Locations?
3.4.?Specify Cluster Installation 3
3.5.?Select Installation Type?
3.6.?Products Prerequisite Check?
3.7.?Select Database Configuration?
3.8.?Check Summary?
3.9.?The rootsh Script?
3.10.?Launching the VIPCA with rootsh?
3.11.?VIPCA Network Interface Discovery?
3.12.?VIP Configuration Data and Summary?
3.13.?Installation Progress?
3.14.?End of Installation?
3.15.?Database Preinstallation Tasks?
3.16.?Creating the Cluster Database?
3.17.?Node Selection?
3.18.?Select Database Type?
3.19.?Database Identification?
3.20.?Cluster Database Management Method?
3.21.?Passwords for Database Schema Owners?
3.22.?Storage Options for Database Files?
3.23.?Database File Locations?
3.24.?Flash Recovery Area?
3.25.?Database Components?
3.26.?Database Services?
3.27.?Initialization Parameters?
3.28.?Database Storage Options?
3.29.?Create the Database?
3.30.?Monitor Progress?
3.31.?Manage Default Accounts?
3.32.?Postinstallation Tasks?
3.33.?Patches and the RAC Environment?
3.34.?Inventory List Locks
第四章.?RAC Database Instances Administration
4.1.?The EM Cluster Database Home Page?
4.2.?Cluster Database Instance Home Page?
4.3.?Cluster Home Page?
4.4.?The Configuration Section?
4.5.?Operating System Details Page?
4.6.?Performance and Targets Pages?
4.7.?Starting and Stopping RAC Instances?
4.8.?Starting and Stopping RAC Instances with EM?
4.9.?Starting and Stopping RAC Instances with SQL*Plus?
4.10.?Starting and Stopping RAC Instances with SRVCTL?
4.11.?RAC Initialization Parameter Files?
4.12.?SPFILE Parameter Values and RAC?
4.13.?EM and SPFILE Parameter Values?
4.14.?RAC Initialization Parameters?
4.15.?Parameters Requiring Identical Settings?
4.16.?Parameters Requiring Unique Settings?
4.17.?Adding a Node to a Cluster?
4.18.?Adding a Node to an Existing Cluster?
4.19.?Adding the RAC Software to the New Node?
4.20.?Reconfigure the Listeners?
4.21.?Add an Instance by Using DBCA?
4.22.?Deleting Instances from a RAC Database?
4.23.?Node Addition and Deletion and the SYSAUX Tablespace?
4.24.?Quiescing RAC Databases?
4.25.?How SQL*Plus Commands Affect Instances?
4.26.?Administering Alerts with Enterprise Manager?
4.27.?Viewing Alerts?
4.28.?Blackouts and Scheduled Maintenance?
第五章.?Administering Storage in RAC (Part I)
5.1.?What Is Automatic Storage Management?
5.2.?ASM: Key Features and Benefits?
5.3.?ASM: New Concepts?
5.4.?ASM: General Architecture?
5.5.?ASM Instance and Crash Recovery in RAC?
5.6.?ASMLibs?
5.7.?Oracle Linux ASMLib Installation:?
5.8.?Oracle Linux ASMLib Installation
5.9.?ASM Library Disk Creation?
5.10.?ASM Administration?
5.11.?ASM Instance Functionalities?
5.12.?ASM Instance Creation?
5.13.?ASM Instance Initialization Parameters?
5.14.?RAC and ASM Instances Creation?
5.15.?ASM Instance Initialization Parameters and RAC?
5.16.?Discovering New ASM Instances with EM?
5.17.?Accessing an ASM Instance?
5.18.?Dynamic Performance View Additions?
5.19.?ASM Home Page?
5.20.?ASM Performance Page?
5.21.?ASM Configuration Page?
5.22.?Starting Up an ASM Instance?
5.23.?Shutting Down an ASM Instance?
5.24.?ASM Administration?
5.25.?ASM Disk Group?
5.26.?Failure Group?
5.27.?Disk Group Mirroring?
5.28.?Disk Group Dynamic Rebalancing?
5.29.?ASM Administration Page?
5.30.?Create Disk Group Page?
5.31.?ASM Disk Groups with EM in RAC?
5.32.?Disk Group Performance Page and RAC?
5.33.?Create or Delete Disk Groups?
5.34.?Adding Disks to Disk Groups?
5.35.?Miscellaneous Alter Commands?
5.36.?Monitoring Long-Running Operations Using V$ASM_OPERATION?
5.37.?ASM Administration?
5.38.?ASM Files?
5.39.?ASM File Names
5.40.?ASM File Name Syntax?
5.41.?ASM File Name Mapping?
5.42.?ASM File Templates
5.43.?Template and Alias:
5.44.?Retrieving Aliases?
5.45.?SQL Commands and File Naming?
5.46.?DBCA and Storage Options?
5.47.?Database Instance Parameter Changes?
第六章.?Administering Storage in RAC (Part II)
6.1.?ASM and SRVCTL with RAC??
6.2.?Migrating to ASM: Overview?
6.3.?Migration with Extra Space: Overview?
6.4.?Tablespace Migration:?
6.5.?Migrate an SPFILE to ASM?
6.6.?ASM Disk Metadata Requirements?
6.7.?ASM and Transportable Tablespaces?
6.8.?ASM and Storage Arrays?
6.9.?ASM Scalability?
6.10.?Redo Log Files and RAC?
6.11.?Automatic Undo Management and RAC
第七章.?Services
7.1.?Traditional Workload Dispatching?
7.2.?Grid Workload Dispatching?
7.3.?What Is a Service??
7.4.?High Availability of Services in RAC
7.5.?Possible Service Configuration with RAC?
7.6.?Service Attributes?
7.7.?Service Types?
7.8.?Creating Services?
7.9.?Creating Services with DBCA?
7.10.?Creating Services with SRVCTL?
7.11.?Preferred and Available Instances?
7.12.?Everything Switches to Services?
7.13.?Using Services with Client Applications?
7.14.?Using Services with Resource Manager?
7.15.?Services and Resource Manager with EM?
7.16.?Services and Resource Manager: Example?
7.17.?Using Services with Scheduler?
7.18.?Services and Scheduler with EM?
7.19.?Services and Scheduler: Example?
7.20.?Using Services with Parallel Operations?
7.21.?Using Services with Metric Thresholds?
7.22.?Changing Service Thresholds Using EM?
7.23.?Services and Metric Thresholds: Example?
7.24.?Service Aggregation and Tracing?
7.25.?Cluster Database: Top Services?
7.26.?Service Aggregation Configuration?
7.27.?Service Aggregation: Example?
7.28.?The trcsess Utility?
7.29.?Service Performance Views?
7.30.?Managing Services?
7.31.?Managing Services with EM?
7.32.?Managing Services: Example?
第八章.?High Availability of Connections
8.1.?Types of Workload Distribution?
8.2.?Client Side Connect-Time Load Balancing?
8.3.?Client Side Connect-Time Failover?
8.4.?Server Side Connect-Time Load Balancing?
8.5.?Fast Application Notification: Overview?
8.6.?Fast Application Notification Benefits?
8.7.?FAN-Supported Event Types?
8.8.?FAN Event Status?
8.9.?FAN Event Reasons?
8.10.?FAN Event Format?
8.11.?Server-Side Callouts Implementation?
8.12.?Server-Side Callout Parse: Example?
8.13.?Server-Side Callout Filter: Example?
8.14.?Configuring the Server-Side ONS?
8.15.?Configuring the Client-Side ONS?
8.16.?JDBC Fast Connection Failover: Overview?
8.17.?JDBC Fast Connection Failover Benefits?
8.18.?Transparent Application Failover: Overview?
8.19.?TAF Basic Configuration: Example
8.20.?TAF Preconnect Configuration: Example?
8.21.?TAF Verification?
8.22.?FAN Connection Pools and TAF Considerations?
8.23.?Restricted Session and Services?
第九章.?Managing Backup and Recovery in RAC
9.1.?Protecting Against Media Failure?
9.2.?Configure RAC Recovery Settings with EM
9.3.?Configure RAC Backup Settings with EM?
9.4.?Initiate Archiving?
9.5.?Archived Log File Configurations?
9.6.?RAC and the Flash Recovery Area?
9.7.?Oracle Recovery Manager?
9.8.?Configuring RMAN?
9.9.?RMAN Default Autolocation?
9.10.?User-Managed Backup Methods?
9.11.?Offline User-Managed Backup?
9.12.?Online User-Managed Backup?
9.13.?Channel Connections to Cluster Instances?
9.14.?Distribution of Backups?
9.15.?One Local Drive CFS Backup Scheme?
9.16.?Multiple Drives CFS Backup Scheme?
9.17.?Non-CFS Backup Scheme?
9.18.?RAC Backup and Recovery Using EM?
9.19.?Restoring and Recovering?
9.20.?Parallel Recovery in Real Application Clusters?
9.21.?Fast-Start Parallel Rollback in Real Application Clusters?
9.22.?Managing OCR: Overview?
9.23.?Recovering the OCR?
9.24.?Recovering the Voting Disk
第十章.?RAC Performance Tuning
10.1.?CPU and Wait Time Tuning Dimensions?
10.2.?RAC-Specific Tuning?
10.3.?Analyzing Cache Fusion Impact in RAC?
10.4.?Typical Latencies for RAC Operations?
10.5.?Wait Events for RAC?
10.6.?Wait Event Views?
10.7.?Global Cache Wait Events: Overview?
10.8.?2-way Block Request: Example?
10.9.?3-way Block Request: Example?
10.10.?2-way Grant: Example?
10.11.?Considered “Lost” Blocks: Example?
10.12.?Global Enqueue Waits: Overview?
10.13.?Session and System Statistics?
10.14.?Most Common RAC Tuning Tips?
10.15.?Index Block Contention Considerations?
10.16.?Oracle Sequences and Index Contention?
10.17.?Undo Block Considerations?
10.18.?High-Water Mark Considerations?
10.19.?Cluster Database Performance Page?
10.20.?Cluster Cache Coherency Page?
10.21.?Database Locks Page?
10.22.?Automatic Workload Repository: Overview?
10.23.?AWR Tables?
10.24.?AWR Snapshots in RAC?
10.25.?Generating and Viewing AWR Reports?
10.26.?AWR Reports and RAC: Overview?
10.27.?Statspack and AWR?
10.28.?Automatic Database Diagnostic Monitor?
10.29.?ADDM Problem Classification?
10.30.?RAC-Specific ADDM Findings?
10.31.?ADDM Analysis: Results?
10.32.?ADDM Recommendations?