《exadata一体机使用的50个小技巧》由会员分享,可在线阅读,更多相关《exadata一体机使用的50个小技巧(19页珍藏版)》请在金锄头文库上搜索。
1、Exadata管理3Exadata性能优化3让表使用flash cache3可以使用如下公式计算Exadata特性对IO的优化3可以使用如下公式计算Exadata Storage Index对Disk IO减少的共享3可以使用如下计算Flash Cache的使用率3收集cell级别的表缓存统计信息的方法3确认在使用write back flash cache4确认所有的griddisk均为正常online状态4确认所有的flashdisk均为正常online状态4启用write back flash cache的方法4确认Exadata 计算节点间的网络带宽5检测多个ORACLE_HOME是否
2、RDS可用?6relink ORACLE_HOME的RDS6不同配置Exadata的推荐最大并行度6Exadata EHCC支持6Exadata 压缩信息6针对写日志redo特别多的应用建议启用Smart Flash logging特性6Exadata DB管理6Exadata存储空间计算7查看cell软件版本7了解cell的温度7cell存储节点的日志存放位置7列出cell中的alert history7为cell创建一个告警阈值7cell可用性监控8如何禁用Smart Scan?8如何禁用storage index?8如何禁用flash cache?8cell相关的数据库视图有以下这些视图
3、8配置Inter-Database IORM8如何禁用布隆过滤Bloom Fliter9Exadata数据备份9backup备份速率9recovery应用日志恢复速率9standby database搭建9Exadata恢复9cell 救护9Exadata部署9onecommand下载9Exadata安装前准备工作10环境检查10验证网络连通性10Exadata监控11exachk健康检查脚本11Exadata文档信息12Exadata硬件篇12常规12默认密码,以下是Exadata中cell/db node IB等的默认密码:12硬件常规巡检:12检测Exadata数据库机器上的硬件和固件版
4、本是否匹配?13检测软件版本与平台是否匹配?13为cell启用邮件告警13监控磁盘故障13更换Storage Cell硬盘13观察Database Server 磁盘状态13观察Database Server RAID状态13Storage Cell加电启动14检测memory ECC错误14若发现Exadata上存在磁盘损毁则:14检测 cell server Cache Policy14Exadata 停机:15Exadata 启动16Infiniband篇16启停IBSwitch16检查IB链路状态17查看IB网络拓扑状态17诊断IB链路没有错误17查看IB网络连线17查看IB健康状态1
5、7IB健康检查17IB故障处理17IB硬件监控18Switch端口错误18Link状态18Subnet manager18CISCO交换机18例行维护操作18KVM19PDU19故障处理19Exadata管理Exadata性能优化让表使用flash cacheALTER TABLE storage (CELL_FLASH_CACHE KEEP);可以使用如下公式计算Exadata特性对IO的优化 1 (cell physical IO interconnect bytes returned by smart scan)/ (cell IO uncompressed bytes + cell p
6、hysical IO bytes saved by storage index) * 100可以使用如下公式计算Exadata Storage Index对Disk IO减少的共享(cell physical IO bytes saved by storage index / physical read total bytes) * 100可以使用如下计算Flash Cache的使用率(cell flash cache read hit / physical read total IO requests) * 100收集cell级别的表缓存统计信息的方法SQL SELECT data_obje
7、ct_id FROM DBA_OBJECTS WHERE object_name=EMP;OBJECT_ID57435CellCLI LIST FLASHCACHECONTENT WHERE objectNumber=57435 DETAIL cachedSize: 495438874dbID: 70052hitCount: 415483missCount: 2059objectNumber: 57435tableSpaceNumber: 1确认在使用write back flash cache#dcli -g /cell_group -l root cellcli -e “list cell
8、 attributes flashcachemode”Results:flashCacheMode: WriteBack - write back flash cache is enabledflashCacheMode: WriteThrough - write back flash cache is not enabled确认所有的griddisk均为正常online状态# dcli -g cell_group -l root cellcli -e list griddisk attributes asmdeactivationoutcome, asmmodestatus确认所有的flas
9、hdisk均为正常online状态# dcli -g cell_group -l root cellcli -e list flashcache detail启用write back flash cache的方法A. Enable Write Back Flash Cache using a ROLLING method(RDBMS & ASM instance is up enabling write-back flashcache one cell at a time)Log onto the first cell that you wish to enable write-back Fl
10、ashCache1. Drop the flash cache on that cell# cellcli -e drop flashcache2. Check if ASM will be OK if the grid disks go OFFLINE. The following command should return Yes for the grid disks being listed:# cellcli -e list griddisk attributes name,asmmodestatus,asmdeactivationoutcome3. Inactivate the gr
11、iddisk on the cell# cellcli e alter griddisk all inactive4. Shut down cellsrv service# cellcli -e alter cell shutdown services cellsrv5. Set the cell flashcache mode to writeback# cellcli -e “alter cell flashCacheMode=writeback”6. Restart the cellsrv service# cellcli -e alter cell startup services c
12、ellsrv7. Reactivate the griddisks on the cell# cellcli e alter griddisk all active8. Verify all grid disks have been successfully put online using the following command:# cellcli -e list griddisk attributes name, asmmodestatus9. Recreate the flash cache# cellcli -e create flashcache all10. Check the
13、 status of the cell to confirm that its now in WriteBack mode:# cellcli -e list cell detail | grep flashCacheMode11. Repeat these same steps again on the next cell. However, before taking another storage server offline, execute the following making sure asmdeactivationoutcome displays YES:# cellcli
14、-e list griddisk attributes name,asmmodestatus,asmdeactivationoutcomeB . Enable Write Back Flash Cache using a NON-ROLLING method(RDBMS & ASM instances are down while enabling write-back flashcache)1. Drop the flash cache on that cell# cellcli -e drop flashcache2. Shut down cellsrv service# cellcli
15、-e alter cell shutdown services cellsrv3. Set the cell flashcache mode to writeback# cellcli -e “alter cell flashCacheMode=writeback”4. Restart the cellsrv service# cellcli -e alter cell startup services cellsrv5. Recreate the flash cache# cellcli -e create flashcache all确认Exadata 计算节点间的网络带宽可以采用nc nc-1.84-10.fc6.x86_64.rpm获得检测多个ORACLE_HOME是否RDS可用?