Oracle11g数据库RAC高可用课程


随着Oracle数据库市场的快速扩张,做为保护实例的RAC(Real Application Cluster)高可用技术与保护数据的DG(Data Guard)容灾技术,正越来越多地成为各种不同规模应用系统中的基本配置,掌握RAC与DG的原理与实践,是DBA必须要具备的高级技能之一。


RAC高可用实验课程,可使得学员在短时间内掌握RAC的安装、部署、管理与优化等内容。课程以实践能力提升为主,同时注重理论的讲解和学习。


基础要求:

  1. Oracle Database 11g: Administration Workshop I (052)

  2. Oracle Database 11g: Administration Workshop II (053)


学习实验环境:Linux虚拟化云环境。


 
Oracle11g数据库RAC高可用课程模块说明:

序号 模块说明
1 Oracle Grid基础架构和集群的基本概念
2 RAC集群环境的安装、管理及故障处理
3 RAC集群环境的备份和恢复
4 RAC数据库的监控和优化
5 设计RAC高可用数据库系统


 
RAC课程理论内容详细介绍

  1. Oracle Grid Infrastructure Concepts

序号 授课内容
1) Explain the principles and purposes of clusters
2) Describe Cluster hardware best practices
3) Describe the Oracle Clusterware architecture
4) Describe how Grid Plug and Play affects Clusterware

  2. Oracle Clusterware Architecture

序号 授课内容
5) Describe the Oracle Clusterware architecture
6) Describe the components of Grid Infrastructure: HA Services, Clusterware, ASM
7) Understand why ASM and Clusterware are combined in GI

  3. Grid Infrastructure Preinstallation Tasks

序号 授课内容
8) perform preinstallation tasks for Grid Infrastructure

  4. Grid Infrastructure Installation

序号 授课内容
9) Install Grid Infrastructure
10) Verify the installation
11) Configure Automatic Storage Management (ASM) disk groups
12) Configure ASM volumes
13) Make the ASM cluster file system
14) Mount ASM Cluster File System (ACFS) volumes

  5. Adding and Removing Cluster Nodes

序号 授课内容
15) Perform the prerequisite steps for extending a cluster
16) Use addNode.sh to add a node to a cluster
17) Delete a node from a cluster

  6. Administering Oracle Clusterware

序号 授课内容
18) Display Clusterware management proficiency
19) Demonstrate Oracle Cluster Registry (OCR) backup and recovery techniques
20) Manage network settings

  7. Upgrading and Patching Grid Infrastructure

序号 授课内容
21) Describe the types of patches and upgrades available
22) Plan for rolling patches and rolling upgrades
23) Compare software versions with the active version
24) Install a patchset with the Oracle Universal Installer (OUI) utility
25) Install a patch with the opatch utility

  8. Troubleshooting Oracle Clusterware

序号 授课内容
26) Locate Oracle Clusterware log files
27) Gather all log files using diagcollection.pl
28) Enable resource debugging
29) Enable component-level debugging
30) Enable tracing for Java-based tools
31) Troubleshoot the Oracle Cluster Registry (OCR) file

  9. Making Applications Highly Available with Oracle Clusterware

序号 授课内容
32) Describe the high availability components of Oracle Clusterware
33) Contrast policy-managed and administration-managed databases
34) Describe the functionality of server pools
35) Describe application-placement policies
36) Create an application Virtual IP (VIP)
37) Manage application resources

  10. ASM: Overview

序号 授课内容
38) Describe the Automatic Storage Management (ASM) architecture
39) Describe the components of ASM

  11. Real Application Clusters Database Installation

序号 授课内容
40) Install the Oracle database software
41) Create a cluster database
35) Perform post-database-creation tasks
36) Perform a single instance to RAC conversion

  12. Oracle RAC Administration

序号 授课内容
37) Use Enterprise Manager Cluster Database pages
38) Define redo log files in a RAC environment
39) Define undo tablespaces in a RAC environment
40) Start and stop RAC databases and instances
41) Modify initialization parameters in a RAC environment

  13. Managing Backup and Recovery for RAC

序号 授课内容
42) The RAC database to use ARCHIVELOG mode and the fast recovery area
43) RMAN for the RAC environment

  14. RAC Database Monitoring and Tuning

序号 授课内容
44) Determine RAC-specific tuning components
45) Tune instance recovery in RAC
46) Determine RAC-specific wait events, global enqueues, and system statistics
47) Implement the most common RAC tuning tips
48) Use the Cluster Database Performance pages
49) Use the Automatic Workload Repository (AWR) in RAC
50) Use Automatic Database Diagnostic Monitor (ADDM) in RAC

  15. Services

序号 授课内容
51) Configure and manage services in a RAC environment
52) Use services with client applications
53) Use services with the Database Resource Manager
54) Use services with the Scheduler
55) Configure services aggregation and tracing

  16. Design for High Availability

序号 授课内容
56) Design a Maximum Availability Architecture in your environment
57) Determine the best RAC and Data Guard topologies for your environment
58) Configure the Data Guard Broker configuration files in a RAC environment
59) Identify successful disk I/O strategies
60) Use the Enterprise Manager SQL Access Advisor graphical interface to optimize your entire workload
61) Use the SQL Access Advisor PL/SQL procedures
62) Tune materialized views for fast refresh and query rewrite
63) Use the features of compression and resumable sessions
关于我们 | 新闻中心 | 合作伙伴 | 联系我们 |
西安优盛信息技术有限公司  版权所有©2007-2018  陕ICP备07501629号
在线客服系统