|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-exadata-x5-administration-1z0-070-j/
课程评论：没有评论
课程名称：Oracle Exadata X5 管理 1Z0-070 课程概述： 本课程旨在深入探索Oracle Exadata数据库机器的管理，包括其架构、性能优化、资源管理及数据库迁移等方面的知识。 1. **Exadata数据库机器概述** - 了解Exadata数据库机器在不同应用类别中的优势。 - 描述数据库机器的关键容量和性能规格。 2. **Exadata数据库机器架构** - 理解数据库机器的网络架构和软件架构。 - 绘制Exadata存储服务器的存储实体及其关系图，并了解如何连接和扩展多个数据库机器。 3. **Exadata数据库机器的关键功能** - 介绍Exadata的关键能力，包括智能扫描、混合列压缩及智能闪存缓存等。 4. **Exadata数据库机器的初始配置** - 讨论数据库机器的站点规划要求及安装配置流程。 5. **I/O资源管理** - 使用Exadata存储服务器I/O资源管理来管理数据库内及跨多个数据库的工作负载。 6. **优化数据库性能** - 结合Exadata优化数据库性能的方法。 7. **数据库迁移到Exadata数据库机器** - 讲解将数据库迁移到Exadata的步骤及主流迁移方法。 8. **大数据加载** - 配置数据库文件系统(DBFS)以高性能加载数据。 9. **Exadata数据库机器平台监控** - 理解如何使用SNMP、IPMI和ILOM监控Exadata数据库机器。 10. **备份和恢复** - 描述如何优化RMAN备份以及对数据库进行备份和恢复的推荐方法。 11. **数据库机器维护任务** - 学习电源管理、组件更换以及其他维护操作。 12. **Exadata数据库机器自动支持生态系统** - 了解自动服务请求(ASR)功能及Oracle配置管理器(OCM)的相关内容。 课程适合希望提高Oracle Exadata管理技能的数据库管理员及IT专业人士，旨在帮助学员掌握Exadata机器的高效运维与管理。
Exadata Database Machine OverviewIdentify the benefits of using Database Machine for different application classesDescribe the key capacity and performance specifications for Database MachineExadata Database Machine ArchitectureDescribe the Database Machine network architecture and requirementsDescribe the Database Machine software architectureDescribe the Exadata Storage Server storage entities and their relationshipsDescribe how multiple Database Machines can be interconnected and scaled upKey Capabilities of Exadata Database MachineDescribe the key capabilities of Exadata Database MachineDescribe the Exadata Smart Scan capabilitiesDescribe the capabilities of hybrid columnar compressionDescribe the capabilities and uses of the Smart Flash CacheDescribe t he capabilities of Columnar Flash CachingDescribe the capabilities of the Smart Flash LogDescribe the purpose and benefits of Storage IndexesDescribe the capabilities and uses of Exadata Snapshot databasesDescribe Cell to Cell Data Transfer and Exadata Network Resource ManagementExadata Database Machine Initial ConfigurationDescribe site planning requirements for Database MachineDescribe the installation and configuration process with the Exadata Deployment AssistantDescribe the default configuration for Database MachineDescribe supported and unsupported customizations for Database MachineConfigure Exadata Storage ServerConfigure Exadata software and resources using Cellcli or other toolsCreate and configure ASM disk groups using ExadataUse the CellCLI, ExaCLI, DCLI and ExaDCLI Exadata administration toolsConfigure Exadata Storage Server securityI/O Resource ManagementUse Exadata Storage Server I/O Resource Management to manage workloads within a database and across multiple databasesConfigure database resource management plans and profilesConfigure category plansConfigure inter-database plansDescribe and configure the I/O resource manager objectivesMonitor I/O using I/O MetricsRecommendations for Optimizing Database PerformanceOptimize database performance in conjunction with Exadata Database MachineOptimize Cell performance for Flash Cache and latency cappingUsing Smart ScanDescribe Smart Scan and the query processing that can be offloaded to Exadata Storage ServerDescribe the requirements for Smart ScanDescribe the circumstances that prevent using Smart ScanIdentify Smart Scan in SQL execution plans including smart joinsUse database statistics and wait events to confirm how queries are processedConsolidation Options and RecommendationsDescribe the options for consolidating multiple databases on Database MachineDescribe the benefits and costs associated with different optionsIdentify the most appropriate approach for consolidation in different circumstancesMigrating Databases to Exadata Database MachineDescribe the steps to migrate your database to Database MachineExplain the main approaches for migrating your database to Database MachineIdentify the most appropriate approach for migration in different circumstancesBulk Data LoadingConfigure the Database File System (DBFS) feature for staging input data filesUse external tables based on input data files stored in DBFS to perform high-performance data loadsExadata Database Machine Platform MonitoringDescribe the purpose and uses of SNMP for the Database MachineDescribe the purpose and uses of IPMI for the Database MachineDescribe the purpose and uses of ILOM for the Database MachineConfiguring Enterprise Manager Cloud Control 12c to Monitor Exadata Database MachineDescribe the Enterprise Manager cloud Control architecture as it specifically applies to Exadata Database MachineDescribe the discovery process and post discovery configurationsMonitoring Exadata Storage ServersDescribe Exadata Storage Server metrics, alerts, Thresholds and active requestsDescribe and use Exedata Storage Server Quarantines, Disk Scrubbing and repairMonitor Exadata Storage Server using Command line or Cloud controlMonitoring Exadata Database Machine Database ServersDescribe the monitoring recommendations for Exadata Database Machine database serversUse Cloud Control or DBMCLI to monitor Exadata Database Machine Database ServersMonitoring the InfiniBand NetworkMonitor InfiniBand switches With Cloud Control or CLIMonitor InfiniBand switch portsMonitor InfiniBand ports on the database servers ajd Cells with LIST IBPORT commandMonitoring other Exadata Database Machine ComponentsMonitor Exadata Database Machine components: Cisco Switch, Power Distribution UnitsMonitoring ToolsUse monitoring tools: Exachk, ExaWatcher, TFA Collector DiagTools, ADRCI, Imageinfo and Imagehistory, OSWatcherBackup and Recovery for Exadata Database MachinesDescribe how RMAN backups are optimized using Exadata Storage ServerDescribe the recommended approaches for disk-based and tape-based backups of databases on Database MachinePerform backup and recoveryConnect a media server to the Database Machine InfiniBand networkDatabase Machine Maintenance tasksPower Database Machine on and offSafely shut down a single Exadata Storage ServerReplace a damaged physical disk on a cellReplace a damaged flash card on a cellMove all disks from one cell to anotherUse the Exadata Cell Software Rescure ProcedurePatching Exadata Database MachineDescribe how software is maintained on different Database Machine componentsDatabase Machine Automated Support EcosystemDescribe the Auto Service Request (ASR) function and how it relates to Exadata Database MachineDescribe the implementation requirements for ASRDescribe the ASR configuration processDescribe Oracle Configuration Manager (OCM) and how it relates to Exadata Database Machine
