课程详情
课程介绍
OCM-3 RAC for Administrators
对应：
Oracle OCM认证
培训课时：
24课时
课程介绍：
学员参加完本门OCM课程培训后，可以掌握RAC技术，RAC是Oracle核心技术。搭建了RAC后可以实现系统的高可用性、以及系统的负载均衡，让数据库更加、稳定地提供响应请求。
适合人群：
已经修完Oracle Database 10g：管理课程练习 I和Oracle Database 10g：管理课程练习 II课程的学员
培训目标：
学完本课程后，学员将具备以下能力：
1、掌握RAC基本概念
2、掌握如何搭建RAC
3、掌握如何维护RAC
4、掌握RAC数据库备份恢复
5、掌握RAC调优
1、掌握RAC基本概念
2、掌握如何搭建RAC
3、掌握如何维护RAC
4、掌握RAC数据库备份恢复
5、掌握RAC调优
课程大纲：
章. 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
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
课程评价
聚划算
