Important Note:
The third set of courses:
Oracle19c RAC+DG production practice (3): Oracle19c RAC DataGuard construction 2+1
1、 Introduction to Oracle19c RAC+DG production project (RHEL8+cloud architecture version) series of courses
Oracle19c RAC+DG production project practice (RHEL8+cloud architecture version), a total of 4 sets of courses of Fenggeben topic involve Oracle19c+RHEL Linux 8. x stand-alone, Oracle19c RAC cluster, Oracle19c RAC+DG 2+1 disaster recovery, Oracle19c RAC+DG 2+2 disaster recovery, etc. The project architecture of this series of courses is as follows:
Welcome to:
51CTO School Oracle/MySQL/SQLServer database learning dedicated QQ group: 787523185、 602580662
2、 Oracle19c RAC+DG production project (RHEL8+cloud architecture version) series, Fenggeben series outline is as follows:
The first set: Oracle19c RAC+DG production practice (1): Oracle19c for RHEL8 installation configuration+patch
Address: https://edu.51cto.com/course/24371.html
1.1) Environment planning of Oracle19c RAC+DG production practice series courses
1.2) Installation of Oracle19c database RHEL 8.1 Linux operating system
1.3) Oracle19c database Linux 8 related operating system parameter configuration
1.4) Install oracle 19c database software
1.5) Configure oracle 19c database listening
1.6) Create oracle 19c database
1.7) Create Oracle19c PDB Plug Database
1.8) Setting and operation after Oracle19c installation
1.8.1) Start and stop of oracle 19c
1.8.2) View and check oracle 19c logs
1.8.3) Oracle 19c PDB/CDB login and use
1.8.4) Later parameter settings after oracle 19c installation
1.8.5) Using Oracle 19c EM Manager
1.8.6) Oracle 19c database archiving and flashback settings
The second set: Oracle19c RAC+DG production practice (2): Oracle19c RAC for Linux8 installation+patch
Address: https://edu.51cto.com/course/24370.html
2.1) Environment planning of Oracle19c RAC+DG production practice series courses
2.2) RHEL8.1 operating system installation required for Oracle19c RAC
2.3) Oracle19cRAC parameter configuration based on Linux 8 operating system
2.4) Oracle19c RAC user group and environment variable settings
2.5) Installation and configuration of Oracle19c RAC shared storage
2.6) Installation of Oracle19c GRID cluster software based on Linux8
2.7) Oracle19c RAC creates asm disk group
2.8) Installation of Oracle19c db cluster software based on Linux8
2.9) Creation of Oracle19c cloud database based on Linux8
2.10) Create Oracle19c RAC PDB Plug Database
2.11) Oracle19c RAC Start Stop and Cluster Commands
2.11.1) Oracle 19c RAC Stop Operation
2.11.2) Oracle 19c RAC Startup Operation Procedure
2.11.3) View and check Oracle 19c RAC logs
2.11.4) Common commands for Oracle 19c RAC cluster
2.12) Oracle 19c RAC PDB/CDB connection
2.13) Oracle19c RAC later parameters and archive settings
2.14) Oracle19c Client Installation Configuration
2.15) Oracle19c RAC cluster test (load balancing, failover)
The third set: Oracle19c RAC+DG production practice (3): Oracle19c RAC DataGuard construction 2+1
Address: https://edu.51cto.com/course/24369.html
3.1) Oracle19c RAC DataGuard production practice series practice environment planning
3.2) Configuration of Oracle19c RAC DataGuard disaster tolerance Linux platform
3.2.1) RAC configuration of Oracle19c RAC DataGuard master database
3.2.2) Oracle19c RAC DataGuard standby database stand-alone configuration
3.2.3) Creation process of Oracle19c RAC cloud architecture DataGuard (2+1)
3.3) Oracle19c RAC DataGuard daily inspection and operation test
3.3.1) Oracle19c RAC starts Active DataGuard mode
3.3.2) Oracle19c RAC starts DataGuard data synchronization
3.3.3) Oracle19c RAC DataGuard daily inspection
3.3.4) Oracle19c RAC DataGuard data synchronization test
3.4) Oracle19c RAC DataGuard temporary tablespace problem handling
3.5) Daily maintenance management of Oracle19c RAC DataGuard
3.5.1) Archive retention policy in DataGuard backup recovery
3.5.2) DataGuard start/stop database in RAC environment
3.5.3) RAC DataGuard active/standby switchover process
The fourth set: Oracle19c RAC+DG production practice (4): Oracle19c RAC DataGuard construction 2+2
Address: https://edu.51cto.com/course/24368.html
4.1) Oracle19c RAC DataGuard production practice series practice environment planning
4.2) Configuration of Oracle19c RAC DataGuard disaster tolerance Linux platform
4.2.1) RAC configuration of Oracle19c RAC DataGuard master database
4.2.2) Oracle 19c RAC DataGuard standby database RAC configuration
4.2.3) Creation process of Oracle19c RAC cloud architecture DataGuard (2+2)
4.3) Oracle19c RAC DataGuard daily inspection and operation test
4.3.1) Oracle19c RAC starts Active DataGuard mode
4.3.2) Oracle19c RAC starts DataGuard data synchronization
4.3.3) Oracle19c RAC DataGuard daily inspection
4.3.4) Oracle19c RAC DataGuard data synchronization test
4.4) Daily maintenance management of Oracle19c RAC DataGuard
4.4.1) Configuring cluster resources for DataGuard in RAC environment
4.4.2) Archive retention policy in DataGuard backup recovery
4.4.3) DataGuard start/stop database in RAC environment
4.4.4) RAC DataGuard active/standby switchover process
3、 Fengge Oracle/MySQL/NoSQL training class series courses (system, case, actual combat)
one ） Oracle Cloud database engineer training course _ Study Guide _ Career planning _ treatment
Free audition: https://edu.51cto.com/course/7015.html
Registration consultation: https://edu.51cto.com/mic-position/131.html
two ） MySQL Database Engineer Training Course _ Study Guide _ Career planning _ treatment
Free audition: https://edu.51cto.com/course/7015.html
Registration consultation: https://edu.51cto.com/mic-position/303.html
three ）Dual database (Oracle+MySQL) Sharing of series of training courses one point five (regularly updated)
http://www.fgedu.net.cn/oracle.html
#########################################################################################
Oracle Training Course Series
------------------------------------
Oracle Database Tutorial (Part I): Oracle of Linux Getting Started
Features: The content of this stage is Linux Introduction basis, yes Oracle The threshold is to learn the necessary skills.
https://edu.51cto.com/topic/1112.html
Oracle Database Tutorial (Part II): Oracle Installation configuration and cluster implementation
Features: Part of the content of this stage is OCP/OCM The course content, guided by the enterprise's actual combat projects, is more practical.
https://edu.51cto.com/topic/1113.html
Oracle Database Tutorial (Part III): Oracle Deep foundation and core technology
Feature: The depth of the course at this stage has exceeded OCP/OCM Course content, part of which is used for training Oracle primary
Senior after-sales engineer of the factory.
https://edu.51cto.com/topic/1114.html
Oracle Database Tutorial (Part IV): Oracle Backup recovery and data migration
Features: the practicability of this stage has exceeded OCP/OCM Course content, a large number of cases of backup and recovery, RAC
Environment ASM Daily maintenance and migration of.
https://edu.51cto.com/topic/1115.html
Oracle Database Tutorial (Part V): Oracle Object management and SQL Basics
Features: The content of this stage is OCP Course content, but practical OCP Courses.
https://edu.51cto.com/topic/1116.html
Oracle Database Tutorial (Part VI): Oracle Performance optimization and tuning
Features: most of the contents in this stage are OCM Course content, but practical OCM Certification courses involving thousands W series
According to the quantity.
https://edu.51cto.com/topic/1117.html
Oracle Database tutorial (Part 7): Oracle Disaster tolerance implementation and data replication
Features: most of the contents in this stage are OCM Course content, but practical OCM Certification courses involving thousands W series
According to the quantity.
https://edu.51cto.com/topic/1118.html
Oracle Database Tutorial (Part VIII): Application System Comprehensive Project
Features: The content of this stage is Oracle The value-added skills middleware application technology of database is Oracle Database engineer's
Comprehensive skills are also necessary for job competition and * *.
https://edu.51cto.com/topic/1120.html
Oracle Database Tutorial（ twelve point two New class): Oracle 12cR2 Project practice series
(Features: The content of this stage is Oracle 12.2 The new technology of database is Oracle Skills of cloud database project.)
https://edu.51cto.com/topic/1293.html
MySQL training course series
#######################################################################
MySQL Database Tutorial (Part I): MySQL Database Prerequisites Linux Basic series
https://edu.51cto.com/topic/1564.html
MySQL Database Tutorial (Part II): MySQL Basic Introduction to Database and Project Practice
https://edu.51cto.com/topic/1429.html
MySQL Database Tutorial (Part III): MySQL data base SQL Language Development and Application Practice
https://edu.51cto.com/topic/1475.html
MySQL Database Tutorial (Part IV): MySQL Deep database foundation and core analysis
https://edu.51cto.com/topic/1498.html
MySQL Database Tutorial (Part V): MySQL Database backup and recovery practice
https://edu.51cto.com/topic/1524.html
MySQL Database Tutorial (Part VI): MySQ L High availability replication and distributed cluster architecture
https://edu.51cto.com/topic/1622.html
The course of this stage is the current Internet main architecture, involving multiple servers, nearly 100 databases W The project experiment of the level data volume.
MySQL Database tutorial (Part 7): MySQL Performance optimization and fault diagnosis
https://edu.51cto.com/mic-position/303.html
MySQL Database Tutorial (Part VIII ++ ）： NoSQL Database（ Redis 、 MongoDB 、 Memcached ）
Please watch Brother Zhufeng MySQL Micro position training class
#########################################################
Other database courses of Brother Feng
#######################################################################
one ） PostgreSQL Database training course : https://edu.51cto.com/course/22644.html
two ） GreenPlum Database training course : https://edu.51cto.com/course/23050.html
three ） IBM DB2 Database training course : https://edu.51cto.com/course/23448.html
four ） SQLServer Database training course : https://edu.51cto.com/course/23927.html
five ） GaussDB Database training course : https://edu.51cto.com/course/22140.html
