This series of courses is divided into,
0 - Theoretical knowledge part
0.1-oca_ocp_ocm related knowledge content (uploading)
1 - Installation part
1.1 Single instance command line installation
1.2 Single instance graphic installation
1.3 rac installation
1.4 rac (pdb architecture)+single instance installation of dg (dg is built using two methods of rman duplicate and rman backup)
1.5rac (pdb architecture) +Rac dg (dg is built using duplicate and backup of rman)
2 - Migration part
2.1 Migration between Single Instances
2.2 Single Real Estate Migration to rac
2.3 RAC migration to single instance
2.4 Migration between rac and rac.
2.5 Use of the migration method of xtts
3 - Recovery part
3.1 Single instance local recovery
3.2rac local recovery
4 - Database upgrade part
4.1 Upgrading from 19.3 to 19.13
4.2 12.1.0.2 Upgrade to 19.3
4.3 12.2.0.1 Upgrade to 19.3
4.4 Upgrade the rac of 19.3 to 19.13
5 - Database optimization
5.1 How to understand the implementation plan
5.2 What scenarios are the execution plans of hash, nest loop and merge applicable to?
5.3 Why do we use histograms? 19c histograms have french, balance, top french, hybrid, and what are the allowable buckets?
6 - Database asm disk operation part
6-1 How to migrate rac storage with one command.
6-2 How to migrate rac storage in a stupid way.
6-3 At present, the asm disk is at the external redundancy level. How to change it to the normal redundancy level.
7 - Database tools
7.1 How to install the oem, how to manage the database, and how to use it
7.2 How to use oem to monitor database
8-rac storage migration
There is a command solution to how to migrate rac storage, and there are also solutions in stupid ways. It is recommended that you learn both ways and make a comparison Among them, many methods involved in rac storage migration in a stupid way can be used in database management.
Chapter 11 One Command to Complete rac Storage Migration
Chapter 17 Storage Migration and Disk Redundancy Mode Modification of Oracle19rac
For details, please refer to the above 2 sections to understand the principles and methods.
9 - Comprehensive actual combat.
Database a is a single instance database of 11.2.0.3, with a capacity of 20T.
The b database is a pdb database in the 19.13 rac environment, with a capacity of only 21T
How to migrate the data of database a to the pdb database of database b?
This comprehensive practice is a test for everyone. It basically covers all aspects of database replication and installation, database dg, and database upgrade.
You can think about how to achieve it.
I. Course theme
Take everyone to practice hand in hand, and improve yourself in practice
Take you hand in hand to learn the ocm course of oracle 19. After learning this course, you can effectively improve the 3-5 level of oracle database.
And some actual combat videos and knowledge points can not be found in the market, such as actual combat 16
This practical course is broad, deep and refined. It can solve 96% of the students' database migration, upgrading and optimization problems.
If after watching all the videos, you think what I said is average, and the course is not as good as what I said, you can find customer service, return the original price to you, and let you go whoring for nothing.
If you think you speak well, with depth, breadth and precision, please leave your valuable feedback and evaluation so that I can further improve myself.
Recently, some students reported that the documents were incomplete, so I sorted them out again.
In addition, the training documents for SQL optimization and database upgrade of the original Oracle engineers in 2023 will be uploaded.
The original factory upgrade training video can alone Find me.
Database installation software, rhel7.9 image, 19.13 patch tool, cluster patch, database patch, ojvm patch download address
Link: https://pan.baidu.com/s/1z-wKpOWqrs4-2zD8XzfbeQ?pwd=t5i6
Extraction code: t5i6
Add practical courses on May 11, 2023
1 - How to build a dual node dg of rac from rac to pdb architecture through the backup of rman.
2 - How to complete the migration of rac storage with one command,
2.1 Explain how to divide some hard disks into servers
2.2 How to zone a SAN switch
2.3 How the server recognizes the stored hard disk.
2.4 Why can Oracle migrate rac storage with one command.
2023-06-04 Add practical courses
1-How to view official oracle documents
Common knowledge points of 2-rac database disk group.
2.1 How to create external, normal, high redundancy mode disk groups.
2.2 How to identify system level disks for asm disk group 1
2.3 How to identify system level disks for asm disk group 1
2.4 In the lsdg command, how are Free_MB, Req_mir_free_MB, Usable_file_MB calculated?
2.5 What is the difference between the disk groups created below?
create diskgroup data3 normal REDUNDANCY
failgroup data3_fg1 disk '/dev/mapper/data6','/dev/mapper/data7'
failgroup data3_fg2 disk '/dev/mapper/data8','/dev/mapper/data9'
create DISKGROUP data3 NORMAL REDUNDANCY
DISK '/dev/mapper/data9','/dev/mapper/data6','/dev/mapper/data7','/dev/mapper/data8'
2.6 How to scientifically increase the capacity of disk groups?
3 - Linux server and windows server backup script
Add practical courses on July 30, 2023
This course is highly recommended. There is no second one on the market. It is a complete production practice.
This course includes the silent installation of 11203, cloning of 11203, upgrading 11203 to 11204,
11204 is upgraded to 19c, and 19c is configured as a pdb database.
It includes all the knowledge points learned previously.
Add practical courses on August 29, 2023
Actual combat task
Demand 1:
two Database servers (rac) Of 3par The storage is old and needs to be changed from 3par Migrate to new storage, such as Dell's power store Store above.
Demand 2:
Or database data,arch,ocr Wait until the disk is external, You need to change the disk to normal.
Where the database is two Node's rac , and is pdb data base
Actual combat environment
19crac Of pdb Schema Database
2023-09-12 Add practical courses
How to identify the hard disk allocated by the storage server for 1-2 newly launched database servers
2 - How to zone two storage switches according to wwn
3 - Why and what is the essence of zoning.
4 - How to create the host of the database server in the management interface of the storage server.
5 - How to draw virtual volume from storage?
6 - How to map the storage volume to the database server?
7 - How does the database server recognize the volumes mapped by storage?
8 - How does the database server create storage volumes as asm disk groups?
2023-10-18 Add practical courses
1-where a like '% hello%' How to walk the index (involving full-text indexing and scheduled jobs)
2-where a like '% hello' How to go to the index
3 - Production practice, business requirements are as follows
A table 200G contains the data of the last five years. The table contains clob fields. Through query, it is found that clob fields occupy 190G of space.
The consulting business found that this table only has insert operations, and it can only retain the production data of the last three months.
The solution is as follows.
3-1 Use online redefinition to modify this table to be a partition table and an interval partition table.
3-2 Compress the clob field of the table in the process of online redefinition (the actual combat shows that the 100G table is about 10G after compression)
3-2 Because this table needs to be redefined online as an interval partition table, but this table does not have a time column, it needs to create a virtual column of the table.
3-4 After online redefinition as interval partition, delete the partition before 3. Pay attention when deleting, otherwise the table index is easy to invalidate
3-5 What should be paid attention to in the online redefinition process (there is extra space, there is extra temporary space, and the fields of the interval partition cannot have null values)
3-6 What is the difference between interval partition and range partition? Can they be converted to each other?
2023-10-22 Add practical courses
How do 1-rhel7 and rhel8 upgrade openssl and the version of openssh to the latest version.
II. Course Features
learn oracle , find Ah Wei
Ah Wei's product must be a boutique
Start from the actual combat, close to the actual combat, and improve yourself in the actual combat
Give a man a fish and you feed him for a day. Teach him how to fish and you feed him for a lifetime.
Making friends is worth the money and full of sincerity
Take care of the course and present your own pit in operation and maintenance to everyone after refining your knowledge
Explain the refined essence knowledge to everyone, and never waste your time and energy. I hope you can start from scratch. Step by step simulation of actual combat, if you encounter knowledge points that you don't understand, you can consult, so that we can learn together, progress together, and work hard for the great rejuvenation of the Chinese nation.
Choose Viagra, never let you down, let's go in both directions, learn together and make progress together.
This practical course will be updated from time to time. After summarizing the practical operations in the production process, it will be explained to everyone. At the same time, it is also a form of precipitation and accumulation of knowledge. During the irregular update process of the video, the chapters may be confused. After the video update is completed, the chapters will return to normal. I hope my video can help you. We can also communicate with each other at any time about the problems encountered in the actual combat. I look forward to your valuable comments and true ideas, so that I can provide you with better and better content in the future recording.
III. Course content
0. Theoretical knowledge part (uploading...)
0.1 Database monitoring (dynamic monitoring, static monitoring, multiple IPs listening to 1521 at the same time, and one IP listening to multiple service_name)
What is the difference between set rename datafile and alter database rename datafile in 0.2rman command?
0.3
............
1. Database single instance installation
1.0 Installation inspection
1.0.1 Inspection of installation package
1.0. 2 Modify system parameters
1. zero 3 Database user creation
1.0.4 Create Directory
1.0.5 Uploading and installing software package
1. zero 6 Modify oracle user environment variables
1.1 Installation of oracle 19c single instance database in rhel7 system graphics
1.2 Command line installation of rhel7 system
1.2.0 Command line installation of database software
1.2.1 The command line creates a non cdb database instance
1.2.2 Command line to create cdb database example
2. rac database installation
1. Presentation of course completion results
1.1 Using the workstation, install a production environment of rhel7+oracle19c+rac+multipath+shared storage+DNS server+DNS client+NTP server+NTP client
1.2 How to apply rac patches for oracle 19c (including GI patches, oracle patches, database patches, OJVM patches, bug patches)
2. Install openfiler software to simulate shared storage+configure multi-path access
2.1 Installing the openfiler software
2.2 Configure openfiler software (configure two virtual network cards and two HBA cards of the simulation server)
2.3 Creating an ocr Disk
2.4 Creating mgmt disks
2.5 Creating Data File Disks
2.6 Creating Archive Log Disks
3. Install 2 database servers
3.1 Install two database servers RHEL7.5
3.2 Configure Server Dual Network Card Binding+Configure Server Heartbeat
4. Install multi-path software to identify disks in shared storage
4.1 Installing the server's local yum source
4.2 Install iscsi software, configure multi-path configuration files, and identify disks in shared storage
4.3 Identifying ocr disks
4.4 Identifying mgmt disks
4.5 Identifying Data File Disks
4.6 Identifying archive log disks
5. Official description of rac environment system parameters of oracle19c
5.1 How to configure the system parameters of oracle 19c rac (we refer to the official instructions)
5.2 Oracle19c+rac Environment Best Practices Official Description Document
6. Preparations before installing oracle19c+rac
6.1 Modify the/etc/hosts file
6.2 Configure DNS server+DNS client+NTP server+NTP client
6.3 Creating Users and Groups
6.4 Creating a directory
6.5 Modifying User Environment Variables
6.6 Installation of relevant software packages
6.7 Configuring SSH Mutual Trust
6.9 Disable Server Transparent Pages
7. Install oracle+19c+rac software
7.1 Installing GI Software
7.2 Create ASM disks, mainly data file disks and archive log disks
7.3 Installing database software
7.4 Creating Database Instances
7.5 Common daily cluster maintenance commands (start and stop the database, start and stop the cluster, check the monitoring, teach students how not to memorize commands, and the commands are correct)
8. Patch
8.1 Apply operating system patches for GI and ORACLE
8.2 Apply OJVM patch
8.3 Apply ORA600 bug patches
9. Course summary and achievement demonstration
9.1 Course summary and achievement demonstration
3. rac+dg (single instance) database installation (pdb architecture, Including how to use the duplicate command and backup of rman )
3.1.1 Explanation of dg knowledge points
3.1.2 Configure dg monitoring, password file and parameter file.
3.1.2 Use the duplicate command of rman to build dg 1.
3.1.3 Build dg through the duplicate command of rman 2
3.1.4 Configuration required for database switching.
3.1.5 Normal switch over of database
3.1.6 How to fail over the database
3.1.7 Fast recovery of dg through flashback after failure of dg library
3.1.8 After the failure of the dg database, quickly recover the dg through the control file of the new main database
3.1.9 How to solve the lack of backup database archiving.
3.1.10 Can recover database and recover standby database be used in dg?
3.1.11 How to build a dg through the backup of rman.
3.1.12 How to solve the service problem that the dg database cannot listen to the pdb database using static listening?
4. Practical steps of rac+rac dg (pdb architecture, including how to use the duplicate command and backup of rman)
5.19c Single instance database uses rman backup for different machines Migrate to a single instance data base
5.1 Data, archive and control file backup through backup script
5.2 Archive and control file backup through backup script
(Note that the backup directory of the source library is/backup/db and/backup/ar)
5.3 Transfer backup files to the target database
(Transfer the backup file to the/home/oracle/bk directory of the target library)
5.4 Use parameter file to start database to nomount
5.5 Restore the control file with the backup set and start the database to mount
5.6 Restore database
5.6.1 Register the backup set of the target database to the control file
5.6.2 Start the database to the mount status, and determine the serial number of the recover database
5.7recover database
5.7.1 Recover database through rman
5.7.2 Recover database through the SQL command line;
5.8. Open Database
5.8.1 After the database is opened, the sys user cannot listen to the login remotely
5.8.2 Modify database dynamic parameters to start the database
5.9. Extension of Backup
5.9.1 How to know which archives are in the Backup Set
5.9.2 How to extract archives from these Backup Sets
5.9.3 How to apply archiving step by step when migrating databases from different machines, and how to continue to apply archiving after opening the read only database
5.9.4 Why open read only should be used for early open verification.
5.10. Supplement to rman migration backup
5.10.1 How to set data files and online log generation paths in rman.
Similar to the following command
run {
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
set newname for datafile 1 to"/oradata/HELLO/system01.dbf";
set newname for datafile 8 to"/oradata/HELLO/pdbseed/undotbs01.dbf";
set newname for datafile 9 to"/oradata/HELLO/pdb/system01.dbf";
set newname for tempfile 2 to"/oradata/HELLO/pdbseed/temp012023-03-09_06-36-52-383-AM.dbf";
SQL"ALTER DATABASE RENAME FILE ''/u01/app/oracle/oradata/HELLO/redo03.log'' to ''/oradata/HELLO/redo03a.log''";
SQL"ALTER DATABASE RENAME FILE ''/u01/app/oracle/oradata/HELLO/redo02.log'' to ''/oradata/HELLO/redo03b.log''";
SQL"ALTER DATABASE RENAME FILE ''/u01/app/oracle/oradata/HELLO/redo01.log'' to ''/oradata/HELLO/redo03c.log''";
restore database;
}
6. Single instance database has no data loss and is migrated to rac database through rman backup
And rac database are migrated to rac database through rman
6.1 Single instance source database upgrade
Upgrade the source database of 19.3 to version 19.13 (including database patches and ojvm patches)
6.2. Transfer the backup file to the target database
Transfer the backup files to the/home/oracle/bk directory of the target library
6.3. Use the parameter file to start the database to nomount
6.4. Restore the control file using the backup set, and start the database to mount
6.5. Restore Database
Register the target library backup set to the control file
Start the database to the mount status, and determine the serial number of the recover database
6.6.recover database
Recover database through rman
Recover database through the sql command line;
6.7. After the single instance database is restored, configure it as a rac database
Register database to cluster
Modify database parameter file to asm
6.8. Migrate the rac database to the rac database.
What is the difference between migrating a single instance database to a rac and migrating a rac database to a rac.
According to the above theory, implement the rac database recovery to rac
The 7rac database is recovered to a single instance database through rman without database loss
8 How to use one command to migrate rac database storage
9 Database local recovery series
7.1 Local Recovery of Single Instance Database
7.2 Local recovery of rac database
10 Comprehensive actual combat
7.1 Practical subject:
There is a single instance database A in 11.2.0.3 with a capacity of 20T and no backup.
How to migrate to the newly built rac environment B (database version is 19.13), and migrate to the rac pdb database, and the asm capacity of the rac database is only 21T
The knowledge points included in this actual battle.
1 - How to copy the software of database A in environment B must be copied, because database A has many patches in 11.2.0.3. If 11.2.0.3 software is installed, the version will be inconsistent.
2 - How to build a single instance dg of 11.2.0.3.
How to solve the problem of missing 3-dg archives.
4 - How to upgrade 11.2.0.3 single instance to 11.2.0.4 single instance
5 - How to upgrade 11.2.0.4 single instance to 19.3 single instance
6 - How to upgrade a 19.3 single instance to a 19.13 single instance.
7 - How to migrate 19.13 single instance database to 19.13 rac pdb database.
11 Database upgrade series
8.1 Upgrade the single instance 19c database to version 19.13.
8.2 Upgrade the single instance 12.2.0.1 database to 19.13.
8.3 Upgrade the single instance 12.1.0.2 database to version 19.13.
8.4 Upgrade the 19c database rac to version 19.13.
We strongly recommend the course, which covers all the knowledge points learned previously, and involves database cloning, database 1120311204, 19c upgrade and other knowledge points
https://edu.51cto.com/course/34285.html
Single instance 11203 database migration and upgrading to rac database of 19c [19 class hours in total] _OOracle course-51CTO class
For some students' feedback that there is no document, the document has been uploaded.
Thank you for your support and love, and we will upload more high-quality content to you later.