Oracle 里面如何实现只回滚某个事务的一部分内容
昨天凌晨被电话吵醒,某客户的一套11gR2 RAC出现异常,正常启动之后很快就crash掉,并伴随相关ora- […]
昨天凌晨被电话吵醒,某客户的一套11gR2 RAC出现异常,正常启动之后很快就crash掉,并伴随相关ora- […]
我们都知道Oracle 10g引入了跨resetlogs特性,这个特性确实很棒。在10g之前,如果我们要进行跨 […]
前不见,某客户的系统遭遇性能问题,该环境redo量较大,高峰超过20m/s。 业务应用程序在运行过程之中发现运 […]
某客户的业务系统(15TB,3节点RAC) 由于abort关闭之后,导致数据库无法正常open. 在Open时 […]
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 |
如下是我整理的最新的10.2.0.4+版本的最新psu信息,供大家参考!(新增加12c psu信息) ++++10.2.0.4 Oracle Database Patch Set Update Unix Comments Includes Cpu 10.2.0.4.1 8576156 Bash 10.2.0.4.0 includes CPU Jul 2009 10.2.0.4.2 8833280 Bash 10.2.0.4.0 includes CPU Oct 2009 10.2.0.4.3 9119284 Bash 10.2.0.4.0 includes CPU Jan 2010 10.2.0.4.4 9352164 Bash 10.2.0.4.0 includes CPU Apr 2010 10.2.0.4.5 9654991 该psu必须基于10.2.0.4.4 includes CPU Jul 2010 10.2.0.4.6 9952234 该psu必须基于10.2.0.4.4 includes CPU Oct 2010 10.2.0.4.7 10248636 该psu必须基于10.2.0.4.4 includes CPU Jan 2011 10.2.0.4.8 11724977 该psu必须基于10.2.0.4.4 includes CPU Apr 2011 10.2.0.4.9 12419397 该psu必须基于10.2.0.4.4 includes CPU Jul 2011 10.2.0.4.10 12827778 该psu必须基于10.2.0.4.4 includes CPU Oct 2011 10.2.0.4.11 12879929 该psu必须基于10.2.0.4.4 includes CPU Jan 2012 10.2.0.4.12 12879933 该psu必须基于10.2.0.4.4 includes CPU Apr 2012 10.2.0.4.13 13923851 该psu必须基于10.2.0.4.4 includes CPU Jul 2012 10.2.0.4.14 14275630 该psu必须基于10.2.0.4.4 includes CPU Oct 2012 10.2.0.4.15 14736542 该psu必须基于10.2.0.4.4 includes CPU Jan 2013 10.2.0.4.16 16056269 该psu必须基于10.2.0.4.4 includes CPU Apr 2013 10.2.0.4.17 16619897 该psu必须基于10.2.0.4.4 includes CPU Jul 2013 +++++10.2.0.5 Oracle Database Patch Set Update Unix Comments Includes Cpu 10.2.0.5.1 9952230 Bash 10.2.0.5.0 includes CPU Oct 2010 10.2.0.5.2 10248542 Bash 10.2.0.5.0 includes CPU Jan 2011 10.2.0.5.3 11724962 Bash 10.2.0.5.0 includes CPU Apr 2011 10.2.0.5.4 12419392 Bash 10.2.0.5.0 includes CPU Jul 2011 10.2.0.5.5 12827745 Bash 10.2.0.5.0 Includes CPU Oct 2011 10.2.0.5.6 13343471 Bash 10.2.0.5.0 includes CPU Jan 2012 10.2.0.5.7 13632743 Bash 10.2.0.5.0 includes CPU Apr 2012 10.2.0.5.8 13923855 Bash 10.2.0.5.0 includes CPU Jul 2012 10.2.0.5.9 14275629 Bash 10.2.0.5.0 includes CPU Oct 2012 10.2.0.5.10 14727319 Bash 10.2.0.5.0 includes CPU Jan 2013 10.2.0.5.11 16056270 Bash 10.2.0.5.0 includes CPU Apr 2013 10.2.0.5.12 16619894 Bash 10.2.0.5.0 includes CPU Jul 2013 +++++11.1.0.7 Oracle Database Patch Set Update Database CRS Comments Includes Cpu 11.1.0.7.1 8833297 bug: 8287931 Bash 11.1.0.7.0 includes CPU Oct 2009 11.1.0.7.2 9209238 bug: 9207257 Bash 11.1.0.7.0 includes CPU Jan 2010 11.1.0.7.3 9352179 Bash 11.1.0.7.0 includes CPU Apr 2010 11.1.0.7.4 9654987 bug: 9294495 Bash 11.1.0.7.0 includes CPU Jul 2010 11.1.0.7.5 9952228 bug: 9952240 Bash 11.1.0.7.0 includes CPU Oct 2010 11.1.0.7.6 10248531 bug: 10248535 Bash 11.1.0.7.0 includes CPU Jan 2011 11.1.0.7.7 11724936 11724953 Bash 11.1.0.7.0 includes CPU Apr 2011 11.1.0.7.8 12419384 11724953 Bash 11.1.0.7.0 includes CPU Jul 2011 11.1.0.7.9 12827740 11724953 Bash 11.1.0.7.0 includes CPU Oct 2011 11.1.0.7.10 13343461 11724953 Bash 11.1.0.7.0 includes CPU Jan 2012 11.1.0.7.11 13621679 11724953 Bash 11.1.0.7.0 includes CPU Apr 2012 11.1.0.7.12 13923474 11724953 Bash 11.1.0.7.0 includes CPU Jul 2012 11.1.0.7.13 14275623 11724953 Bash 11.1.0.7.0 includes CPU Oct 2012 11.1.0.7.14 14739378 11724953 Bash 11.1.0.7.0 includes CPU Jan 2013 11.1.0.7.15 16056268 11724953 Bash 11.1.0.7.0 includes CPU Apr 2013 11.1.0.7.16 16619896 11724953 Bash 11.1.0.7.0 includes CPU Jul 2013 11.1.0.7.17 17082366 11724953 Bash 11.1.0.7.0 includes CPU Oct 2013 ++++++11.2.0.1 Oracle Database Patch Set Update Database Grid Infrastructure Comments Includes Cpu 11.2.0.1.1 9352237 9343627 Bash 11.2.0.1.0 includes CPU Apr 2010 11.2.0.1.2 9654983 9343627 Bash 11.2.0.1.0 includes CPU Jul 2010 11.2.0.1.3 9952216 9655006 Bash 11.2.0.1.0 includes CPU Oct 2010 11.2.0.1.4 10248516 9655006 Bash 11.2.0.1.0 includes CPU Jan 2011 11.2.0.1.5 11724930 9655006 Bash 11.2.0.1.0 includes CPU Apr 2011 11.2.0.1.6 12419378 9655006 Bash 11.2.0.1.0 includes CPU Apr 2011 +++++++11.2.0.2 OracleDatabase PatchSet Update Database Grid Infrastructure Comments Includes Cpu 11.2.0.2.1 10248523 Bundle1 10157506 Bash 11.2.0.2.0 no CPU fixes 11.2.0.2.2 11724916 Bundle2 10425672 Bash 11.2.0.2.0 includes CPU Apr 2011 PSU2 12311357 11.2.0.2.3 12419331 12419353 Bash 11.2.0.2.0 includes CPU Jul 2011 11.2.0.2.4 12827726 12827731 Bash 11.2.0.2.0 includes CPU Oct 2011 11.2.0.2.5 13343424 13343447 Bash 11.2.0.2.0 includes CPU Jan 2012 11.2.0.2.6 13696224 13696242 Bash 11.2.0.2.0 includes CPU Apr 2012 11.2.0.2.7 13923804 14192201 Bash 11.2.0.2.0 includes CPU Jul 2012 11.2.0.2.8 14275621 14390437 Bash 11.2.0.2.0 includes CPU Oct 2012 11.2.0.2.9 14727315 14390437 Bash 11.2.0.2.0 includes CPU Jan 2013 11.2.0.2.10 16056267 16166868 Bash 11.2.0.2.0 includes CPU Apr 2013 11.2.0.2.11 16619893 16742320 Bash 11.2.0.2.0 includes CPU Jul 2013 11.2.0.2.12 17082367 17272753 Bash 11.2.0.2.0 includes CPU Oct 2013 +++++++11.2.0.3 OracleDatabase PatchSet Update Database Grid Infrastructure Comments Includes Cpu 11.2.0.3.0 10404530 (包含在10404530中) 11.2.0.3.1 13343438 13348650 Bash 11.2.0.3.0 includes CPU Jan 2012 11.2.0.3.2 13696216 13696251 Bash 11.2.0.3.0 includes CPU Apr 2012 11.2.0.3.3 13923374 13919095 Bash 11.2.0.3.0 includes CPU Jul 2012 11.2.0.3.4 14275605 14275572 Bash 11.2.0.3.0 includes CPU Oct 2012 11.2.0.3.5 14727310 14727347 Bash 11.2.0.3.0 includes CPU Jan 2013 11.2.0.3.6 16056266 16083653 Bash 11.2.0.3.0 includes CPU Apr 2013 11.2.0.3.7 16619892 16742216 Bash 11.2.0.3.0 includes CPU Jul 2013 11.2.0.3.8 16902043 17272731 Bash 11.2.0.3.0 includes CPU Oct 2013 +++++++11.2.0.4 OracleDatabase PatchSet Update Database Grid Infrastructure Comments Includes Cpu 11.2.0.4.0 13390677 13390677 +++++++12.1.0.1 OracleDatabase PatchSet Update Database Grid Infrastructure Comments Includes Cpu 12.1.0.1.1 17027533 17272829 Bash 12.1.0.1.0 |
oracle 12c 已经发布了几个月了,最近太忙,一直没时间研究12c,今天抽空研究一下12c 中asm的元 […]
1 |
某客户的一套rac,其中node1 被莫名的重启了,如下: |
[crayon-66838e8a98b322 […]
上周6,某客户进行存储扩容(11gR2 rac asm),扩容完成之后,我们需要将新划的lun加到现有的asm […]
最近某客户9208环境,遭遇latch free问题,而在oracle 9i版本中,latch free 只是 […]
oracle 12c发布已经有几天了,最近一直比较忙,没时间研究,趁周末在家玩玩,熟悉下12c的新特性. 其中 […]
前几天某大师提醒我说了,我以前一篇文档flashback_transaction_query 查询慢的问题 有 […]
最近在一个优化项目中,通过awr报告发现table fetch continued row 指标很高,怀疑是行 […]
51放假期间,同事问我一个问题,那就是dependency$被move后,数据库起不来了,虽然是测试环境。 他 […]
落落的sql优化班级确实牛叉,我也试听了1次,学不到不少东西,如果大家有兴趣,可以加他的试听QQ群:17922 […]
如下是我整理的最新的10.2.0.4+版本的最新psu信息,供大家参考! [crayon-66838e8ab5 […]
昨天朋友问到压缩表的细节问题,我准备用实验来解释,最近很久也没写博客了,就正好完善一下,贴出来。 首先我们来看 […]
前段时间,在ML的群中,原厂一个哥们发了图,图中提到oracle 12c之前,asm 的读取默认都是始终从pr […]
前几天跟lunar讨论问题,他提到关于数据库中段头block损坏的恢复以及假如出现位图block损坏等的情况恢 […]
从oracle 11gR2开始,引入了ACFS,其中11gR2同时又引入了ASM Dynamic Volume […]
在asm系列的上一篇文章中,我们描述了ACD,将其比喻成oracle database中的redo,如果说起作 […]