|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ocp-19c-2023-oracle-database-administration-ii-exam1z0-083/
课程评论:没有评论
本Coursera课程“OCP 19c Oracle Database Administration II Exam 1Z0-083”涵盖了Oracle数据库的多租户架构、备份恢复、部署升级以及性能管理等核心内容,旨在帮助学员通过1Z0-083考试。 **主要学习内容包括:** * **多租户架构管理:** * 创建和配置容器数据库(CDB)和可插拔数据库(PDB)。 * 管理PDB的服务名、连接、启动、关闭和可用性。 * 调整PDB的模式和设置,控制资源使用。 * 管理应用程序PDB,包括安装、升级、补丁和克隆。 * 执行PDB和应用容器的插入、拔出操作。 * 比较本地撤销模式和共享撤销模式。 * 管理多租户数据库的安全,包括PDB锁定配置文件、用户审计和其他策略。 * **备份与恢复:** * 使用RMAN执行CDB和PDB的备份和恢复。 * 克隆活动PDB和数据库。 * 执行全量和增量备份恢复。 * 压缩和加密RMAN备份。 * 创建多部分备份,双工备份集和归档备份。 * 备份恢复文件、非数据库文件和ASM元数据。 * 选择合适的Oracle数据库恢复技术(如Crash、Complete、Point-in-time恢复)。 * 使用Flashback技术进行数据库恢复。 * 配置和使用RMAN恢复目录。 * 诊断和修复数据库块损坏。 * 解释RMAN消息输出,诊断RMAN性能问题。 * **部署、补丁与升级:** * 安装Grid Infrastructure和Oracle Database。 * 补丁Grid Infrastructure和Oracle Database。 * 升级Oracle Grid Infrastructure。 * 使用DBCA创建、删除和配置数据库。 * 配置和使用Oracle Restart管理组件。 * 规划和执行Oracle数据库升级,以及执行升级后任务。 * 了解Oracle Database 18c和19c的新特性,包括镜像和RPM安装,以及General Overall Database Enhancements。 * **性能监控与调优:** * 管理内存组件。 * 理解Automatic Workload Repository (AWR)、Advisory Framework和Automatic Database Diagnostic Monitor (ADDM)。 * 监控等待事件、会话和服务,以及管理阈值和告警。 * 理解和使用性能调优方法论。 * 使用SQL Tuning Advisor和SQL Access Advisor来调优SQL语句,管理优化器统计信息。 本课程内容全面,结合了多租户、备份恢复、部署升级以及性能管理等Oracle数据库管理员的核心技能,并特别强调了OCP 1Z0-083考试所涵盖的知识点。
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