Curated Video
Oracle Database Administration from Zero to Hero - Practice - Upgrading Oracle Grid Infrastructure
In this practice video, you will focus on upgrading the Oracle Grid Infrastructure configured on the server named srv1-asm from version 19c to version 21c. By following the provided instructions, you will gain practical experience in...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Upgrading Oracle Database
In this practice video, you will perform a practical exercise in upgrading an Oracle CDB database from version 19c to version 21c on the server named srv1. By following the step-by-step instructions, you will gain hands-on experience in...
Curated Video
Oracle Database Administration from Zero to Hero - Upgrading Oracle Databases (Part 1 of 2)
In this video, we will explore the first part of upgrading Oracle databases. You will learn about the different methods available for performing an upgrade, understand the Oracle database upgrade roadmap, prepare your database for...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing the Section-20
In this video, we will provide an introduction to the “Upgrading Oracle Databases†section. You will get an overview of the learning objectives and topics covered in this section, giving you insights into the importance and process of...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Creating Oracle Database with ASM (Part 3 of 4)
In this practice video, you will progress further in creating an Oracle database with ASM. You will create an ASM Disk Group, install Oracle database software, and create an ASM-based database. These exercises will provide you with...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Creating Oracle Database with ASM (Part 2 of 4)
In this practice video, you will continue working on creating an Oracle database with ASM. You will set up the required environment variables for the OS accounts, install the necessary ASM packages, create ASM disk volumes, and adjust...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Creating Oracle Database with ASM (Part 1 of 4)
In this practice video, you will gain hands-on experience in creating an Oracle database with ASM. You will perform tasks such as downloading Oracle Grid Infrastructure 19c software, setting up an Oracle VirtualBox appliance, and...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing Automatic Storage Management (Part 3 of 3)
In this video, we will cover advanced topics related to Automatic Storage Management (ASM). You will learn how to utilize ASM system privileges, start and stop components managed by Oracle Restart, create tablespace datafiles in ASM Disk...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing Automatic Storage Management (Part 2 of 3)
In this video, we will continue our exploration of Automatic Storage Management (ASM). You will gain knowledge about Oracle Restart, its description, and its installation process. We will also delve into ASM Disk Groups and ASM Disks,...
Curated Video
Oracle Database Administration from Zero to Hero - Patching Oracle Databases (1 of 3)
In this video, we will explore the patching process for Oracle databases. You will learn about different patch types for Oracle database versions prior to 12c R2, understand Oracle database version numbers, and gain insights into the...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Automating RMAN Backup Jobs (Part 2 of 2)
In this practice video, you will create automatic scheduled jobs that implement a sample database backup strategy on the Windows platform. You will apply the concepts learned in the previous video to automate RMAN backup jobs...
Curated Video
Oracle Database Administration from Zero to Hero - Performing Recovery Part II - Switching Data Files and Performing PITR (2 of 2)
In this video, we will continue exploring database recovery techniques. You will gain practical skills in performing database PITR, which allows you to recover your database to a specific point in time. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Performing Incremental Backups (3 of 3)
In this video, we will explore the configuration of Block Change Tracking (BCT) for incremental backups. You will understand how BCT improves the efficiency of backup operations. This clip is from the chapter "Taking Backups in Oracle...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Performing RMAN Backups - Part II
In this practice video, you will practice using multiple options to back up control files, produce backups as image copies, and utilize TAGs in RMAN backups. This clip is from the chapter "Taking Backups in Oracle Databases" of the...
Curated Video
Oracle Database Administration from Zero to Hero - Introduction to RMAN (Part 2 of 3)
In this video, we will continue our exploration of RMAN. You will learn how to start RMAN, connect it to a target database, and initiate backup and recovery operations. This clip is from the chapter "Taking Backups in Oracle Databases"...
Curated Video
Oracle Database Administration from Zero to Hero - Introduction to RMAN (Part 1 of 3)
In this video, we will introduce the Recovery Manager (RMAN) and its benefits. You will gain insights into the components of RMAN architecture and understand their roles in the backup and recovery process. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing Backup and Recovery
In this video, we will explore the fundamentals of backup and recovery in Oracle databases. You will learn about different categories of data failure, understand the backup and recovery roadmap, and compare the available Oracle database...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Managing the Fast Recovery Area
In this practice video, you will have hands-on experience examining the Fast Recovery Area (FRA) configured in the srv1 database. You will gain practical insights into the FRA management techniques discussed in the previous video. This...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Configuring Oracle Network Environment (Part 4 of 4)
In this practice video, we will conclude our hands-on practice with configuring the Oracle network environment. You will install the Oracle instant client and save the srv1 Current State Snapshot. This clip is from the chapter "Managing...
Curated Video
Oracle Database Administration from Zero to Hero - Configuring Oracle Network Environment (Part 3 of 4)
In this video, we will further explore configuring the Oracle network environment. You will learn how to test Oracle Net connectivity and use the Oracle Net Configuration Assistant. This clip is from the chapter "Managing Database...
Curated Video
Oracle Database Administration from Zero to Hero - Using Password File Authentication
In this video, you will learn about password file authentication. You will understand the concept, create a password file, set the REMOTE_LOGIN_PASSWORDFILE parameter, explore the relationship between OS authentication and password file...
Curated Video
Oracle Database Administration from Zero to Hero - Managing User Profiles (Part 1 of 2)
In this video, we will focus on managing user profiles. You will learn about the benefits of user profiles, explore password parameters and the password change lifecycle, understand resource limit parameters in user profiles, and learn...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Tablespaces (Part 3 of 4)
In this video, we will continue exploring the management of tablespaces. You will learn how to enlarge tablespaces, drop tablespaces, create or move tables into tablespaces, and create Bigfile tablespaces. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Tablespaces (Part 1 of 4)
In this video, we will cover the management of tablespaces. You will learn about different types of tablespaces and gain knowledge on creating permanent tablespaces. This clip is from the chapter "Managing Oracle Database Components" of...