Complete Oracle Database Administration course (19C,21C)
- Descrição
- Currículo
- FAQ
- Revisões
After completing this Complete Oracle Database Administration course (19C,21C) course you will become a confident Database Administrator and will be ready to jump start your career.
You get hands-on experience in the most common administration tasks. You will create and configure Oracle Database Server for the real-world production scenario (in 99% there is no GUI on production servers). We will go the extra mile and implement different backup strategies, perform numerous restore operations in the Oracle Database Backup&Recovery section of the course. We don’t forget about Patching operations. Because these operations are required to comply with information security policies. And we will have many more interesting assignments.
According to the U.S. BUREAU OF LABOR STATISTICS employment of database administrators is projected to grow 15 percent from 2019 to 2029, much faster than the average for all occupations. Growth in this occupation will be driven by the increased data needs of companies across the economy. After the pandemic the demand doubles.
The long-term support Oracle Database 19c version was chosen for this course to teach you the database administration skills. It provides the highest level of release stability and longest duration of support and bug fixes, giving you the most stable platform for your applications.
At the end of the course, we will learn different ways to Upgrade from the 19c to 21c version. Upgrades are crucial to satisfy business high growing demands for the new features released in the new product versions. All operation manuals provided for the 19c version still work on 21c.
-
5Important MessageTexto
-
6Create and configure Virtual machine in VirtualBox ManagerVídeo Aula
-
7Download and Install Oracle Linux on VMVídeo Aula
In this Lecture we will install Oracle Linux on your VM server:
Extract the content of the Oracle Linux Installation.zip file and follow step by step instructions to complete the below tasks:
- How to download Oracle Linux boot image?
- How to boot your VM from Oracle Linux boot image?
- How to complete Oracle Linux Installation?
-
8SOFTWARE SILENT INSTALLATIONVídeo Aula
-
9License WarningTexto
-
47What can go wrong?Vídeo Aula
-
48What should you configure in DB?Vídeo Aula
-
49RMANVídeo Aula
-
50Backup TypesVídeo Aula
-
51Backup pieces, sets and image copiesVídeo Aula
-
52RMAN configurationVídeo Aula
-
53Create a Full DB backupVídeo Aula
-
54Create an Incremental DB backupVídeo Aula
-
55Backup StrategiesVídeo Aula
-
56Backup ScriptsVídeo Aula
-
57Schedule Backup ScriptsVídeo Aula
-
58Viewing BackupsVídeo Aula
-
59Remove RMAN BackupsVídeo Aula
-
60Manage Archived Redo Logs with RMANVídeo Aula
-
61Detect Data Corruption with RMANVídeo Aula
-
62Recovery DecisionVídeo Aula
-
63Restore lost Control FileVídeo Aula
-
64Recover from the lost Redo Log FileVídeo Aula
-
65Understand Complete and Incomplete RecoveryVídeo Aula
-
66High Level Procedure for the Recovery with RMANVídeo Aula
-
67Recover PDBVídeo Aula
-
68PDB PITRVídeo Aula
-
69Recover CDBVídeo Aula
-
70CDB PITRVídeo Aula
-
71CheckpointVídeo Aula
-
72Instance RecoveryVídeo Aula
-
73Instance MTTRVídeo Aula
