Oracle Database Administration from Zero to Hero

1. Welcome to the Course!

In this video, we will warmly welcome you to the course and provide an overview of what you can expect to learn. You will get acquainted with the instructor and the course format. Additionally, we will outline the benefits of the course and how it can help you enhance your skills and knowledge in the subject matter. This video will set the stage for your exciting learning experience.

1. Practice - Preparing Course Practice Environment (Part 1 of 2)

In this video, you will learn how to install the required software on your hosting PC, create an Oracle Linux 7 64-bit virtual machine, configure its network settings, and clone the seed virtual machine. Additionally, we will demonstrate how to set up a connection to srv1 in Putty.

2. Practice - Preparing Course Practice Environment (Part 2 of 2)

In this video, we will continue our practice of setting up the course environment by demonstrating how to create a Windows-based virtual machine. If you already have a Windows-based VirtualBox appliance that you can use for this course, you can use it and skip this section.

1. Introducing the Section

In this video, we will take a sneak peek into the learning objectives of this section.

2. Overview of RDBMS (Part 1 of 2)

In this video, you will learn about the basics of RDBMS, including its features, SQL, and the different RDBMS products available in the market.

3. Overview of RDBMS (Part 2 of 2)

In this video, we will understand the different architecture types and application types of RDBMS.

4. Overview on Oracle Database (Part 1 of 2)

In this video, we will explore the different Oracle database releases, the difference between Long Term Support Releases and Innovation Releases, and the Oracle Database Cloud Services.

5. Overview on Oracle Database (Part 2 of 2)

In this video, you will learn about the different Oracle database editions and license options available.

6. Overview on Oracle Database Technologies

In this video, we will describe the different Oracle database technologies, options, and management packs.

7. About Oracle Database Administrator (DBA)

In this video, we will understand the role of an Oracle Database Administrator (DBA), the DBA duties and responsibilities, the different DBA role types, the learning path for becoming a DBA, and the demand for DBAs in the job market.

1. Introducing the Section

In this video, we will take a sneak peek into the section learning objectives and give an overview of the topics we will be covering.

2. Introducing Oracle Database Architecture (Part 1 of 2)

In this video, you will learn about the major components of the database instance in Oracle database architecture, including their functions and how they work together.

3. Introducing Oracle Database Architecture (Part 2 of 2)

In this video, you will learn about the major Oracle database files, including their purpose, types, and locations.

4. Introducing Database Tablespaces and Data Files

In this video, you will learn about database tablespaces and data files, including their structure, types, and usage in Oracle database architecture.

1. Introducing the Section

In this video, we will take a sneak peek into the section learning objectives and give an overview of the topics we will be covering.

2. Oracle DB Software Installation (Part 1 of 2)

In this video, you will learn how to prepare the systems for Oracle database software installation, including the necessary prerequisites and considerations.

3. Oracle DB Software Installation (Part 2 of 2)

In this video, we will perform the actual database software installation on both Linux and Windows platforms. We will also discuss the Oracle Inventory Directory and its significance.

4. Practice - Installing Oracle Database Software in Linux

In this Practice video, you will learn how to install Oracle database 19c software into the srv1 Linux platform. You will create a response file and then use it to install the software.

5. Practice - Installing Oracle Database Software in Windows

In this Practice video, you will learn the process of installing Oracle database software on the Windows platform, specifically focusing on the winsrv environment.

6. Creating an Oracle Database (Part 1 of 3)

In this video, you will learn how to create an Oracle database using the 19c software. We will cover the necessary steps for preparing the software installation and perform the installation itself.

7. Creating an Oracle Database (Part 2 of 3)

In this video, we will discuss the planning phase for database creation, including considerations such as database structure, storage, and configuration.

8. Creating an Oracle Database (Part 3 of 3)

In this video, we will continue the process of creating an Oracle database by exploring topics such as responding to the DBCA window, working with sample schemas, dropping Oracle databases, and following guidelines for creating Oracle databases.

9. Practice - Creating Oracle Databases (Part 1 of 2)

In this Practice video, we will create an Oracle database in the Linux platform (srv1) using the knowledge and skills acquired in the previous videos.

10. Practice - Creating Oracle Databases (Part 2 of 2)

In this Practice video, we will create an Oracle database in the Windows platform (winsrv) by applying the concepts and techniques learned earlier.

11. Oracle Database Management Tools

In this video, we will explore common Oracle database management tools, including SQL*Plus, SQL Developer, EM Express, Oracle Enterprise Manager Cloud Control, and Database Management Cloud Service. We will understand their functions and how they can assist in administering Oracle databases.

12. Practice - Using SQLPlus

In this practice video, we will familiarize ourselves with using the SQLPlus utility, an essential tool for interacting with Oracle databases and executing SQL statements.

13. Practice - Using SQL Developer

In this practice video, we will download and install SQL Developer, a graphical tool provided by Oracle, which enhances the database administration and development experience on the hosting PC.

1. Introducing the Section

In this video, we will take a sneak peek into the section's learning objectives and provide an overview of the topics we will be covering.

2. Starting Up and Shutting Down Database Instances

In this video, you will learn how to start up and shut down Oracle database instances using various options. We will also discuss best practices for shutting down a production system in a work environment.

3. Practice - Starting Up and Shutting Down DB Instances

In this Practice video, you will gain hands-on experience with starting up and shutting down Oracle database instances. We will explore different startup and shutdown modes commonly used in Oracle databases.

4. Database Initialization Parameters (Part 1 of 2)

In this video, we will discuss database initialization parameters, including the database parameter file and their management. You will learn how to configure and modify these parameters to optimize your database performance.

5. Database Initialization Parameters (Part 2 of 2)

In this video, we will dive deeper into database initialization parameters. We will explore the attributes associated with these parameters and cover topics such as creating PFILE (parameter file) and SPFILE (server parameter file).

6. Practice - Managing Initialization Parameters, SPFILE, and PFILE

In this Practice video, you will perform hands-on tasks related to managing Oracle database initialization parameters, SPFILE, and PFILE. You will gain practical experience in configuring and manipulating these components effectively.

7. Introducing Data Dictionary

In this video, we will introduce the concept of the data dictionary in Oracle Database. You will learn about dynamic performance views and data dictionary views, and how to query them to retrieve valuable information about the database.

8. Practice - Querying Data Dictionary

In this Practice video, you will learn how to retrieve specific information about an Oracle database by querying dynamic performance views and data dictionary views. You will gain hands-on experience in extracting meaningful insights from the data dictionary.

9. Using Oracle Database Documentation (Part 1 of 2)

In this video, we will explore common Oracle database documentation books and their usage. You will learn about valuable resources that can enhance your understanding of Oracle database and assist you in your administrative tasks.

10. Using Oracle Database Documentation (Part 2 of 2)

In this video, we will demonstrate how to effectively use Oracle database documentation to find relevant information and solutions to various database administration scenarios. You will learn how to navigate and utilize the documentation efficiently.

1. Introducing the Section

In this video, we will take a sneak peek into the learning objectives of this section. We will provide an overview of the topics covered and highlight the key concepts related to Oracle Database Multitenancy.

2. Oracle Database Multitenant Architecture (part 1 of 2)

In this video, we will explore the Oracle Database Multitenant architecture. You will learn about the differences between the Container Database (CDB) and Pluggable Databases (PDB), as well as gain an understanding of the components involved in Multitenant databases.

3. Oracle Database Multitenant Architecture (Part 2 of 2)

In this video, we will dive deeper into the Oracle Database Multitenant architecture. You will learn how to utilize Data Dictionary Views and V$ Views in CDBs, understand the common files in CDBs, differentiate between local users and common users, create a Multitenant database (CDB) using DBCA, and grasp the concept of shared undo and local undo configuration.

4. Practice - Creating a CDB Database

In this practice video, you will gain hands-on experience by dropping the database in srv1 and creating a Container Database (CDB) in its place. You will learn the practical steps involved in setting up a CDB environment.

5. Creating PDBs (Part 1 of 2)

In this video, we will cover the process of creating Pluggable Databases (PDBs). You will understand the prerequisites for PDB creation and explore methods such as using DBCA and SQL Developer to create PDBs.

6. Creating PDBs (Part 2 of 2)

In this video, we will continue our exploration of creating Pluggable Databases (PDBs). You will learn additional techniques, including creating PDBs using the CREATE PLUGGABLE DATABASE statement, creating PDBs from the Seed Container, cloning a Local PDB, and dropping a PDB.

7. Practice - Creating PDBs

In this practice video, you will gain hands-on experience creating PDB databases from the seed using two different methods. You will create PDBs using SQL*Plus and the DBCA, allowing you to practice multiple approaches to PDB creation.

8. Basic Multitenant Administration Tasks

In this video, we will explore basic administration tasks specific to Multitenant databases. You will learn how to switch the current container, change CDB and PDB states, save the PDB open state, manage initialization parameters in PDBs, and change the global database name of a PDB.

9. Practice - Performing Basic CDB Admin Tasks

In this practice video, you will gain hands-on experience by performing various basic administration tasks in a Container Database (CDB). You will modify the states of the CDB and PDBs, modify PDB restart states, modify a parameter in a PDB, and change the global database name of a PDB.

1. Introducing the Section

In this video, we will provide a brief overview of the topics covered in this section. You will gain insights into the key concepts and learning objectives related to managing Oracle database components.

2. Database Memory Concepts (Part 1 of 2)

In this video, we will delve into the database memory concepts. You will learn about the database buffer cache and its significance in optimizing database performance.

3. Database Memory Concepts (Part 2 of 2)

In this video, we will continue exploring database memory concepts. We will cover the shared pool, large pool, and redo log buffer, and understand how different application types impact the allocation of memory in the database.

4. Managing Database Memory (Part 1 of 2)

In this video, we will focus on managing database memory. You will learn how to enable Automatic Memory Management (AMM) and leverage the Automatic Shared Memory Management (ASMM) feature.

5. Managing Database Memory (Part 2 of 2)

In this video, we will further explore database memory management techniques. You will learn how to enable manual shared memory management, monitor the automatic memory management, and tune memory using advisors.

6. Practice - Managing Database Memory (Part 1 of 2)

In this practice video, you will gain hands-on experience by implementing Automatic Memory Management (AMM) on srv1. You will practice the steps involved in configuring and managing database memory using the AMM feature.

7. Practice - Managing Database Memory (Part 2 of 2)

In this practice video, you will continue exploring database memory management by implementing Automatic Shared Memory Management (ASMM) on srv1. You will practice configuring and fine-tuning shared memory components using ASMM.

8. Database Storage Structures

In this video, we will focus on database storage structures. You will learn how to describe different database storage structures and specify the database standard block size.

9. 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.

10. Managing Tablespaces (Part 2 of 4)

In this video, we will delve into managing tablespaces. You will learn about Oracle-Managed Files (OMF), how to enable them, and how to obtain information about tablespaces.

11. 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.

12. Managing Tablespaces (Part 4 of 4)

In this video, we will further discuss the management of tablespaces. You will learn how to alter tablespace availability, make tablespaces read-only or read-write, and assign specific quota on tablespaces to users.

13. Practice - Managing Tablespaces (Part 1 of 2)

In this practice video, you will gain hands-on experience managing Oracle database storage structures, specifically tablespaces. You will examine segments, extents, and data blocks and practice managing tablespaces.

14. Practice - Managing Tablespaces (Part 2 of 2)

In this Practice video, you will continue your exploration of managing tablespaces by exploring CDB tablespaces and datafiles. You will gain practical experience in working with tablespaces and datafiles within a Container Database (CDB).

15. Managing Data Files

In this video, we will focus on managing data files within an Oracle database. You will learn how to resize data files, alter data file availability, rename and relocate data files, and drop a data file.

16. Practice - Managing Data Files

In this practice video, you will implement various tasks involved in managing data files in Oracle databases. You will practice relocating data files online and offline and removing unavailable data files from a container.

17. Managing Resumable Space Allocation (Part 1 of 2)

In this video, we will explore the concept of resumable space allocation. You will learn how to describe resumable space allocation, enable it, and understand its benefits.

18. Managing Resumable Space Allocation (Part 2 of 2)

In this video, we will continue our discussion on managing resumable space allocation. You will learn about operations that can be made resumable, setting the resumable space allocation timeout interval, using triggers to control resumable mode, and general practices related to resumable space allocation.

19. Practice - Managing Resumable Space Allocation

In this practice video, you will gain hands-on experience by implementing the steps involved in managing resumable space allocation. You will practice the techniques for enabling and managing resumable space allocation in an Oracle database.

20. Managing Undo Data (Part 1 of 3)

In this video, we will dive into managing undo data within an Oracle Database. You will learn about the benefits of undo, tasks involved in undo space management, and setting undo management parameters and retention.

21. Managing Undo Data (Part 2 of 3)

In this video, we will continue exploring the management of undo data. You will learn how to tune undo data and leverage the undo advisor for performance optimization.

22. Managing Undo Data (Part 3 of 3)

In this video, we will further discuss managing undo data. You will learn how to enable undo guarantee, enable temporary undo, and choose between shared or local undo modes.

23. Practice - Managing Undo Data

In this practice video, you will gain hands-on experience performing common tasks involved in managing undo data within an Oracle database. You will examine and analyze undo statistics, activate the Undo Advisor, and calculate the required undo size manually.

1. Introducing the Section

In this video, we will provide an overview of the topics covered in this section. You will get a sneak peek into the learning objectives related to managing database segments.

2. Shrinking Segments (Part 1 of 2)

In this video, you will learn about shrinking segments. You will understand the ROWID pseudocolumn and segment defragmentation, which are essential for optimizing storage space utilization.

3. Shrinking Segments (Part 2 of 2)

In this video, we will continue our exploration of shrinking segments. You will learn how to shrink database segments, deallocate unused space, and move a table from its current location to improve segment utilization.

4. Practice - Shrinking Segments

In this practice video, you will learn by doing. You will create a testing table, intentionally make it fragmented, and then practice shrinking the segments to reclaim unused space.

5. Using Deferred Segment Creation

In this video, we will delve into the concept of deferred segment creation. You will understand how to leverage deferred segment creation to optimize space utilization and materialize database segments efficiently.

6. Practice - Using Deferred Segment Creation

In this practice video, we will gain hands-on experience with deferred segment creation in an Oracle database. You will examine the behavior of deferred segment creation and understand its impact on segment management.

7. Using Table Compression (Part 1 of 2)

In this video, we will explore the usage of table compression techniques. You will learn about basic compression and how to describe and apply it to optimize storage space.

8. Using Table Compression (Part 2 of 2)

In this video, we will continue our discussion on table compression. You will learn about advanced compression techniques, obtain information about compression used in a database, and understand the Oracle Hybrid Columnar Compression (HCC) feature.

9. Practice - Using Table Compression

In this practice video, we will deepen our understanding of table compression by examining scenarios where basic compression and advanced compression techniques are effective. You will gain practical experience in applying compression to tables.

1. Introducing the Section

In this video, we will provide an overview of the topics covered in this section. You will get a sneak peek into the learning objectives related to managing database users and security.

2. Managing Database Users (Part 1 of 2)

In this video, you will learn about managing database users. You will understand the concepts of database users and schemas and explore predefined accounts in Oracle.

3. Managing Database Users (Part 2 of 2)

In this video, we will continue our exploration of managing database users. You will learn how to create a database user with database authentication, convert a user to a schema-only account, manage tablespace quotas for users, and remove database users.

4. Managing User Privileges (Part 1 of 2)

In this video, we will delve into managing user privileges. You will understand the difference between system and user privileges and learn how to manage system privileges.

5. Managing User Privileges (Part 2 of 2)

In this video, we will continue our discussion on managing user privileges. You will learn how to manage object privileges and understand the cascading effects in system and object privileges.

6. Managing Roles (Part 1 of 2)

In this video, we will explore the usage of roles in managing database users. You will understand the purpose of using roles, list predefined roles, and learn how to create and use roles.

7. Managing Roles (Part 2 of 2)

In this video, we will continue our discussion on managing roles. You will learn how to use password-protected roles, understand the usage of the PUBLIC role, drop roles, obtain information about granted privileges and roles, and follow guidelines for using roles and privileges.

8. 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 how to use user profiles.

9. Managing User Profiles (Part 2 of 2)

In this video, we will continue our exploration of managing user profiles. You will learn how to enable password complexity verification functions, obtain information about user passwords and profiles, implement gradual password rollover for applications, and understand general guidelines for using user profiles.

10. Practice - Managing Users and User Security (Part 1 of 2)

In this practice video, we will apply the knowledge gained in managing database users and user security. You will perform common tasks involved in managing database users and roles, with a focus on implementing a simple example.

11. Practice - Managing Users and User Security (Part 2 of 2)

In this practice video, we will continue our hands-on practice with managing users and user security. You will check the user account tablespace quota and manage user password settings using user profiles.

12. Managing Local and Common Users

In this video, we will explore the concepts of local and common users. You will understand the difference between these user types, learn how to create common and local users, grant privileges commonly and locally, and differentiate between common and local roles.

13. Querying Container Data Objects

In this video, we will focus on querying container data objects. You will learn how to query container data objects, set CONTAINER_DATA attributes for a common user, obtain information about CONTAINER_DATA attributes in a multitenant environment, and remove CONTAINER_DATA attributes for a user.

14. Practice - Managing Local and Common Users (Part 1 of 2)

In this practice video, we will deepen our understanding of managing local and common users in CDB and PDBs. You will perform tasks such as managing common users, local users, and common and local roles.

15. Practice - Managing Local and Common Users (Part 2 of 2)

In this practice video, we will continue our hands-on practice with managing local and common users. You will grant privileges as common or local and enable common users to view information about specific PDBs.

16. Applying the Principle of Least Privileges

In this video, we will discuss the importance of applying the Principle of Least Privileges in Oracle databases. You will understand the concept and best practices for granting minimal privileges to users.

17. Administrative Accounts and Privileges

In this video, we will explore administrative accounts and privileges. You will learn about the administrative accounts available in Oracle, understand the difference between SYSDBA and SYSOPER privileges, and differentiate between the SYS and SYSTEM accounts.

18. Using OS Authentication (Part 1 of 2)

In this video, we will delve into the usage of OS authentication in Oracle databases. You will understand the database administrator authentication and the concept of administrative OS authentication groups.

19. Using OS Authentication (Part 2 of 2)

In this video, we will continue our exploration of OS authentication. You will learn how to allow administrative OS authentication for OS users and create OS-authenticated normal users.

20. 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 authentication, and synchronize administrator passwords with the data dictionary.

21. Practice - Using Database Authentication Methods

In this practice video, we will reinforce our understanding of database authentication methods, specifically focusing on OS authentication and password file authentication in Oracle databases. You will examine OS authentication for administrative users, create and use password files, and explore OS authentication for non-administrative users.

1. Introducing the Section

In this video, we will provide an overview of the topics covered in this section. You will get a sneak peek into the learning objectives related to managing database connectivity.

2. Configuring Oracle Network Environment (Part 1 of 4)

In this video, you will learn about configuring the Oracle network environment. You will understand the Oracle Net Listener, the database connection cycle, and Oracle Net Configuration files.

3. Configuring Oracle Network Environment (Part 2 of 4)

In this video, we will continue our exploration of configuring the Oracle network environment. You will learn about Oracle Net Naming Methods and how to use them.

4. 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.

5. Configuring Oracle Network Environment (Part 4 of 4)

In this video, we will conclude our discussion on configuring the Oracle network environment. You will learn how to use the Listener Control Utility and register database services in the listener.

6. Practice - Configuring Oracle Network Environment (Part 1 of 4)

In this practice video, we will apply the knowledge gained in configuring the Oracle network environment. You will manage connections to Oracle databases and network configuration tools, with a focus on using Easy Connect and Local Naming Methods.

7. Practice - Configuring Oracle Network Environment (Part 2 of 4)

In this practice video, we will continue our hands-on practice with configuring the Oracle network environment. You will control the allowable connection naming methods and the Listener using lsnrctl.

8. Practice - Configuring Oracle Network Environment (Part 3 of 4)

In this practice video, we will further enhance our understanding of configuring the Oracle network environment. You will install the sample application, Swingbench.

9. 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.

10. Using Database Links (Part 1 of 2)

In this video, we will explore the usage of database links. You will learn about database links, their types, and users, as well as understand naming database links.

11. Using Database Links (Part 2 of 2)

In this video, we will continue our discussion on using database links. You will learn how to create database links, use them in synonyms, and understand using Global Name as a Loopback Database Link.

12. Practice - Using Database Links

In this practice video, we will reinforce our understanding of using database links. You will create and use a database link to the SOE schema in PDB1.

1. Introducing the Section

In this video, we will provide an introduction to the topics covered in this section. You will get a sneak peek into the learning objectives related to configuring the shared server.

2. Configuring Databases for Shared Server (Part 1 of 3)

In this video, we will begin our exploration of configuring databases for shared server mode. You will learn about the shared server architecture, its advantages, and the necessary steps to configure it.

3. Configuring Databases for Shared Server (Part 2 of 3)

In this video, we will continue our discussion on configuring databases for shared server mode. You will learn how to set up dispatcher configurations and configure clients to work with shared and dedicated servers.

4. Configuring Databases for Shared Server (Part 3 of 3)

In this video, we will conclude our coverage of configuring databases for shared server mode. You will understand the rules and considerations involved in altering the dispatcher configurations.

5. 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 the default shared server configuration, configure the shared server processes for the PDB1 service, and monitor the shared server processes.

1. Introducing the Section

In this video, we will provide an overview of the topics covered in this section. You will get a sneak peek into the learning objectives related to managing the FRA and the redo log.

2. Managing the Fast Recovery Area

In this video, we will delve into the management of the Fast Recovery Area (FRA). You will learn about the purpose of the FRA, its advantages, and how to enable and monitor it. Additionally, we will discuss best practices for effectively managing the FRA.

3. 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.

4. Managing the Redo Log (Part 1 of 4)

In this video, we will begin our exploration of managing the redo log in Oracle. You will learn about the significance of redo log files in both NOARCHIVELOG and ARCHIVELOG modes, as well as the writing cycle involved.

5. Managing the Redo Log (Part 2 of 4)

In this video, we will continue our discussion on managing the redo log. You will understand the differences between a clean shutdown and an abnormal shutdown, and gain insights into the instance recovery mechanism.

6. Managing the Redo Log (Part 3 of 4)

In this video, we will focus on the management of redo log groups and members. You will learn how to effectively manage these components to ensure reliable data recovery.

7. Managing the Redo Log (Part 4 of 4)

In this video, we will compare undo and redo data and explore the best practices for managing the redo log. You will gain a deeper understanding of the considerations and techniques for optimal redo log management.

8. Managing the Archived Redo Log Files (Part 1 of 2)

In this video, we will shift our attention to the management of archived redo log files. You will learn about the different archiving modes, compare NOARCHIVELOG and ARCHIVELOG modes, and discover how to set archive destinations.

9. Managing the Archived Redo Log Files (Part 2 of 2)

In this video, we will continue our exploration of managing archived redo log files. You will learn how to control the archived redo log file name format, change the database archiving mode, display the current archiving mode, and gain insights into best practices for managing these files.

10. 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 videos.

1. Introducing the Section

In this video, we will provide an overview of the topics covered in this section. You will get a sneak peek into the learning objectives related to taking backups in Oracle databases.

2. 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 recovery solutions.

3. 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.

4. 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.

5. Introduction to RMAN (Part 3 of 3)

In this video, we will delve deeper into RMAN command types, configuring persistent settings, and understanding the modes of issuing commands to RMAN. You will acquire essential skills for effectively utilizing RMAN in your backup and recovery tasks.

6. 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 CONTROL_FILE_RECORD_KEEP_TIME parameter.

7. Performing RMAN Full Backups - Part I (1 of 2)

In this video, we will explore different backup strategies, backup types, and backup modes. You will gain an understanding of the various RMAN backup types available for Oracle databases.

8. Performing RMAN Full Backups - Part I (2 of 2)

In this video, we will focus on performing full backups using RMAN. You will learn how to create whole database backups and partial backups, and how to specify a format for RMAN backups.

9. Practice - Performing RMAN Full Backups - Part I (1 of 2)

In this practice video, you will practice taking a whole database backup and enabling the ARCHIVELOG mode in the ORADB database using RMAN.

10. Practice - Performing RMAN Full 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.

11. Performing RMAN Full Backups - Part II (1 of 3)

In this video, we will focus on additional aspects of RMAN full backups. You will learn multiple options to backup control files and how to back up the SPFILE.

12. Performing RMAN Full Backups - Part II (2 of 3)

In this video, we will continue exploring RMAN full backups. You will learn how to back up archived redo logs, an essential component of the backup strategy.

13. Performing RMAN Full Backups - Part II (3 of 3)

In this video, we will cover advanced topics related to RMAN full backups. You will learn how to take backups as image copies, define device types in BACKUP commands, and use TAGs to organize RMAN backups.

14. 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.

15. Performing Incremental Backups (1 of 3)

In this video, we will introduce the concept of incremental backups. You will understand the difference between differential and cumulative incremental backups and their significance in the backup strategy.

16. Performing Incremental Backups (2 of 3)

In this video, we will focus on the practical aspects of performing incremental backups using RMAN. You will learn how to take incremental backups and implement incrementally updated backups.

17. 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.

18. Practice - Performing Incremental Backups

In this practice video, you will practice creating incremental backups and incrementally updated backups using RMAN.

1. Introducing the Section

In this video, we will provide an overview of the topics covered in this section. You will get a sneak peek into the learning objectives related to database recovery techniques and strategies.

2. Configuring RMAN Persistent Settings (Part 1 of 2)

In this video, we will focus on configuring RMAN persistent settings. You will learn how to set the RMAN backup retention policy, which determines how long backup data is retained.

3. Configuring RMAN Persistent Settings (Part 2 of 2)

In this video, we will continue exploring RMAN persistent settings. You will learn how to specify RMAN backup destinations at different levels and configure the archived redo log deletion policy.

4. 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.

5. Introducing RESTORE and RECOVER Commands

In this video, we will introduce the RESTORE and RECOVER commands in Oracle databases. You will learn about the difference between non-critical and critical data loss, understand the actions performed by these commands, and explore the steps to prepare a database for a recovery procedure.

6. Performing Recovery Part I - Performing Full Recovery

In this video, we will focus on performing full recovery in Oracle databases. You will learn the common pre-recovery actions and how to recover the whole database in both NOARCHIVELOG and ARCHIVELOG modes. Additionally, you will gain practical knowledge of performing full recovery on a user tablespace.

7. 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.

8. Performing Recovery Part II - Switching Data Files and Performing PITR (1 of 2)

In this video, we will delve deeper into database recovery techniques. You will learn how to recover datafiles by switching to image copies and understand the different levels of implementing Point-in-Time Recovery (PITR).

9. 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.

10. 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.

11. Automating RMAN Backup Jobs

In this video, we will explore the automation of RMAN backup jobs. You will learn how to create and schedule RMAN backup scripts in both Linux and Windows platforms, ensuring regular and consistent backups.

12. 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.

13. 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 effectively.

1. Introducing the Section

In this video, we will provide an overview of the topics covered in this section. You will get a sneak peek into the learning objectives related to using RMAN in Oracle Multitenant Databases.

2. Using RMAN in Oracle Multitenant Databases

In this video, we will explore the usage of RMAN in Oracle Multitenant Databases. You will learn how to differentiate between backup and recovery operations in CDBs and non-CDBs, use RMAN to perform backups of CDBs and PDBs, execute complete and incomplete recovery in CDBs and PDBs, and leverage the LIST and REPORT commands to gather information in a multitenant database.

3. 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 administrator to perform backup and restore operations.

4. 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 non-system datafile in a PDB, and perform Point-in-Time Recovery (PITR) in a PDB.

5. Duplicating a Database Using RMAN - Part I (1 of 3)

In this video, we will begin exploring the process of duplicating a database using RMAN. You will learn about different database duplication techniques and their implications.

6. Duplicating a Database Using RMAN - Part I (2 of 3)

In this video, we will continue our exploration of database duplication using RMAN. You will understand the prerequisites for database duplication and learn the procedure for duplicating a database.

7. Duplicating a Database Using RMAN - Part I (3 of 3)

In this video, we will further explore database duplication using RMAN. You will learn how to define duplicate database file locations, duplicate a database to a remote host, and duplicate a database into the same host.

8. Duplicating a Database Using RMAN - Part II (1 of 2)

In this video, we will delve deeper into database duplication using RMAN. You will learn how to perform active database duplication and backup-based database duplication with a connection to a target database.

9. Duplicating a Database Using RMAN - Part II (2 of 2)

In this video, we will continue exploring database duplication using RMAN. You will learn about backup-based duplication with a connection to a recovery catalog, backup-based duplication without a connection to a target or recovery catalog, duplicate one or more active PDBs, and how to restart a failed duplication process.

10. 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 PDBs using RMAN.

1. Using RMAN Recovery Catalog (Part 1 of 3)

In this video, we will explore the usage of the RMAN Recovery Catalog. You will learn about the differences between using the control file and Recovery Catalog as the RMAN repository. Additionally, you will discover how to create and manage recovery catalogs to enhance your RMAN operations.

2. Using RMAN Recovery Catalog (Part 2 of 3)

In this video, we will continue our exploration of the RMAN Recovery Catalog. You will learn how to manually resynchronize recovery catalogs and catalog files into the RMAN repository. These techniques will help ensure the integrity and accuracy of your recovery catalog data.

3. Using RMAN Recovery Catalog (Part 3 of 3)

In this video, we will focus on creating and managing stored scripts within the RMAN Recovery Catalog. You will discover how to leverage stored scripts to streamline and automate common RMAN tasks, enhancing the efficiency of your backup and recovery processes.

4. Practice - Using RMAN Recovery Catalog

In this practice video, you will apply your knowledge by performing general tasks involved in using the RMAN recovery catalog. Through practical exercises, you will gain hands-on experience in utilizing the recovery catalog effectively.

5. Using Data Recovery Advisor (Part 1 of 2)

In this video, we will introduce the Data Recovery Advisor and its role in the backup and recovery lifecycle. You will learn about the various stages of the Data Recovery Advisor and its significance in detecting and resolving data failures.

6. Using Data Recovery Advisor (Part 2 of 2)

In this video, we will dive deeper into the practical usage of the Data Recovery Advisor. You will learn how to utilize the Data Recovery Advisor to list data failures, check for corruption in datafiles, obtain recommendations for resolving failures, repair data failures, and manage failure status and priority.

7. 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 database.

1. Introducing the Section

In this video, we will provide an overview of the Flashback Database section. You will get a sneak peek into the learning objectives and topics covered in this section, giving you an overview of what to expect.

2. Flashback Database

In this video, we will dive into the details of Flashback Database. You will learn how to describe and configure Flashback Database, enabling you to perform point-in-time recoveries. Additionally, you will discover how to execute Flashback Database operations and effectively manage restore points to meet your data recovery needs.

3. 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 scenarios.

1. Introducing the Section

In this video, we will provide an introduction to the "Using Oracle Database Utilities" section. You will get a glimpse of the learning objectives and topics covered in this section, setting the foundation for what you will explore in the upcoming videos.

2. Using Oracle Data Pump (Part 1 of 3)

In this video, you will discover Oracle Data Pump, a powerful data movement utility. We will discuss the various data movement methods offered by Data Pump and how to use directory objects to enhance your data pump operations.

3. Using Oracle Data Pump (Part 2 of 3)

In this video, you will delve deeper into the practical usage of Oracle Data Pump. You will learn how to invoke Data Pump utilities from the command-line, understand Data Pump modes, and explore the basic parameters for exporting data.

4. Using Oracle Data Pump (Part 3 of 3)

In this video, we will continue our exploration of Oracle Data Pump. You will discover the essential parameters for importing data using Data Pump and learn how to implement parallelism to enhance the performance of your Data Pump operations.

5. Practice - Using Oracle Data Pump

In this practice video, you will apply your knowledge by implementing common tasks involved in using Oracle Data Pump utilities. Through hands-on exercises, you will gain practical experience in effectively utilizing Data Pump for data movement scenarios.

6. Using SQL Loader (Part 1 of 4)

In this video, we will introduce SQL Loader, a versatile utility for loading data into Oracle databases. You will learn about the target, components, and features of SQL Loader. Additionally, we will cover how to start SQL Loader and use command-line parameters for data loading operations.

7. Using SQL Loader (Part 2 of 4)

In this video, we will continue exploring SQL Loader. You will learn how to create SQL Loader control files and configure them for different loading scenarios. Understanding these techniques will enable you to effectively load data into your Oracle database using SQL Loader.

8. Using SQL Loader (Part 3 of 4)

In this video, we will further enhance your knowledge of SQL Loader by exploring additional control file configuration options. You will also learn how to use multiple INTO TABLE clauses to load data into multiple tables simultaneously.

9. Using SQL Loader (Part 4 of 4)

In this video, we will delve into more advanced topics of SQL Loader. You will learn how to specify the field list contents, utilize the POSITION keyword for precise data loading, understand the differences between SQL Loader loading methods, and install SQL Loader Case Studies to further expand your expertise.

10. 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 Loader.

11. Using External Tables

In this video, we will introduce External Tables, a powerful feature for accessing data in external files as if they were database tables. You will learn how to describe External Tables, use them with the ORACLE_LOADER driver for data loading, and leverage the ORACLE_DATAPUMP driver for data access.

12. 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 seamlessly access and manage data stored in external files.

1. Automating Tasks with the Scheduler

In this video, we will dive into the details of automating tasks using the Scheduler. You will learn about scheduler job attributes and how to create and manage time-based jobs to automate repetitive tasks. Additionally, you will discover how to manage scheduler programs and schedules, enabling you to set up customized automation workflows. We will also explore how to monitor Scheduler jobs by querying dictionary views, allowing you to keep track of the scheduled tasks and their execution status

2. 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, ensuring effective automation of tasks according to specific time-based requirements.

1. Introducing the Section

In this video, we will provide an introduction to the Using ADR Command Interpreter section. You will get a sneak peek into the learning objectives and topics covered in this section, giving you an overview of what to expect.

2. Using ADR Command Interpreter

In this video, we will delve into the details of using the ADR Command Interpreter. You will learn how to describe the fault diagnosability infrastructure and gain an understanding of problems and incidents in Oracle databases. Additionally, we will explore the Automatic Diagnostic Repository (ADR) and how to effectively use the adrci utility for diagnostics and troubleshooting. You will also discover how to package database incidents and set and apply ADR purging policies to manage diagnostic d

3. 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 and resolve database incidents and problems effectively.

1. Introducing the Section

In this video, we will introduce the "Applying Patches on Oracle Databases" section. You will get a sneak peek into the learning objectives and topics covered in this section, providing you with an overview of the importance of patching and the strategies involved.

2. 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 Oracle Critical Patch Update (CPU) program. Additionally, we will discuss patching strategies and methods for Oracle database versions prior to 12c R2.

3. Patching Oracle Databases (2 of 3)

In this video, we will continue our exploration of patching Oracle databases. You will gain an understanding of patch types for Oracle database 12c R2 and later versions, delve into Oracle database version numbers for 12c R2 and beyond, and learn about the differences between patching strategies for different versions.

4. Patching Oracle Databases (3 of 3)

In this video, we will cover advanced topics related to patching Oracle databases. You will understand the timeline for Release Update (RU) and Release Update Revision (RUR) patches, learn how to obtain the latest patches for Oracle databases, explore the general procedure for applying patches on non-RAC non-ASM databases, utilize OPatch for patch application, and query the patch inventory from SQL.

5. Practice - Applying RU Patches on Oracle Databases

In this practice video, you will gain hands-on experience by applying a Release Update (RU) patch on an Oracle database running version 19.3. Through practical exercises, you will learn how to effectively apply patches to your Oracle database, ensuring it remains up to date with the latest fixes and enhancements.

1. Introducing the Section

In this video, we will provide an introduction to the Automatic Storage Management (ASM) section. You will get a sneak peek into the learning objectives and topics covered in this section, giving you an overview of the importance and benefits of ASM in Oracle databases.

2. Introducing Automatic Storage Management (Part 1 of 3)

In this video, we will explore the fundamentals of Automatic Storage Management (ASM). You will learn about the concept of ASM and its benefits in managing storage within Oracle databases, ensuring improved performance, simplified administration, and increased data reliability.

3. 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, understanding their significance in managing storage resources effectively.

4. 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 Groups, explore the asmcmd utility for ASM management tasks, and migrate an existing database to ASM storage. These skills will empower you to leverage ASM to its full potential and streamline storage management in your Oracle database.

5. 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 creating virtual hard disks for ASM. These exercises will familiarize you with the initial steps of configuring ASM for your Oracle database.

6. 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 the required kernel parameter values. These exercises will guide you through the setup process, ensuring a smooth installation of Oracle Grid Infrastructure software.

7. 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 hands-on experience in setting up and configuring ASM storage for your Oracle database.

8. Practice - Creating Oracle Database with ASM (Part 4 of 4)

In this practice video, you will focus on practical tasks related to Oracle Restart and ASM. You will check the Oracle Restart components and their functionality, retrieve information about ASM, get started with asmcmd for ASM management operations, and create a tablespace in ASM. These exercises will reinforce your understanding of ASM administration and management tasks.

9. Practice - Applying RU Patches on Oracle Restart

In this practice video, you will learn how to apply a Release Update (RU) patch on an Oracle database that utilizes Automatic Storage Management (ASM). By following the step-by-step instructions, you will gain hands-on experience in keeping your Oracle database and ASM up to date with the latest patches and enhancements.

1. Introducing the Section

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 upgrading Oracle databases.

2. 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 upgrades, familiarize yourself with various Oracle database upgrade tools, and discover the features and benefits of the autoUpgrade utility.

3. Upgrading Oracle Databases (Part 2 of 2)

In this video, we will continue our exploration of upgrading Oracle databases. You will gain hands-on experience by upgrading a single-instance database on the same machine, learn how to monitor the upgrade process using the autoUpgrade console, and implement post-upgrade actions to ensure a smooth transition to the new Oracle database version.

4. 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 successfully upgrading your Oracle database to a newer release.

5. 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 upgrading the Grid Infrastructure component of your Oracle database environment.