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 - Practice - Using ADR Command Interpreter
In this practice video, you will apply your knowledge by executing common tasks involved in using the ADR command interpreter. Through hands-on exercises, you will gain practical experience in utilizing the ADR infrastructure to diagnose...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Automating Tasks with the Scheduler
In this practice video, you will gain hands-on experience by implementing common tasks involved in using the Scheduler in Oracle databases. Through practical exercises, you will apply your knowledge to set up and manage scheduled jobs,...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using External Tables
In this practice video, you will apply your knowledge by creating external tables using the ORACLE_LOADER and ORACLE_DATAPUMP access drivers. Through hands-on exercises, you will gain practical experience in utilizing External Tables to...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using SQL Loader
In this practice video, you will gain hands-on experience by implementing multiple data load scenarios using SQL Loader. Through practical exercises, you will learn how to efficiently load data files into your Oracle database using SQL...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Performing Flashback Database
In this practice video, you will gain hands-on experience by performing routine tasks involved in managing Flashback Database. Through practical exercises, you will strengthen your skills in utilizing Flashback Database for data recovery...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using Data Recovery Advisor
In this practice video, you will gain hands-on experience in using the Data Recovery Advisor. You will learn how to utilize the advisor to detect and repair the loss of data files, ensuring the integrity and recoverability of your...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Duplicating Databases and PDBs Using RMAN
In this practice video, you will apply your knowledge by performing multiple techniques to duplicate the database “oradb†in srv1 to another database on the same host. You will gain hands-on experience with duplicating databases and...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using RMAN in Oracle Multitenant Databases (Part 2 of 2)
In this practice video, you will continue practicing your skills in using RMAN in Oracle Multitenant Databases. You will implement recovery scenarios in CDBs and PDBs, recover the root and seed containers, recover from losing a...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using RMAN in Oracle Multitenant Databases (Part 1 of 2)
In this practice video, you will apply your knowledge by performing various tasks using RMAN in Oracle Multitenant Databases. You will use RMAN to create backup files of a CDB Database, take backups for a PDB, and enable a local PDB...
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 - Practice - Automating RMAN Backup Jobs (Part 1 of 2)
In this practice video, you will create automatic scheduled jobs that implement a sample database backup strategy on the Linux platform. You will apply the concepts learned in the previous video to automate RMAN backup jobs effectively....
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Performing Recovery Part II
In this practice video, you will practice further recovery scenarios on the ORADB database. You will apply the concepts learned in the previous videos to perform database recovery tasks effectively. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Performing Recovery Part I
In this practice video, you will practice specific recovery scenarios in the non-CDB database ORADB in srv1. You will apply the concepts learned in the previous video to perform database recovery tasks effectively. This clip is from the...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Configuring RMAN Persistent Settings
In this practice video, you will have hands-on experience with setting and testing RMAN persistent settings. You will apply the concepts learned in the previous videos to configure RMAN settings effectively. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Performing Incremental Backups
In this practice video, you will practice creating incremental backups and incrementally updated backups using RMAN. This clip is from the chapter "Taking Backups in Oracle Databases" of the series "Oracle Database Administration from...
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 - Practice - Performing RMAN Backups - Part I (2 of 2)
In this practice video, you will gain hands-on experience with taking database and tablespace backups online using RMAN. This clip is from the chapter "Taking Backups in Oracle Databases" of the series "Oracle Database Administration...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Introducing RMAN
In this practice video, you will have hands-on experience with RMAN. You will learn how to start RMAN, connect it to a target database, configure date and time formats, change persistent settings, and set the...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Enabling the ARCHIVELOG Mode
In this practice video, you will have the opportunity to enable the ARCHIVELOG mode in the database on srv1. You will also examine the generated archived redo log files, putting into practice the concepts discussed in the previous...
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 Databases for Shared Server
In this practice video, we will apply the knowledge gained in configuring databases for shared server mode. You will work with shared server processes in the database on srv1 for the PDB1 service. Specifically, you will learn how to test...