Rac Management (cluster components, performance monitoring and adjustment, node management, backup and recovery)

If you are interested in this course, you can add my QQ2059055336 to contact me.

This course mainly introduces the Oracle RAC architecture and working mechanism, and understands and master the related technologies under the RAC database, such: cache Fusion, Failover, load balance, FAN, OCR, Voting disk, etc., through the VMWARE virtual environment, practice the installation and deployment of RAC databases, routine performance monitoring of RAC databases, backup and recovery, instance addition and deletion, and patch installation, based on the knowledge of RAC theory, trainees can master the routine management operations of RAC databases.

Course outline

Lecture 1: oracle rac Architecture

RAC Architecture

Introduction to Automatic Storage Managerment

Install, configure, and manage RAC tools

Lecture 2: oracle rac Planning

Verify System Environment

Plan the server environment

Configure the Network Environment

Configure the installation path and shared storage

Lecture 3: Installing rac and database software

Prepare the oracle physical Installation File

Install cluster software under the oracle grid infrastructure architecture

Install database software and create a database

Lecture 4: Managing oracle database instances and rac Databases

Oracle RAC Database Management

Oracle RAC initialization parameters

Oracle RAC Storage Management

Lecture 5: Managing oracle cluster components

Cluster stack operations

Manage VotingDisks

Back up and restore OCR

Change OCR Configuration

Solve OCR Problems

Lecture 6: Managing backup and recovery

RAC database backup and recovery Overview

About RAC mode Fast Recovery Area

Archive redo logs of the RAC Database

Prepare backup and recovery operations

Back up the RAC Database

Prepare to reset and restore the RAC Database

Recover a RAC Database

Manage backup files

Lecture 7: Adjust the RAC database load

Oracle service

Database Resource Manager

Oracle RAC High Availability framework

Fast Application Notification (FAN)

Load Balancing Advisory

Connection Load balancing

Use EM for Service Management

Use the cluster to manage the Database Service Page

Lecture 8: monitoring performance and Problems

Diagnose and handle configuration problems in the RAC Environment

Optimize Oracle RAC

Lecture 9: Adding and deleting nodes and Instances

Prepare new nodes and verify the conditions that the nodes meet

Add a new node to the Cluster

Create an instance in the new node

Delete an instance from a cluster Database

Remove a node from a cluster

Lecture 10: Managing oracle software and application Patches

Patch Maintenance

Prepare available patches

Application patches and patch Sets

Ii. Project Practice:

1. RAC environment deployment and check

2. RAC software and database installation

3. rac ocr and Voting DISK backup and recovery

4. RMAN backup of the RAC Database

5. Start and Stop srvctl of the RAC instance

6. Start and Stop the crsctl of the RAC component

7. LBA and FAILOVER configurations

8. add and delete instance nodes