Oracle 21c DBA: Installation, Multitenancy & Recovery

Oracle 21c DBA: Installation, Multitenancy & Recovery free download

Become Oracle 21c Database Administrator with command on installation, configuration, admin, arch, CDB, PDB, backup, etc

A warm welcome to the Oracle 21c DBA: Installation, Multitenancy & Recovery course by Uplatz.

Oracle 21c is the latest release in Oracle's database management system, offering a variety of new features and enhancements aimed at improving performance, security, and scalability. It provides powerful tools for database administrators (DBAs) to manage complex databases with ease, offering advanced capabilities for installation, multitenancy, and recovery.

Oracle 21c is designed to meet the growing demands of modern enterprises and provide high availability, improved performance, and cutting-edge capabilities for database management. Its features and tools help DBAs streamline tasks, improve security, and ensure data integrity across both on-premises and cloud environments.

Course Objectives

• Understanding the Database Architecture can help you execute your DBA job more effectively.

• Install the Oracle software and database that you'll need.

• Administrate database user accounts.

• Manage Tablespaces to ensure that enough space is available for data backup and recovery.

• Diagnose the issues and, if necessary, collaborate with Oracle Support.

• Configure the Listeners so that users may interact with one another.

Oracle 21c DBA: Installation, Multitenancy & Recovery - Course Curriculum

1. Installation of Oracle Linux 8 on Oracle VM

2. Introduction to Oracle 21c DBA

3. Oracle 21c Architecture

4. Practice 1 - Creating a CDB

5. Practice 2 - Creating PDBs from the Seed

6. Practice 3 - Performing Basic CDB Administration Tasks

7. Practice 4 - Managing Common and Local Users

8. Practice 5 - Backup and Recovery in CDB and PDBs

9. Practice 6 - Flashback and Point-in-time Recovery

Installation in Oracle 21c

Installing Oracle 21c involves the following key steps:

1. Pre-installation:

   • Ensure that your system meets Oracle's hardware and software prerequisites.

   • Configure necessary operating system packages and settings.

   • Set up the Oracle Grid Infrastructure (if required).

2. Oracle Database Installation:

   • Download the Oracle 21c installation files from Oracle’s website.

   • Use the Oracle Universal Installer (OUI) for a graphical or command-line installation.

   • The installation can be done either on a single instance or in a RAC (Real Application Clusters) setup, depending on scalability needs.

3. Post-installation Configuration:

   • After installation, configure network services, storage options, and listeners.

   • Perform database creation using tools like Database Configuration Assistant (DBCA).

   • Configure Oracle's automatic backup and recovery settings.

Multitenancy in Oracle 21c

Oracle 21c continues to build on its multitenant architecture, which allows DBAs to manage multiple databases (pluggable databases, or PDBs) within a single container database (CDB).

1. Multitenant Benefits

   • Resource Sharing: Multiple databases can run on a single Oracle instance, reducing overhead and improving resource utilization.

   • Isolation and Security: Each PDB is isolated, ensuring that each tenant’s data and configurations are secure.

   • Simplified Management: Centralized management of databases, including patching and upgrades, is simplified with the multitenant architecture.

2. Key Features

   • Unified Backup and Recovery: Oracle 21c allows simplified backups and restores across the container and pluggable databases.

   • PDB Relocation: Pluggable databases can be easily moved between container databases, offering greater flexibility for DBAs.

   • PDB Seed: A base template for quickly creating multiple pluggable databases.

Recovery in Oracle 21c

Oracle 21c introduces several enhancements in the realm of data recovery and disaster recovery:

1. Automated Recovery with Oracle Flashback

   • Oracle Flashback technology enables DBAs to easily recover data at any point in time without requiring traditional database restores.

   • Flashback Table and Flashback Drop help DBAs roll back specific tables or undo dropped objects, making recovery seamless and faster.

2. RMAN (Recovery Manager) Enhancements

   • RMAN in Oracle 21c allows for more flexible and efficient backups and recovery processes, including automated disaster recovery options.

   • Backup Compression and Encrypted Backups are supported to improve storage efficiency and security.

3. Data Guard & Active Data Guard

   • Oracle Data Guard allows for real-time disaster recovery, creating and maintaining standby databases for failover.

   • Active Data Guard enables read-only access to the standby database while still ensuring protection.

Key Features of Oracle 21c

1. AutoML (Automated Machine Learning)

   • Oracle 21c integrates AutoML features, allowing non-expert users to run machine learning algorithms directly in the database for predictive analytics.

2. Blockchain Tables

   • A new feature enabling tamper-evident tables that can store blockchain-style data for secure auditing and tracking.

3. In-Memory Enhancements

   • Enhanced In-Memory Database capabilities for faster query execution, reducing latency for OLAP queries.

4. Improved JSON Support

   • Enhanced support for JSON documents, making it easier to work with non-relational data within Oracle databases.

5. Sharding and Distributed Databases

   • Oracle 21c provides built-in support for horizontal scaling of databases using sharding technology, which can be useful for large-scale applications.

6. Database Autotuning

   • Enhanced autotuning capabilities to improve database performance by automatically adjusting configurations based on workload patterns.

7. New Data Types

   • Support for more data types, including spatial, JSON, and XML, to cater to a variety of use cases in modern applications.

How Oracle 21c Works

Oracle 21c operates as a powerful relational database management system (RDBMS) that allows DBAs and developers to handle large volumes of structured and unstructured data. With advanced features such as multitenancy, sharding, machine learning integration, and blockchain tables, Oracle 21c offers tools for high scalability, availability, and performance optimization.

Key components that help Oracle 21c work efficiently:

• Database Instance: Contains memory structures and background processes required to manage databases.

• Data Storage: Oracle’s data storage is optimized for both performance and reliability.

• SQL/PLSQL: Oracle 21c relies on SQL for data manipulation and PL/SQL for procedural programming.

Benefits of Oracle 21c

1. Scalability: Oracle 21c supports large-scale databases, multitenant configurations, and sharding for horizontal scaling.

2. Performance Optimization: Enhanced in-memory processing, autotuning, and optimized data access speed up query performance and reduce response times.

3. High Availability: Features like Oracle Data Guard, Flashback, and automated failover ensure uptime and disaster recovery.

4. Security: Advanced security features such as blockchain tables and encryption provide secure data storage and audit trails.

5. Cloud-Ready: Oracle 21c offers cloud integration, making it ideal for hybrid cloud environments.

6. Ease of Management: Tools like Oracle Enterprise Manager (OEM) and RMAN simplify administrative tasks such as monitoring, backup, and recovery.

7. Cost Efficiency: Oracle 21c reduces operational costs with features like automated backups, auto-scaling, and centralized database management.