Oracle Database Administration II Exam Number: 1Z0-083

所在平台: Udemy

课程主页: https://www.udemy.com/course/oracle-database-administration-ii-exam-number-1z0-083-v/

课程评论:没有评论

第一个写评论        关注课程

课程简介

本课程是 **Oracle Database Administration II Exam Number: 1Z0-083**,旨在为学员提供全面的Oracle数据库管理知识,尤其侧重于18c和19c版本的新特性和多租户架构的管理。 **核心内容涵盖以下几个方面:** * **多租户架构管理 (Oracle Database: Managing Multitenant Architecture Ed 1):** * 创建和管理容器数据库 (CDB) 和可插拔数据库 (PDB)。 * PDB的服务名、连接、启动、关闭和可用性管理。 * PDB模式和设置的更改。 * 使用Oracle Resource Manager控制CDB和PDB的资源使用。 * 管理PDB锁定配置文件、审计和策略. * **备份与恢复 (Oracle Database: Backup and Recovery Workshop):** * RMAN备份和恢复CDB及PDB。 * 创建活动PDB和数据库的备份。 * 备份策略、术语、全量和增量备份。 * RMAN备份的压缩和加密,多章节备份,双工备份集,归档备份。 * 备份恢复文件,非数据库文件和ASM元数据。 * 理解数据库恢复技术(Crash, Complete, Point-in-time recovery)。 * 使用Flashback技术进行恢复。 * 配置和使用RMAN,包括恢复目录。 * 诊断数据库和数据库块的损坏。 * RMAN故障排除和性能调优。 * **部署、补丁与升级 (Oracle Database: Deploy, Patch and Upgrade Workshop):** * 安装Grid Infrastructure和Oracle Database。 * 补丁Grid Infrastructure和Oracle Database。 * 升级Oracle Grid Infrastructure。 * Oracle Database 18c和19c的新特性,包括镜像和RPM安装。 * 使用DBCA创建、删除和配置数据库。 * 配置和使用Oracle Restart管理组件。 * 规划数据库升级,执行升级和后升级任务。 * Rapid Home Provisioning。 * **数据库性能监控与调优 (Oracle Database: Administration Workshop):** * 内存组件管理。 * 理解AWR (Automatic Workload Repository) 和 ADDM (Automatic Database Diagnostic Monitor)。 * 监控等待事件、会话和服务。 * 管理指标阈值和告警。 * 理解和使用性能调优方法。 * SQL调优,包括优化器,SQL Tuning Advisor,SQL Access Advisor和SQL Tuning Process。 本课程通过理论讲解和实际操作,帮助学员掌握Oracle数据库多租户架构的管理、全面的备份与恢复策略、以及高效的部署、补丁和升级方法,并增强数据库的性能监控和调优能力,最终为通过1Z0-083考试做好准备。

课程评论(0条)

课程详情

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

课程标签

0人关注该课程

主题相关的课程