* 09:30 ~ 17:00 (30시간 / 5일) (점심시간이 1시간 30분)
본 과정은 Oracle RAC(Real Application Clusters)용 Oracle Database 11g 의 일반적인 특징 및 기능을 소개합니다.
수강생들은 Oracle Cluster ware, RAC(Real Application Clusters) 및 Automatic Storage Management를 설치하고 구성하는 방법을
학습하며, Enterprise Manager Grid Control을 사용하여 RAC(Real Application Clusters)에서 데이터베이스를 관리하는 방법을 배우게
됩니다. RAC 환경에서 데이터베이스 서비스 및 Load Balancing Advisory 구성 및 사용 방법을 익혀 효율성을 높일 수 있습니다.
클러스터에서 노드를 추가하고 제거하는 방법 및 Oracle Cluster ware와 RAC(Real Application Clusters) 소프트웨어를 롤링 방식으로
둘 다 패치 하는 방법을 배웁니다.
Administrator/Database Administrators/Support Engineer/
Technical Administrator/Technical Consultant
1. Introduction to Grid Infrastructure - What is a Cluster? - What is a Flex Cluster? - Clusterware Characteristics - Oracle Clusterware - Hardware and Software Concepts (High level) - Shared Storage Overview 2. Oracle Clusterware Architecture - Cluster Storage Requirements - Clusterware Initialization and OHASD - Clusterware Process Architecture - Location Independent Names, Addresses and Name Resolution (GNS, SCAN, VIP..) - Shared GNS Background and Architecture - Configuring shared GNS - Migrating to shared GNS - Moving GNS to Another Cluster 3. Flex Cluster Architecture - Flex Cluster Architecture - Configuring Flex Cluster - Flex Clusters and Node Failure 4. Grid Infrastructure Pre-Installation Tasks - Shared Storage for Oracle Clusterware - Checking System Requirements - Single Client Access Name for the Cluster - Redundant Interconnect Usage - Kernel Requirements - Groups and Users - Shell Settings - Oracle Validated Configuration 5. Installing Grid Infrastructure - Installing Oracle Grid Infrastructure - Installing Flex Cluster - Verifying the Oracle Clusterware Installation 6. Managing Cluster Nodes - Adding Oracle Clusterware Homes - Prerequisites for Running addNode.sh - Adding a Node with addNode.sh - Configuring the node role - Removing a Node from the Cluster 7. Traditional Clusterware Management - Oracle Clusterware startup and shutdown - Administering the Voting Disk file - Administering the Oracle Cluster Registry Disk file - Network Administration - What-If Command Evaluation - Clusterware Admin Tools Review 8. Policy-Based Cluster Management - Policy-Based Cluster Management Overview - Server Categorization - Policy Set 9. Patching Grid Infrastructure - Out-of-Place Oracle Clusterware Upgrade - Types of Patches - Obtaining Oracle Clusterware Patches - Rolling Patches - Installing a Rolling Patchset with OUI - OPatch Overview - Installing a Rolling Patch with OPatch - OPatch Automation 10. Troubleshooting Oracle Clusterware - Diagnostic Framework Support for CRS - Cluster Health Monitor Enhancements Overview - Component level checks - cluvfy with -comp - Resource Debugging - Java Tools and Dynamic Debugging - Troubleshooting Node Evictions - Log files and Diagnostic Collection - The oclumon Utility 11. Making Applications Highly Available - Overview of Using Oracle Clusterware to Enable HA - Oracle Clusterware HA Components - Resource Management Options - Server Pools - Overall flow diagram of HA lifecycle (crs_profile, crs_register, crs_start….) - Clusterware Resource Modeling - Creating an Application VIP - ONS and FAN overviews 12. RAC Databases Overview & Architecture - Overview of Oracle RAC - RAC One Node - Cluster-Aware Storage Solutions - Benefits of Using RAC - Scaleup and Speedup - I/O Throughput Balanced - Global Resources - RAC and Flex ASM 13. Installing and Configuring Oracle RAC - Installing the Oracle Database Software - Installation options - Creating the Cluster Database - Post-installation Tasks - Single Instance to RAC Conversion - Cleaning Up Unsuccessful Installs 14. Oracle RAC Administration - Parameters and RAC - SPFILE, Identical and Unique Parameters - Instance Startup, Shutdown and Quiesce - Undo Tablespaces - Redo Threads - Use Enterprise Manager Cluster Database Pages - RAC Alerts - RAC Metrics - Session management on RAC instances 15. RAC Backup and Recovery - Instance Failure And Recovery In RAC - LMON and SMON - Redo Threads and Archive Log Configurations and Admin - Parameter Settings Affecting Parallel Recovery and MTTR - Instance Failure And Recovery In RAC - LMON and SMON - RAC and the Fast Recovery Area - RMAN Configuration - RMAN Admin For RAC: Channels, Instances, Backup Distribution - RMAN Restore And Recovery RAC Considerations 16. RAC Global Resource Management and Cache Fusion - Globally Managed Resources and Management - Library Cache Management - Row cache management - Buffer cache fusion - Buffer Cache Management Requirements - Accessing single blocks in RAC - Multi-block read considerations in RAC - Undo and read consistency considerations in RAC 17. RAC Monitoring and Tuning - OCPU and Wait Time Latencies - Wait Events for RAC - Common RAC Tuning - Session and System Statistics - RAC specific V$ Views - Automatic Database Diagnostic Monitor for RAC 18. Managing High Availability of Services in a RAC Environment - Oracle Services - Services for Policy - and Administrator-Managed Databases - Creating Services - Managing Services - Use Services with Client Applications - Services and Connection Load Balancing - Services and Transparent Application Failover - Services and the Resource Manager 19. Upgrading and Patching RAC - Overview of Upgrades and Patching - Rlease and Patch Set Upgrades - PSU, CPU and Interim Patches - Merge Patches - Performing Out Of Place Database Upgrades - Planning and Preparing for Upgrade - Performing Out of Place Release Install or Upgrade - Post Upgrade Tasks 20. Application Continuity - What is AC? - What problem does it solve? - Benefits of AC - How AC works - AC Architecture - Side Effects - Restrictions - Application requirements 21. Design for High Availability - Causes of Planned and Unplanned Down Time - Oracle’s Solution to Down Time - RAC and Data Guard - Maximum Availability Architecture - Fast-Start Failover - Hardware Assisted Resilient Data - Database High Availability Best Practices - RAID Configuration for High Availability 22. Oracle Database Exadata Cloud Service Overview - Introducing Exadata Cloud Service - Service Configuration Options & Service Connection Options - Service Architecture & Availability - Management Responsibilities - Storage Configuration & Management Details - Simple Web-Based Provisioning & Management - REST APIs - Migrating to Exadata Cloud Service
- Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
- Configure RMAN for the RAC environment
- Gain an understanding of the Oracle Database Exadata Cloud Service
- Understand effect of node failure in Flex Clusters
- Understand the scope and capabilities of what-if command evaluation
- Perform the different types of what-if command evaluation
- Install Grid Infrastructure for Standard and Flex clusters
- Configure ASM disk groups
- Perform the prerequisite steps for extending a cluster
- Describe the benefits of Oracle RAC
- Convert a single-instance Oracle database to RACs
- Understand Flex Clusters architecture and components
- Define redo log files in a RAC environment
- Define undo tablespaces in a RAC environment
- Start and stop RAC databases and instances
- Modify initialization parameters in a RAC environment
교육비는 부가세 포함
한국트레이노케이트(주) 대표 : 김 효 용
사업자등록번호 : 709-88-02461
통신판매업신고번호 : 2024-서울금천-0771호
주소 : 서울시 금천구 가산디지털1로 168 우림라이온스밸리 B동 1206호
대표전화 : 02-558-1130
이메일 : help@trainocate.co.kr
Copyright ⓒ 2024 TRAINOCATE Korea All rights reserved.
