|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-21c-dba-database-administration/
课程评论：没有评论
课程总结：Oracle 21c DBA：安装、多租户与恢复 欢迎参加Uplatz提供的《Oracle 21c DBA：安装、多租户与恢复》课程。Oracle 21c是Oracle数据库管理系统的最新版本，具有多项新功能和增强功能，旨在提升性能、安全性和可扩展性。该课程旨在帮助数据库管理员（DBA）轻松管理复杂数据库，并提供关于安装、多租户管理以及数据恢复的先进能力。 课程目标包括： - 理解数据库架构，以更有效地执行DBA工作。 - 安装所需的Oracle软件和数据库。 - 管理数据库用户帐户。 - 管理表空间，以确保数据备份和恢复的空间充足。 - 诊断相关问题并与Oracle支持协作。 - 配置监听器，以便用户之间能够互相交互。 课程大纲涵盖了以下内容： 1. 在Oracle VM上安装Oracle Linux 8 2. Oracle 21c DBA简介 3. Oracle 21c架构 4. 实践一：创建CDB 5. 实践二：从种子创建PDB 6. 实践三：执行基本CDB管理任务 7. 实践四：管理通用和本地用户 8. 实践五：CDB和PDB中的备份与恢复 9. 实践六：闪回及时间点恢复 主要内容细分如下： - **安装Oracle 21c**：包括前期准备、Oracle数据库安装和后期配置，以满足系统对硬件和软件的要求，并进行网络服务和Oracle自动备份配置。 - **多租户管理**：Oracle 21c的多租户架构允许DBA在单个容器数据库（CDB）内管理多个可插拔数据库（PDB），实现资源共享、安全性、简化管理等优势。 - **恢复增强**：引入了自动恢复功能、RMAN增强、数据保护和实时灾难恢复，使数据恢复过程更加高效和便捷。 - **新兴特性**：如自动化机器学习（AutoML）、区块链表、内存增强、JSON支持、分片及分布式数据库等，进一步增强了数据库的功能与安全性。 Oracle 21c不仅提供高可用性、性能优化和安全性功能，还支持云集成，适用于混合云环境，并通过Oracle企业管理器（OEM）和RMAN简化了管理任务，为DBA提供了更高的工作效率和成本效益。
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 ObjectivesUnderstanding 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 CurriculumInstallation of Oracle Linux 8 on Oracle VMIntroduction to Oracle 21c DBAOracle 21c ArchitecturePractice 1 - Creating a CDBPractice 2 - Creating PDBs from the SeedPractice 3 - Performing Basic CDB Administration TasksPractice 4 - Managing Common and Local UsersPractice 5 - Backup and Recovery in CDB and PDBsPractice 6 - Flashback and Point-in-time RecoveryInstallation in Oracle 21cInstalling Oracle 21c involves the following key steps: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).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.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 21cOracle 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).Multitenant BenefitsResource 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.Key FeaturesUnified 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 21cOracle 21c introduces several enhancements in the realm of data recovery and disaster recovery:Automated Recovery with Oracle FlashbackOracle 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.RMAN (Recovery Manager) EnhancementsRMAN 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.Data Guard & Active Data GuardOracle 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 21cAutoML (Automated Machine Learning)Oracle 21c integrates AutoML features, allowing non-expert users to run machine learning algorithms directly in the database for predictive analytics.Blockchain TablesA new feature enabling tamper-evident tables that can store blockchain-style data for secure auditing and tracking.In-Memory EnhancementsEnhanced In-Memory Database capabilities for faster query execution, reducing latency for OLAP queries.Improved JSON SupportEnhanced support for JSON documents, making it easier to work with non-relational data within Oracle databases.Sharding and Distributed DatabasesOracle 21c provides built-in support for horizontal scaling of databases using sharding technology, which can be useful for large-scale applications.Database AutotuningEnhanced autotuning capabilities to improve database performance by automatically adjusting configurations based on workload patterns.New Data TypesSupport for more data types, including spatial, JSON, and XML, to cater to a variety of use cases in modern applications.How Oracle 21c WorksOracle 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 21cScalability: Oracle 21c supports large-scale databases, multitenant configurations, and sharding for horizontal scaling.Performance Optimization: Enhanced in-memory processing, autotuning, and optimized data access speed up query performance and reduce response times.High Availability: Features like Oracle Data Guard, Flashback, and automated failover ensure uptime and disaster recovery.Security: Advanced security features such as blockchain tables and encryption provide secure data storage and audit trails.Cloud-Ready: Oracle 21c offers cloud integration, making it ideal for hybrid cloud environments.Ease of Management: Tools like Oracle Enterprise Manager (OEM) and RMAN simplify administrative tasks such as monitoring, backup, and recovery.Cost Efficiency: Oracle 21c reduces operational costs with features like automated backups, auto-scaling, and centralized database management.
