|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-database-administration-ii-exam-1z0-083-ocp-2023/
课程评论:没有评论
本课程“Oracle Database Administration II Exam: 1Z0-083 OCP 2024-25”是为准备Oracle数据库管理员认证考试而设计的。 **核心内容涵盖多租户架构、备份恢复、数据库部署升级及性能调优等多个关键领域。** **多租户架构管理(Oracle Database: Managing Multitenant Architecture Ed 1)** * **PDB创建与管理**: 学习如何配置和创建容器数据库 (CDB) 和可插拔数据库 (PDB),包括从CDB Seed创建PDB,理解PDB结构,管理PDB服务名、连接、启动关闭、可用性、模式和设置,以及使用Oracle Resource Manager控制资源使用。 * **备份与复制**: 掌握RMAN备份和恢复CDB及PDB的方法,包括主动PDB复制和数据库复制。 * **升级与传输**: 学习Oracle数据库的升级、数据传输以及Application PDBs的创建、管理(包括应用根和应用种子)、安装、升级、打补丁。还包括PDB和应用容器的克隆、插入和拔出操作,以及本地撤销模式与共享撤销模式的比较。 * **安全管理**: 学习多租户数据库的安全管理,包括PDB锁定配置文件、CDB和PDB用户审计,以及应用容器策略管理。 * **恢复与Flashback**: 学习使用RMAN进行数据库恢复,执行CDB和PDB Flashback操作。 **备份与恢复(Oracle Database: Backup and Recovery Workshop)** * **备份策略**: 讲解备份策略和术语,涵盖全量和增量备份恢复,RMAN备份压缩与加密,使用媒体管理器,创建多部分备份、双工备份集、归档备份、恢复文件备份,以及非数据库文件和ASM元数据的备份。 * **恢复概念**: 阐述Oracle数据库的恢复技术,用于应对崩溃、完全和时间点恢复。 * **Flashback技术**: 学习如何配置数据库以支持Flashback,并执行Flashback数据库操作。 * **数据库复制**: 学习使用RMAN复制数据库。 * **RMAN配置与使用**: 学习配置RMAN以实现可恢复性,配置和使用RMAN恢复目录。 * **故障诊断**: 学习检测和修复数据库块损坏,诊断各类数据库问题。 * **恢复执行**: 掌握RMAN数据库恢复,以及非RMAN数据库恢复。 * **数据传输**: 学习数据传输技术。 * **RMAN故障排除与调优**: 学习解释RMAN消息输出,诊断RMAN性能问题。 **部署、补丁与升级(Oracle Database: Deploy, Patch and Upgrade Workshop)** * **Grid Infrastructure和数据库安装**: 学习在独立服务器上安装Grid Infrastructure和Oracle数据库软件,包括使用DBCA创建、删除和配置数据库。 * **补丁更新**: 学习为Grid Infrastructure和Oracle数据库打补丁。 * **Grid Infrastructure升级**: 学习升级Oracle Grid Infrastructure。 * **Oracle Database 18c新特性**: 介绍Image和RPM 기반的数据库安装,以及DBCA创建数据库。 * **Oracle Restart**: 学习配置和使用Oracle Restart管理组件。 * **数据库升级**: 学习规划、执行Oracle数据库升级,以及执行升级后任务。 * **Rapid Home Provisioning**: 学习使用Rapid Home Provisioning。 * **Oracle Database 19c新特性**: 涵盖通用数据库增强、可用性增强(如使用Flashback Database)和可诊断性增强。 **性能调优(Oracle Database: Administration Workshop)** * **内存管理**: 管理内存组件。 * **AWR与ADDM**: 理解自动工作负载存储库 (AWR) 和自动诊断监视器 (ADDM)。 * **性能监控**: 监控等待事件、会话和服务,管理阈值和警报。 * **性能调优方法论**: 理解和应用性能规划和调优方法论。 * **SQL调优**: 理解Oracle优化器,使用SQL Tuning Advisor和SQL Access Advisor,管理优化器统计信息,理解SQL调优过程。 本课程全面涵盖了Oracle数据库在高可用性、可伸缩性和安全性方面的管理技能,是Oracle数据库专家认证之路的重要组成部分。
Creating CDBs and Regular PDBs - Oracle Database: Managing Multitenant Architecture Ed 1Configure and create a CDBCreate a new PDB from the CDB seedExplore the structure of PDBsManage CDBs and PDBs - Oracle Database: Managing Multitenant Architecture Ed 1Manage PDB service names and connectionsManage startup, shutdown and availability of CDBs and PDBsChange the different modes and settings of PDBsEvaluate the impact of parameter value changesPerformance management in CDBs and PDBsControl CDB and PDB resource usage with the Oracle Resource ManagerBackup and Duplicate - Oracle Database: Managing Multitenant Architecture Ed 1Perform Backup and Recover CDBs and PDBsDuplicate an active PDBDuplicate a DatabaseUpgrading and Transporting CDBs and Regular PDBs - Oracle Database: Managing Multitenant Architecture Ed 1Upgrade an Oracle DatabaseTransport DataManage Application PDBs - Oracle Database: Managing Multitenant Architecture Ed 1Explain the purpose of application root and application seedDefine and create application PDBsInstall, upgrade and Patch applicationsCreate and administer Application PDBSClone PDBs and Application containersPlug and unplug operations with PDBs and application containersComparing Local Undo Mode and Shared Undo ModeManage Security in Multitenant databases - Oracle Database: Managing Multitenant Architecture Ed 1Manage Security in Multitenant databasesManage PDB lockdown profilesAudit Users in CDBs and PDBsManage other types of policies in application containersRecovery and Flashback - Oracle Database: Managing Multitenant Architecture Ed 1Restore and Recovering Databases with RMANPerform CDB and PDB flashbackBackup Strategies and Terminology - Oracle Database: Backup and Recovery WorkshopPerform Full and Incremental Backups and RecoveriesCompress and Encrypt RMAN BackupsUse a media managerCreate multi-section backups of very large filesCreate duplexed backup setsCreate archival backupsBackup of recovery filesBackup non database filesBack up ASM meta dataRestore and Recovery Concepts - Oracle Database: Backup and Recovery WorkshopEmploy the best Oracle Database recovery technology for your failure situationDescribe and use Recovery technology for Crash, Complete, and Point-in-time recovryUsing Flashback Technologies - Oracle Database: Backup and Recovery WorkshopConfigure your Database to support FlashbackPerform flashback operationsDuplicating a Database - Oracle Database: Backup and Recovery WorkshopDuplicate DatabasesConfiguring and Using RMAN - Oracle Database: Backup and Recovery WorkshopConfigure RMAN and the Database for RecoverabilityConfigureand Using an RMAN recovery catalogDiagnosing Failures - Oracle Database: Backup and Recovery WorkshopDetect and repair database and database block corruptionDiagnosing Database IssuesPerforming Recovery - Oracle Database: Backup and Recovery WorkshopRestore and Recovering Databases with RMANPerform Non RMAN database recoveryTransporting Data - Oracle Database: Backup and Recovery WorkshopTransport DataRMAN Troubleshooting and Tuning - Oracle Database: Backup and Recovery WorkshopInterpret the RMAN message outputDiagnose RMAN performance issuesInstall Grid Infrastructure and Oracle Database - Oracle Database: Deploy, Patch and Upgrade WorkshopInstall Grid Infrastructure for a Standalone serverInstall Oracle Database softwarePatching Grid Infrastructure and Oracle Database - Oracle Database: Deploy, Patch and Upgrade WorkshopPatch Grid Infrastructure and Oracle DatabaseUpgrading to Oracle Grid Infrastructure - Oracle Database: Deploy, Patch and Upgrade WorkshopUpgrade Oracle Grid InfrastructureOracle Database 18c: New Features - Oracle Database: Deploy, Patch and Upgrade WorkshopImage and RPM based Database InstallationCreating an Oracle Database by using DBCA - Oracle Database: Deploy, Patch and Upgrade WorkshopCreate, Delete and Configure Databases using DBCAOracle Restart - Oracle Database: Deploy, Patch and Upgrade WorkshopConfigure and use Oracle Restart to manage componentsUpgrade the Oracle Database - Oracle Database: Deploy, Patch and Upgrade WorkshopPlan for Upgrading an Oracle DatabaseUpgrade an Oracle DatabasePerform Post-Upgrade tasksInstall Grid Infrastructure for a Standalone server - Oracle Database: Deploy, Patch and Upgrade WorkshopRapid Home ProvisioningUsing General Overall Database Enhancements - Oracle Database 19c: New Features for AdministratorsInstall Oracle Database softwareCreate, Delete and Configure Databases using DBCACreating CDBs and Regular PDBsUse Miscellaneaous 19c New FeaturesUsing Availability Enhancements - Oracle Database 19c: New Features for AdministratorsUse an RMAN recovery catalogUse Flashback DatabaseUsing Diagnosibility Enhancements - Oracle Database 19c: New Features for AdministratorsUse new Diagnoseability FeaturesMonitoring and Tuning Database Performance - Oracle Database: Administration WorkshopManaging Memory ComponentsUnderstanding The Automatic Workload Repository (AWR)Understanding The Advisory FrameworkMonitoring Wait Events, Sessions, and ServicesManaging Metric Thresholds and AlertsUnderstanding and Using The Performance Tuning MethodologyPerforming Performance PlanningUnderstanding The Automatic Database Diagnostic Monitor (ADDM)Tuning SQL Statements - Oracle Database: Administration WorkshopUnderstanding The Oracle OptimizerUsing The SQL Tuning AdvisorManaging Optimizer StatisticsUsing The SQL Access AdvisorUnderstanding The SQL Tuning Process