VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

Some exadata disk tips

Posted by admin on 29th July 2013

针对exadata最近频繁报出的IO error,做如下总结

data node alert

ORA-27603: 单元存储 I/O 错误, I/O 在磁盘 o/192.168.10.5/DATA_DM01_CD_08_dm01cel03 上失败, 偏移量 17331625984 (数[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

Update exadata flash disk firmware due to poor performance on X2-2

Posted by admin on 14th March 2013

ASR XD报警抛出如下错误

"
dm01cel02: Hardware Error has been detected in the Flash Logs on the Cell Node
dm01cel02: Please open up a Service Request[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

Exadata X2-2 Hang死一例

Posted by admin on 3rd November 2012

Exadata不是万能的 一直觉得xd DB端的服务器太差,但是oracle总是可以理直气壮的说我们卖的不是硬件是软件.垃圾SQL压死Exadata还是很容易的

系统为X2-2 Quarter rack Red Hat Enterprise Linux Server release 5.7 ([......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

Oracle Platinum Services

Posted by admin on 23rd October 2012

Oracle的白金服务是一种Oracle标准支持下的特殊权利,为客户提供标准合同范畴外的额外服务,以最大的提升Exadata的用户的客户体验,生产机器将在oracle所提供的标准化配置中与oracle总部的call center保持双向连通。Oracle的白金服务代表了一种新的模式,为客户提供了可以[......]

Read more

Tags:
Posted in Life | No Comments »

Exadata Smart Flash Logging

Posted by admin on 5th September 2012

Oracle Exadata 从 11.2.2.4.0开始引入了 Smart Flash Logging的新特性,在exadata环境中,当oracle 需要写入日志的时候将会启动parallel write 同时在 disk 和 flash两端写入数据,controller中有任意一个率先写完就会[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

Exadata offloading and Smart Scan

Posted by admin on 25th August 2012

同事aaqwsh做的关于Exadata-X2-2的smart scan总结

Tags:
Posted in Oracle Experience | No Comments »

Exadata migration tips

Posted by admin on 7th August 2012

Exadata migration完成 目前采用的是物理DG switch over的方式 采用11g active duplicate 实现整个数据大小为2T左右 总共耗时约为10个小时 每秒达到近60M
采取这种方法的好处为:
1:主库无需停机
2:可以采用exadata最佳性能AU_SI[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

Some Exadata Docs

Posted by admin on 15th July 2012

可以通过以下文档了解exadata软硬件的一些情况,以及troubleshooting时如何收集信息,需要收集怎么样的信息-包括了hardware,software
network,ILOM等。另外还有一些ED的远程容灾建议。

Doc ID 888828.1 Database Machin[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

Exadata RDS

Posted by admin on 10th July 2012

Oracle RAC RDS reference:

Oracle Real Application Clusters (RAC) allows Oracle Database to run any packaged or custom application, unchanged across a set of clustered servers. This provides high availability and flexible scalability. If a clustered server fails, then database continues running on the rest of the servers. When you need additional processing power, you can add additional servers to the cluster online.
A key hardware component of this technology is the private interconnect network between the clustered servers. The interconnect is used by the cluster for inter-node messaging. The interconnect is also used by RAC to implement cache fusion technology.
Reliable Datagram Sockets (RDS) protocol provides reliable datagram services multiplexing UDP packets over InfiniBand connection improving performance to Oracle RAC. It provides high performance cluster interconnect for Oracle 10g RAC, utilizing InfiniBand which has 10X to 30X bandwidth advantage and 10X to 30X latency reduction vs. Gigabit Ethernet.

Only the database servers are configured with a 64K MTU. Presumably this is to benefit TCP/IP traffic between the database servers, and between the database servers and any external host that is linked to the IB switch. You may be surprised to know that the IB ports on the storage cells are configured with the standard 1,500 byte MTU size. The large MTU size is not necessary on the storage cells, because I/O between the database grid and the storage grid utilizes the RDS protocol, which is much more efficient for database I/O and bypasses the TCP/IP protocol stack altogether.

As you can see from the diagram, using the RDS protocol to bypass the TCP processing cuts out a[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

新到两台x2-2

Posted by admin on 29th May 2012


oracle服务还是很到位的 2台机器弄了这么一辆卡车来运 :)

Tags:
Posted in Life | 3 Comments »