회사이미지

Global Vendors Training

Home > Global Vendors Training > 전체교육일정

Oracle

Oracle Database 12c R2: Clusterware & RAC Admin Accelerated

교육일정
교육기간
5일
교육금액
3,968,800원(부가세포함)
Oracle전체일정보기 수강신청

교육개요

* 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) 소프트웨어를 롤링 방식으로
둘 다 패치 하는 방법을 배웁니다.



교육목표

- 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



수강대상

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



기타

교육비는 부가세 포함