Exadata-Management-and-Maintenance-Workshop-V2

Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide131Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide132ExadataManagementandMaintenanceWorkshop王俊伟JavidWangSeniorSalesConsultantExadataX2-2版Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide133Exadata的体系架构概览Exadata存储服务器监控Exadata数据库服务器监控InfiniBand网络及其它组件监控Exadata日常维护Exadata的备份与恢复Exadata常用工具及故障诊断用EM12C管理ExadataAgendaCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide134Exadata硬件架构IntelligentStorageGrid•14High-performancelow-coststorageservers•100TBHighPerformancedisk,or336TBHighCapacitydisk•5.3TBPCIFlash•IntelligentStorageServerSoftwareInfiniBandNetwork•3x36-port40Gb/sswitches•Unifiedserver&storagenetworkDatabaseGrid2xEight-processorx64databaseserversCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide135Exadata软件体系架构概览DBInstanceLIBCELLDBServerDBInstanceLIBCELLDBServerRACDBInfiniBandStorageSwitch/Network基于InfiniBand配有路径故障转移的iDB协议EnterpriseManagerCellControlCLI(cellcli/dcli)ASMASMSSHExadataServerExadataServerExadataServerDBRMDBRMOELCELLSRVIORMMSRSOELCELLSRVIORMMSRSOELCELLSRVIORMMSRSCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide136LIBCELLDBServerLIBCELLDBServerRACDBExadataServerOELCELLSRVIORMMSRSExadataServerExadataServerEnterpriseManagerCellControlCLI(cellcli/dcli)SSHASMASMInfiniBandStorageSwitch/NetworkDBInstanceDBInstanceDBRMDBRMOELCELLSRVIORMMSRSOELCELLSRVIORMMSRS基于InfiniBand配有路径故障转移的iDB协议Exadata软件体系架构概览Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide137Exadata网络架构Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide138ExadataCell磁盘存储的关系CellDiskGridDiskGridDisk(coldpart)CellCLICREATEGRIDDISK...OR对ASM可见GridDisk(hotpart)LUNCELLDISKASMdiskDiskGRIDDISKLUNSystemAreaDataStoragePartitionOthertendisksFirsttwodisksonlymirroredORCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide139ExadataCellFlashLUN闪存存储实体和关系CellCLICREATEFLASHCACHE...CellCLICREATEGRIDDISK...FLASHDISK...ORLUNCELLDISKASMdiskGRIDDISKFLASHCACHEORFlashCellDiskFlashCacheFlashCacheGridDisk对ASM可见4x96GBSunFlashPCIeCardsCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide1310磁盘组配置采用Normal保护方式，任何一份数据会同时分布到两个不同的FailureGroup中任何两个不同的FailureGroup一定不来自同一个StorageCell如果需要增加数据保护，可以增加FailureGroup数量实现数据更多重的保护ExadataCellExadataCellFRAASMDiskGroupCELL1FailureGroupCELL2FailureGroupSQLCREATEDISKGROUPDATAASMDiskGroupCELL1FailureGroupCELL2FailureGroupCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide1311ExadataStorageServer端的进程Cellcli管理命令ManagementServer(MS)：griddisk的创建、H/W改变、SNMP陷阱警报、email通知、阈值控制及服务器管理RestartServer(RS)：CELLSRV和MS的监控，重启。DatabaseServerRDBMS/ASMinstancedskmdiskmonSGAInfinibandFabricrsmscellcliDataMetadataDataMetadataDataMetadatalibcellIOClientIOLayerASMlayerExadataStorageServercellsrv/etc/oracle/cell/network-configcellinit.oraLocalIPCellslistcellip.oraCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide1312ExadataSmartFlashCache的智能缓存•不缓存ASM的镜像副本产生的I/O•不缓存备份相关的IO•不缓存DataPumpI/O•不缓存数据文件格式设置•不缓存普通的表扫描（未设置为保留的情况下）•缓存经常访问的数据和索引块•缓存控制文件读取和写入•缓存文件头读取和写入•DBA可以设置缓存优先级•管理员可以把常用的表设置到FlashCache中ALTERTABLE表名STORAGE(CELL_FLASH_CACHEKEEP)Exadata存储CELL中安装了Flash卡96GB的存储容量–4x24GBFlash模块–6GBreservedforfailures–96GB*4=384GB/1Cell配有超级电容作为备用电源可作为数据库的二级缓存端到端的性能改善–3.6GB/sec/cell–75,000IOPs/cell4x96GBFlashCardsCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide1313ExadataSmartFlashCache的使用方法DBDBDBcellsrvAcknowledgement3124cellsrvReadRequest312cellsrvReadRequest312写操作读操作基于之前缓存的数据4ExadataSmartFlashCache读操作基于之前未缓存的数据Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide1314ExadataI/O资源管理多数据库环境确保不同的数据库分配到正确的IO带宽–DatabaseA:33%的I/O资源–DatabaseB:67%的I/O资源ExadataCellExadataCellExadataCellDatabaseB(RAC)DatabaseA(Single-Instance)33%67%InfiniBandNetwork确保一个数据库内的不同用户和任务分配到正确的IO带宽•DatabaseA:•report:60%的I/O资源•ETL:40%的I/O资源•DatabaseB:•交互式处理:30%的I/O资源•批处理:70%的I/O资源70%30%Copyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide1315Exadata的体系架构概览Exadata存储服务器监控Exadata数据库服务器监控InfiniBand网络及其它组件监控Exadata日常维护Exadata的备份与恢复Exadata常用工具及故障诊断用EM12C管理ExadataAgendaCopyright©2012,Oracleand/oritsaffiliates.Allrightsreserved.InsertInformationProtectionPolicyClassificationfromSlide1316ExadataStorag