标签云
asm 恢复 asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 ORACLE恢复 Oracle 恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (100)
- 数据库 (1,597)
- DB2 (22)
- MySQL (70)
- Oracle (1,463)
- Data Guard (49)
- EXADATA (7)
- GoldenGate (21)
- ORA-xxxxx (158)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (13)
- ORACLE 21C (3)
- Oracle ASM (65)
- Oracle Bug (7)
- Oracle RAC (47)
- Oracle 安全 (6)
- Oracle 开发 (27)
- Oracle 监听 (27)
- Oracle备份恢复 (530)
- Oracle安装升级 (84)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (75)
- PostgreSQL (17)
- PostgreSQL恢复 (5)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (36)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (19)
-
最近发表
- Oracle 19c/21c最新patch信息-202404
- PostgreSQL恢复系列:pg_filedump批量处理
- PostgreSQL部分主要字典信息
- PostgreSQL恢复系列:pg_filedump恢复字典构造
- PostgreSQL 16 源码安装
- ORA-00742 ORA-00312 恢复
- 数据库open成功后报ORA-00353 ORA-00354错误引起的一系列问题(本质ntfs文件系统异常)
- ORA-600 ktsiseginfo1故障
- ORA-00600: internal error code, arguments: [16703], [1403], [4] 原因
- 最近遇到几起ORA-600 16703故障(tab$被清空),请引起重视
- ORA-600 2662快速恢复之Patch scn工具
- TNS-12518: TNS:listener could not hand off client connection
- ora.storage无法启动报ORA-12514故障处理
- 断电引起文件scn异常数据库恢复
- ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
- .[hudsonL@cock.li].mkp勒索加密数据库完美恢复
- 模拟带库实现rman远程备份
- 又一例:ORA-600 kclchkblk_4和2662故障
- Oracle误删除数据文件恢复
- Oracle 19C 备库DML重定向—DML Redirection
月归档:四月 2016
Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets—201604
Patchsets |
|
l12.1.0.2 (12.1.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
11.2.0.4 (11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
11.2.0.3 (11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
11.2.0.2 (11.2.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
11.1.0.7 (11.1.0.7.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.2.0.5 (10.2.0.5 PATCH SET FOR ORACLE DATABASE SERVER) |
|
d10.2.0.4 (10.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
e10.2.0.3 (10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.2.0.2 (10.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.1.0.5 (10.1.0.5 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.1.0.4 (10.1.0.4 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.1.0.3 (10.1.0.3 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.8 (9.2.0.8 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.7 (9.2.0.7 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.6 (9.2.0.6 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.5 (ORACLE 9I DATABASE SERVER RELEASE 2 – PATCH SET 4 VERSION 9.2.0.5.0) |
|
9.2.0.4 (9.2.0.4 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.3 (9.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.2 (9.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.0.1.5 (9.0.1.5 PATCHSET) |
|
9.0.1.4 (9.0.1.4 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.0.1.3 (9.0.1.3. PATCH SET FOR ORACLE DATA SERVER) |
|
8.1.7.4 (8.1.7.4 PATCH SET FOR ORACLE DATA SERVER) |
|
8.1.7.3 (8.1.7.3 PATCH SET FOR ORACLE DATA SERVER) |
|
8.1.7.2 (8.1.7.2.1 PATCH SET FOR ORACLE DATA SERVER) |
PSU, SPU(CPU), Bundle Patches
|
|||
12.1.0.2 |
|||
Description |
PSU |
GI PSU |
Bundle Patch (Windows 32bit & 64bit) |
APR2016 |
22291127 (12.1.0.2.160419) |
22646084 (12.1.0.2.160419) |
22809813 (12.1.0.2.160419) |
JAN2016 |
21948354 (12.1.0.2.160119) |
22191349 (12.1.0.2.160119) |
22310559 (12.1.0.2.160119) |
OCT2015 |
21359755 (12.1.0.2.5) |
21523234 (12.1.0.2.5) |
21821214 (12.1.0.2.10) |
JUL2015 |
20831110 (12.1.0.2.4) |
20996835 (12.1.0.2.4) |
21126814 (12.1.0.2.7) |
APR2015 |
20299023 (12.1.0.2.3) |
20485724 (12.1.0.2.3) |
20684004 (12.1.0.2.4) |
JAN2015 |
19769480 (12.1.0.2.2) |
19954978 (12.1.0.2.2) |
19720843 (12.1.0.2.1) |
OCT2014 |
19303936 (12.1.0.2.1) |
19392646 (12.1.0.2.1) |
N/A |
12.1.0.1 |
||||
Description |
PSU |
GI PSU |
Bundle Patch (Windows64bit) |
Bundle Patch (Windows32bit) |
APR2016 |
22291141 (12.1.0.1.160419) |
22839614 (12.1.0.1.160419) |
||
JAN2016 |
21951844 (12.1.0.1.160119) |
22494866 (12.1.0.2.160119) |
||
OCT2015 |
21352619 (12.1.0.1.9) |
21744907 (12.1.0.1.21) |
||
JUL2015 |
20831107 (12.1.0.1.8) |
21076681 (12.1.0.1.20) |
||
APR2015 |
20299016 (12.1.0.1.7) |
20558101 (12.1.0.1.18) |
||
JAN2015 |
19769486 (12.1.0.1.6) |
20160748 (12.1.0.1.16) |
||
OCT2014 |
19121550 (12.1.0.1.5) |
19542943 (12.1.0.1.14) |
||
JUL2014 |
18522516 (12.1.0.1.4) |
19062327 (12.1.0.1.11) |
||
APR2014 |
18031528 (12.1.0.1.3) |
18448604 (12.1.0.1.7) |
||
JAN2014 |
17552800 (12.1.0.1.2) |
17735306 (12.1.0.1.2) |
17977915 (12.1.0.1.3) |
|
OCT2013 |
17027533 (12.1.0.1.1) |
17272829 (12.1.0.1.1) |
17363796 (12.1.0.1.1) |
17363795 (12.1.0.1.1) |
11.2.0.4 |
||||
Description |
PSU |
SPU(CPU) |
GI PSU |
Bundle Patch (Windows 32bit & 64bit) |
APR2016 |
22502456 (11.2.0.4.160419) |
22502493 (11.2.0.4.160419) |
22646198 (11.2.0.4.160419) |
22839608 (11.2.0.4.160419) |
JAN2016 |
21948347 (11.2.0.4.160119) |
21972320 (11.2.0.4.160119) |
22191577 (11.2.0.4.160119) |
22310544 (11.2.0.4.160119) |
OCT2015 |
21352635 (11.2.0.4.8) |
21523375 (11.2.0.4.8) |
21821802 (11.2.0.4.20) |
|
JUL2015 |
20760982 (11.2.0.4.7) |
20996923 (11.2.0.4.7) |
21469106 (11.2.0.4.18) |
|
APR2015 |
20299013 (11.2.0.4.6) |
20485808 (11.2.0.4.6) |
20544696 (11.2.0.4.15) |
|
JAN2015 |
19769489 (11.2.0.4.5) |
19955028 (11.2.0.4.5) |
20127071 (11.2.0.4.12) |
|
OCT2014 |
19121551 (11.2.0.4.4) |
19380115 (11.2.0.4.4) |
19651773 (11.2.0.4.10) |
|
JUL2014 |
18522509 (11.2.0.4.3) |
18706472 (11.2.0.4.3) |
18842982 (11.2.0.4.7) |
|
APR2014 |
18031668 (11.2.0.4.2) |
18139609 (11.2.0.4.2) |
18296644 (11.2.0.4.4) |
|
JAN2014 |
17478514 (11.2.0.4.1) |
N/A |
17987366 (11.2.0.4.1) |
11.2.0.3 |
|||||
Description |
PSU |
SPU(CPU) |
GI PSU |
Bundle Patch (Windows64bit) |
Bundle Patch (Windows32bit) |
aJUL2015 |
20760997 (11.2.0.3.15) |
20996944 (11.2.0.3.15) |
|||
APR2015 |
20299017 (11.2.0.3.14) |
20485830 (11.2.0.3.14) |
|||
JAN2015 |
19769496 (11.2.0.3.13) |
19971343 (11.2.0.3.13) |
|||
OCT2014 |
19121548 (11.2.0.3.12) |
19440385 (11.2.0.3.12) |
|||
JUL2014 |
18522512 (11.2.0.3.11) |
18706488 (11.2.0.3.11) |
|||
APR2014 |
18031683 (11.2.0.3.10) |
18139678 (11.2.0.3.10) |
|||
JAN2014 |
17540582 (11.2.0.3.9) |
17735354 (11.2.0.3.9) |
|||
OCT2013 |
16902043 (11.2.0.3.8) |
17272731 (11.2.0.3.8) |
|||
JUL2013 |
16619892 (11.2.0.3.7) |
16742216 (11.2.0.3.7) |
|||
APR2013 |
16056266 (11.2.0.3.6) |
16083653 (11.2.0.3.6) |
|||
JAN2013 |
14727310 (11.2.0.3.5) |
14727347 (11.2.0.3.5) |
|||
OCT2012 |
14275605 (11.2.0.3.4) |
14275572 (11.2.0.3.4) |
|||
JUL2012 |
13923374 (11.2.0.3.3) |
13919095 (11.2.0.3.3) |
|||
APR2012 |
13696216 (11.2.0.3.2) |
13696251 (11.2.0.3.2) |
|||
JAN2012 |
13343438 (11.2.0.3.1) |
13348650 (11.2.0.3.1) |
11.2.0.2 |
|||||
Description |
PSU |
SPU(CPU) |
GI PSU |
Bundle Patch (Windows64bit) |
Bundle Patch (Windows32bit) |
aOCT2013 |
17082367 (11.2.0.2.12) |
17272753 (11.2.0.2.12) |
|||
JUL2013 |
16619893 (11.2.0.2.11) |
16742320 (11.2.0.2.11) |
|||
APR2013 |
16056267 (11.2.0.2.10) |
16166868 (11.2.0.2.10) |
|||
JAN2013 |
14727315 (11.2.0.2.9) |
14841385 (11.2.0.2.9) |
|||
OCT2012 |
14275621 (11.2.0.2.8) |
14390437 (11.2.0.2.8) |
|||
JUL2012 |
13923804 (11.2.0.2.7) |
14192201 (11.2.0.2.7) |
|||
APR2012 |
13696224 (11.2.0.2.6) |
13696242 (11.2.0.2.6) |
|||
JAN2012 |
13343424 (11.2.0.2.5) |
13653086 (11.2.0.2.5) |
|||
OCT2011 |
12827726 (11.2.0.2.4) |
12827731 (11.2.0.2.4) |
|||
JUL2011 |
12419331 (11.2.0.2.3) |
12419353 (11.2.0.2.3) |
|||
APR2011 |
11724916 (11.2.0.2.2) |
12311357 (11.2.0.2.2) |
|||
JAN2011 |
10248523 (11.2.0.2.1) |
N/A |
N/A |
|
||||
11.2.0.1 |
||||
Description |
PSU |
CPU |
Bundle Patch (Windows64bit) |
Bundle Patch (Windows32bit) |
aJUL2011 |
12419378 (11.2.0.1.6) |
|||
APR2011 |
11724930 (11.2.0.1.5) |
|||
JAN2011 |
10248516 (11.2.0.1.4) |
|||
OCT2010 |
9952216 (11.2.0.1.3) |
|||
JUL2010 |
9654983 (11.2.0.1.2) |
|||
APR2010 |
9352237 (11.2.0.1.1) |
N/A |
N/A |
|
||||
11.1.0.7 |
||||
Description |
PSU |
SPU(CPU) |
Bundle Patch (Windows64bit) |
Bundle Patch (Windows32bit) |
JUL2015 |
20761024 (11.1.0.7.24) |
|||
APR2015 |
20299012 (11.1.0.7.23) |
|||
JAN2015 |
19769499 (11.1.0.7.22) |
|||
OCT2014 |
19152553 (11.1.0.7.21) |
|||
JUL2014 |
18522513 (11.1.0.7.20) |
|||
APR2014 |
18031726 (11.1.0.7.19) |
|||
JAN2014 |
17465583 (11.1.0.7.18) |
|||
OCT2013 |
17082366 (11.1.0.7.17) |
|||
JUL2013 |
16619896 (11.1.0.7.16) |
|||
APR2013 |
16056268 (11.1.0.7.15) |
|||
JAN2013 |
14739378 (11.1.0.7.14) |
|||
OCT2012 |
14275623 (11.1.0.7.13) |
|||
JUL2012 |
13923474 (11.1.0.7.12) |
|||
APR2012 |
13621679 (11.1.0.7.11) |
|||
JAN2012 |
13343461 (11.1.0.7.10) |
|||
OCT2011 |
12827740 (11.1.0.7.9) |
|||
JUL2011 |
12419384 (11.1.0.7.8) |
|||
APR2011 |
11724936 (11.1.0.7.7) |
|||
JAN2011 |
10248531 (11.1.0.7.6) |
|||
OCT2010 |
9952228 (11.1.0.7.5) |
|||
JUL2010 |
9654987 (11.1.0.7.4) |
|||
APR2010 |
9352179 (11.1.0.7.3) |
|||
JAN2010 |
9209238 (11.1.0.7.2) |
|||
OCT2009 |
8833297 (11.1.0.7.1) |
|||
JUL2009 |
N/A |
|||
APR2009 |
N/A |
|
|||
11.1.0.6 |
|||
Description |
CPU |
Bundle Patch (Windows64bit) |
Bundle Patch (Windows32bit) |
aJUL2009 |
|||
APR2009 |
|||
JAN2009 |
|||
OCT2008 |
|||
JUL2008 |
|||
APR2008 |
|
|||||
10.2.0.5 |
|||||
Description |
PSU |
SPU(CPU) |
Bundle Patch (Windows64bit) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
bJUL2015 |
20299014 (10.2.0.5.19) |
N/A |
|||
APR2015 |
N/A |
N/A |
N/A |
N/A |
N/A |
JAN2015 |
19769505 (10.2.0.5.18) |
N/A |
|||
OCT2014 |
19274523 (10.2.0.5.17) |
N/A |
|||
JUL2014 |
18522511 (10.2.0.5.16) |
N/A |
|||
APR2014 |
18031728 (10.2.0.5.15) |
N/A |
|||
JAN2014 |
17465584 (10.2.0.5.14) |
N/A |
|||
OCT2014 |
17082365 (10.2.0.5.13) |
N/A |
N/A |
||
JUL2013 |
16619894 (10.2.0.5.12) |
||||
APR2013 |
16056270 (10.2.0.5.11) |
||||
JAN2013 |
14727319 (10.2.0.5.10) |
||||
OCT2012 |
14275629 (10.2.0.5.9) |
||||
JUL2012 |
13923855 (10.2.0.5.8) |
||||
APR2012 |
13632743 (10.2.0.5.7) |
||||
JAN2012 |
13343471 (10.2.0.5.6) |
N/A |
|||
OCT2011 |
12827745 (10.2.0.5.5) |
c12914913 |
N/A |
||
JUL2011 |
12419392 (10.2.0.5.4) |
N/A |
|||
APR2011 |
11724962 (10.2.0.5.3) |
N/A |
|||
JAN2011 |
10248542 (10.2.0.5.2) |
N/A |
|||
OCT2010 |
9952230 (10.2.0.5.1) |
N/A |
|
|||||
10.2.0.4 |
|||||
Description |
PSU |
SPU(CPU) |
Bundle Patch (Windows32bit) |
Bundle Patch (Windows64bit) |
Bundle Patch (WindowsItanium) |
gJUL2013 |
16619897 (10.2.0.4.17) |
16742253 |
N/A |
N/A |
N/A |
gAPR2013 |
16056269 (10.2.0.4.16) |
16270931 |
N/A |
N/A |
N/A |
gJAN2013 |
14736542 (10.2.0.4.15) |
14841471 |
N/A |
N/A |
N/A |
gOCT2012 |
14275630 (10.2.0.4.14) |
14390410 |
N/A |
N/A |
N/A |
gJUL2012 |
13923851 (10.2.0.4.13) |
14038814 |
N/A |
N/A |
N/A |
aAPR2012 |
12879933 (10.2.0.4.12) |
N/A |
|||
JAN2012 |
12879929 (10.2.0.4.11) |
N/A |
N/A |
||
OCT2011 |
12827778 (10.2.0.4.10) |
||||
JUL2011 |
12419397 (10.2.0.4.9) |
||||
APR2011 |
11724977 (10.2.0.4.8) |
||||
JAN2011 |
10248636 (10.2.0.4.7) |
||||
OCT2010 |
9952234 (10.2.0.4.6) |
||||
JUL2010 |
9654991 (10.2.0.4.5) |
||||
APR2010 |
9352164 (10.2.0.4.4) |
||||
JAN2010 |
9119284 (10.2.0.4.3) |
||||
OCT2009 |
8833280 (10.2.0.4.2) |
||||
JUL2009 |
8576156 (10.2.0.4.1) |
||||
APR2009 |
N/A |
||||
JAN2009 |
N/A |
N/A |
|||
OCT2008 |
N/A |
N/A |
|||
JUL2008 |
N/A |
N/A |
|
||||
10.2.0.3 |
||||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
Bundle Patch (Windows64bit) |
aJAN2009 |
||||
OCT2008 |
||||
JUL2008 |
||||
APR2008 |
||||
JAN2008 |
||||
OCT2007 |
||||
JUL2007 |
||||
APR2007 |
||||
JAN2007 |
|
||||
10.2.0.2 |
||||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (Windows64bit) |
Bundle Patch (WindowsItanium) |
iJAN2009 |
N/A |
N/A |
N/A |
|
hOCT2008 |
N/A |
N/A |
N/A |
|
hJUL2008 |
N/A |
N/A |
N/A |
|
hAPR2008 |
N/A |
N/A |
N/A |
|
aJAN2008 |
N/A |
N/A |
N/A |
|
fOCT2007 |
||||
JUL2007 |
||||
APR2007 |
||||
JAN2007 |
||||
OCT2006 |
||||
JUL2006 |
||||
APR2006 |
|
||||
10.2.0.1 |
||||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (Windows64bit) |
Bundle Patch (WindowsItanium) |
APR2007 |
N/A |
N/A |
N/A |
|
JAN2007 |
||||
OCT2006 |
||||
JUL2006 |
||||
APR2006 |
||||
JAN2006 |
|
|||
10.1.0.5 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
JAN2012 |
|||
OCT2011 |
|||
JUL2011 |
|||
APR2011 |
|||
JAN2011 |
N/A |
N/A |
N/A |
OCT2010 |
|||
JUL2010 |
|||
APR2010 |
|||
JAN2010 |
|||
OCT2009 |
|||
JUL2009 |
|||
APR2009 |
|||
JAN2009 |
|||
OCT2008 |
|||
JUL2008 |
|||
APR2008 |
|||
JAN2008 |
|||
OCT2007 |
|||
JUL2007 |
|||
APR2007 |
|||
JAN2007 |
|||
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
|
|||
10.1.0.4 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
APR2007 |
|||
JAN2007 |
|||
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
|||
APR2005 |
|
|||
10.1.0.3 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
JAN2007 |
N/A |
N/A |
|
OCT2006 |
N/A |
N/A |
|
JUL2006 |
N/A |
N/A |
|
APR2006 |
N/A |
N/A |
|
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
|||
APR2005 |
|||
JAN2005 |
|
|||
10.1.0.2 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
APR2005 |
|||
JUL2005 |
|||
JAN2005 |
|
|||
9.2.0.8 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
JUL2010 |
|||
APR2010 |
N/A |
||
JAN2010 |
N/A |
||
OCT2009 |
|||
JUL2009 |
|||
APR2009 |
|||
JAN2009 |
|||
OCT2008 |
|||
JUL2008 |
|||
APR2008 |
|||
JAN2008 |
|||
OCT2007 |
|||
JUL2007 |
|||
APR2007 |
|||
JAN2007 |
N/A |
N/A |
N/A |
OCT2006 |
|
|||
9.2.0.7 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
JUL2007 |
|||
APR2007 |
|||
JAN2007 |
|||
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
N/A |
N/A |
|
|||
9.2.0.6 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
|||
APR2005 |
|
|||
9.2.0.5 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
OCT2006 |
N/A |
N/A |
|
JUL2006 |
N/A |
N/A |
|
APR2006 |
N/A |
N/A |
|
OCT2005 |
N/A |
N/A |
|
JUL2005 |
|||
APR2005 |
|||
JAN2005 |
|
|||
9.2.0.4 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
JAN2005 |
|
||
8.1.7.4 |
||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
JAN2007 |
||
OCT2006 |
||
JUL2006 |
||
APR2006 |
||
JAN2006 |
||
OCT2005 |
||
JUL2005 |
||
APR2005 |
||
JAN2005 |
OJVM PSU Patches
|
||||
12.1.0.2 |
||||
Description |
OJVM PSU (Linux/Unix) |
OJVM BP (Windows) |
Combo OJVM + DB PSU |
Combo OJVM + GI PSU |
APR2016 |
22674709 (12.1.0.2.160419) |
22839633 (12.1.0.2.160419) |
22738582 (12.1.0.2.160419) |
22738641 (12.1.0.2.160419) |
JAN2016 |
22139226 (12.1.0.2.160119) |
22311086 (12.1.0.2.160119) |
22191659 (12.1.0.2.160119) |
22191676 (12.1.0.2.160119) |
OCT2015 |
21555660 (12.1.0.2.5) |
21788394 (12.1.0.2.4) |
||
JUL2015 |
21068507 (12.1.0.2.4) |
21153530 (12.1.0.2.3) |
||
APR2015 |
20415564 (12.1.0.2.3) |
20391199 (12.1.0.2.2) |
||
JAN2015 |
19877336 (12.1.0.2.2) |
20225938 (12.1.0.2.1) |
||
OCT2014 (12.1.0.2.1) |
|
|
|||||
12.1.0.1 |
|||||
Description |
OJVM PSU (Linux/Unix) |
OJVM BP (Windows) |
Combo OJVM + DB PSU |
Combo OJVM + GI PSU |
Generic JDBC |
APR2016 (12.1.0.1.160419) |
Included in OJVM PSU |
||||
JAN2016 (12.1.0.1.160119) |
|||||
OCT2015 (12.1.0.1.5) |
|||||
JUL2015 (12.1.0.1.4) |
|||||
APR2015 (12.1.0.1.3) |
|||||
JAN2015 (12.1.0.1.2) |
|||||
OCT2014 (12.1.0.1.1) |
|
||||||
11.2.0.4 |
||||||
Description |
OJVM PSU (Linux/Unix) |
OJVM BP (Windows) |
Combo OJVM + DB PSU |
Combo OJVM + DB SPU |
Combo OJVM + GI PSU |
Generic JDBC |
APR2016 (11.2.0.4.160419) |
Included in OJVM PSU |
|||||
JAN2016 (11.2.0.4.160119) |
||||||
OCT2015 (11.2.0.4.5) |
||||||
JUL2015 (11.2.0.4.4) |
||||||
APR2015 (11.2.0.4.3) |
||||||
JAN2015 (11.2.0.4.2) |
||||||
OCT2014 (11.2.0.4.1) |
|
||||||
11.2.0.3 |
||||||
Description |
OJVM PSU (Linux/Unix) |
OJVM BP (Windows) |
Combo OJVM + DB PSU |
Combo OJVM + DB SPU |
Combo OJVM + GI PSU |
Generic JDBC |
JUL2015 (11.2.0.3.4) |
Included in OJVM PSU |
|||||
APR2015 (11.2.0.3.3) |
||||||
JAN2015 (11.2.0.3.2) |
||||||
OCT2014 (11.2.0.3.1) |
|
||||||
11.1.0.7 |
||||||
Description |
OJVM PSU (Linux/Unix) |
OJVM BP (Windows) |
Combo OJVM + DB PSU |
Combo OJVM + DB SPU |
Combo OJVM + GI PSU |
Generic JDBC |
JUL2015 (11.1.0.7.4) |
21068565 |
N/A |
Included in OJVM PSU |
|||
APR2015 (11.1.0.7.3) |
N/A |
|||||
JAN2015 (11.1.0.7.2) |
N/A |
|||||
OCT2014 (11.1.0.7.1) |
N/A |
参考:Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets (文档 ID 1454618.1)
分析drop col对于数据存储块做了什么
oracle 的alter table drop col具体内部是对于数据存储块操作的,如果drop col之后dul之类的工具是否可以恢复,这里我通过具体测试,结合bbed,dump block等方法来说明该问题
1.创建测试表,并写入硬盘
SQL> create table xff.t_xifenfei as select object_id,owner,object_name from dba_objects; Table created. SQL> desc xff.t_xifenfei Name Null? Type ----------------------------------------- -------- ---------------------------- OBJECT_ID NUMBER OWNER VARCHAR2(30) OBJECT_NAME VARCHAR2(128) SQL> alter system checkpoint; System altered. SQL> alter system checkpoint; System altered.
2.找出来测试表一个block分析drop col对于存储的影响
SQL> select rowid, 2 dbms_rowid.rowid_relative_fno(rowid)rel_fno, 3 dbms_rowid.rowid_block_number(rowid)blockno, dbms_rowid.rowid_row_number(rowid) rowno,object_id 4 5 from xff.t_xifenfei where rownum<5; ROWID REL_FNO BLOCKNO ROWNO OBJECT_ID ------------------ ---------- ---------- ---------- ---------- AAAZ9wAAEAAAJojAAA 4 39459 0 20 AAAZ9wAAEAAAJojAAB 4 39459 1 46 AAAZ9wAAEAAAJojAAC 4 39459 2 28 AAAZ9wAAEAAAJojAAD 4 39459 3 15
3. dump block,并且记录该block 1,2,和最后一条记录
SQL> oradebug setmypid Statement processed. SQL> alter system dump datafile 4 block 39459; System altered. SQL> oradebug TRACEFILE_NAME /home/u01/diag/rdbms/orcl/orcl/trace/orcl_ora_14069.trc block_row_dump: tab 0, row 0, @0x1f70 tl: 16 fb: --H-FL-- lb: 0x0 cc: 3 col 0: [ 2] c1 15 col 1: [ 3] 53 59 53 col 2: [ 5] 49 43 4f 4c 24 tab 0, row 1, @0x1f5e tl: 18 fb: --H-FL-- lb: 0x0 cc: 3 col 0: [ 2] c1 2f col 1: [ 3] 53 59 53 col 2: [ 7] 49 5f 55 53 45 52 31 ………… tab 0, row 288, @0x589 tl: 22 fb: --H-FL-- lb: 0x0 cc: 3 col 0: [ 3] c2 03 5b col 1: [ 3] 53 59 53 col 2: [10] 49 5f 4a 4f 42 5f 4e 45 58 54
4. 使用bbed查看该block 1,2,和最后一条记录
[oracle@localhost ~]$ bbed password=blockedit blocksize=8192 filename=/usr/local/oradata/qsng/users01.dbf BBED: Release 2.0.0.0.0 - Limited Production on Sun Apr 3 22:25:28 2016 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ************* !!! For Oracle Internal Use only !!! *************** BBED> set block 39459 BLOCK# 39459 BBED> map File: /usr/local/oradata/qsng/users01.dbf (0) Block: 39459 Dba:0x00000000 ------------------------------------------------------------ KTB Data Block (Table/Cluster) struct kcbh, 20 bytes @0 struct ktbbh, 96 bytes @20 struct kdbh, 14 bytes @124 struct kdbt[1], 4 bytes @138 sb2 kdbr[289] @142 ub1 freespace[821] @720 ub1 rowdata[6647] @1541 ub4 tailchk @8188 BBED> p *kdbr[0] rowdata[6631] ------------- ub1 rowdata[6631] @8172 0x2c BBED> x /rncc rowdata[6631] @8172 ------------- flag@8172: 0x2c (KDRHFL, KDRHFF, KDRHFH) lock@8173: 0x00 cols@8174: 3 col 0[2] @8175: 20 col 1[3] @8178: SYS col 2[5] @8182: ICOL$ BBED> d File: /usr/local/oradata/qsng/users01.dbf (0) Block: 39459 Offsets: 8172 to 8191 Dba:0x00000000 ------------------------------------------------------------------------ 2c000302 c1150353 59530549 434f4c24 02067576 <32 bytes per line> BBED> p *kdbr[1] rowdata[6613] ------------- ub1 rowdata[6613] @8154 0x2c BBED> x /rncc rowdata[6613] @8154 ------------- flag@8154: 0x2c (KDRHFL, KDRHFF, KDRHFH) lock@8155: 0x00 cols@8156: 3 col 0[2] @8157: 46 col 1[3] @8160: SYS col 2[7] @8164: I_USER1 BBED> d File: /usr/local/oradata/qsng/users01.dbf (0) Block: 39459 Offsets: 8154 to 8191 Dba:0x00000000 ------------------------------------------------------------------------ 2c000302 c12f0353 59530749 5f555345 52312c00 0302c115 03535953 0549434f 4c240206 7576 <32 bytes per line> BBED> p *kdbr[288] rowdata[0] ---------- ub1 rowdata[0] @1541 0x2c BBED> x /rncc rowdata[0] @1541 ---------- flag@1541: 0x2c (KDRHFL, KDRHFF, KDRHFH) lock@1542: 0x00 cols@1543: 3 col 0[3] @1544: 290 col 1[3] @1548: SYS col 2[10] @1552: I_JOB_NEXT BBED> set count 32 COUNT 32 BBED> d File: /usr/local/oradata/qsng/users01.dbf (0) Block: 39459 Offsets: 1541 to 1572 Dba:0x00000000 ------------------------------------------------------------------------ 2c000303 c2035b03 5359530a 495f4a4f 425f4e45 58542c00 0303c203 5a035359 <32 bytes per line>
5. 删除中间列,并且写入硬盘
SQL> ALTER TABLE XFF.T_XIFENFEI DROP COLUMN owner; Table altered. SQL> alter system checkpoint; System altered. SQL> / System altered.
6. 查询确定相同行所在block没有发生改变
SQL> select rowid, 2 dbms_rowid.rowid_relative_fno(rowid)rel_fno, 3 dbms_rowid.rowid_block_number(rowid)blockno, dbms_rowid.rowid_row_number(rowid) rowno,object_id 4 5 from xff.t_xifenfei where rownum<5; ROWID REL_FNO BLOCKNO ROWNO OBJECT_ID ------------------ ---------- ---------- ---------- ---------- AAAZ9wAAEAAAJojAAA 4 39459 0 20 AAAZ9wAAEAAAJojAAB 4 39459 1 46 AAAZ9wAAEAAAJojAAC 4 39459 2 28 AAAZ9wAAEAAAJojAAD 4 39459 3 15
7. drop col之后dump block继续分析
SQL> alter system dump datafile 4 block 39459; System altered. SQL> select value from v$diag_info where name='Default Trace File'; VALUE -------------------------------------------------------------------------------- /home/u01/diag/rdbms/orcl/orcl/trace/orcl_ora_14784.trc SQL> tab 0, row 0, @0x1f70 tl: 12 fb: --H-FL-- lb: 0x2 cc: 2 col 0: [ 2] c1 15 col 1: [ 5] 49 43 4f 4c 24 tab 0, row 1, @0x1f5e tl: 14 fb: --H-FL-- lb: 0x2 cc: 2 col 0: [ 2] c1 2f col 1: [ 7] 49 5f 55 53 45 52 31 ………… tab 0, row 288, @0x589 tl: 18 fb: --H-FL-- lb: 0x2 cc: 2 col 0: [ 3] c2 03 5b col 1: [10] 49 5f 4a 4f 42 5f 4e 45 58 54
8. 使用bbed查看drop col后的数据存储情况
$ bbed password=blockedit blocksize=8192 filename=/usr/local/oradata/qsng/users01.dbf BBED: Release 2.0.0.0.0 - Limited Production on Sun Apr 3 22:31:37 2016 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ************* !!! For Oracle Internal Use only !!! *************** BBED> set block 39459 BLOCK# 39459 BBED> map File: /usr/local/oradata/qsng/users01.dbf (0) Block: 39459 Dba:0x00000000 ------------------------------------------------------------ KTB Data Block (Table/Cluster) struct kcbh, 20 bytes @0 struct ktbbh, 96 bytes @20 struct kdbh, 14 bytes @124 struct kdbt[1], 4 bytes @138 sb2 kdbr[289] @142 ub1 freespace[821] @720 ub1 rowdata[6647] @1541 ub4 tailchk @8188 BBED> p *kdbr[0] rowdata[6631] ------------- ub1 rowdata[6631] @8172 0x2c BBED> x /rncc rowdata[6631] @8172 ------------- flag@8172: 0x2c (KDRHFL, KDRHFF, KDRHFH) lock@8173: 0x02 cols@8174: 2 col 0[2] @8175: 20 col 1[5] @8178: ICOL$ BBED> d File: /usr/local/oradata/qsng/users01.dbf (0) Block: 39459 Offsets: 8172 to 8191 Dba:0x00000000 ------------------------------------------------------------------------ 2c020202 c1150549 434f4c24 434f4c24 0106de78 <32 bytes per line> BBED> p *kdbr[1] rowdata[6613] ------------- ub1 rowdata[6613] @8154 0x2c BBED> x /rncc rowdata[6613] @8154 ------------- flag@8154: 0x2c (KDRHFL, KDRHFF, KDRHFH) lock@8155: 0x02 cols@8156: 2 col 0[2] @8157: 46 col 1[7] @8160: I_USER1 BBED> d File: /usr/local/oradata/qsng/users01.dbf (0) Block: 39459 Offsets: 8154 to 8191 Dba:0x00000000 ------------------------------------------------------------------------ 2c020202 c12f0749 5f555345 52315345 52312c02 0202c115 0549434f 4c24434f 4c240106 de78 <32 bytes per line> BBED> p *kdbr[288] rowdata[0] ---------- ub1 rowdata[0] @1541 0x2c BBED> set count 32 COUNT 32 BBED> x /rncc rowdata[0] @1541 ---------- flag@1541: 0x2c (KDRHFL, KDRHFF, KDRHFH) lock@1542: 0x02 cols@1543: 2 col 0[3] @1544: 290 col 1[10] @1548: I_JOB_NEXT BBED> d File: /usr/local/oradata/qsng/users01.dbf (0) Block: 39459 Offsets: 1541 to 1572 Dba:0x00000000 ------------------------------------------------------------------------ 2c020203 c2035b0a 495f4a4f 425f4e45 58544e45 58542c02 0203c203 5a09495f <32 bytes per line>
通过上述测试可以得出如下结论:
1. drop col是真的把对应列存储在block中的内容除掉,而且把后面的列的内容前移了,并且以前多于的内容(因为一行内容前移,后面就出现空闲记录不设置为空,而就是最初内容,下次如果行长度发生改变的时候使用,就和类似update把列修改短了一样)
2. drop col只是导致一行的长度变短,但是每行的偏移量未发生改变,也就是说,每行所在的偏移量没有改变,drop col之后,每行后面多了一些空闲空间
3. 根据上面分析的原理,drop col 是真的从block内部把这一列的数据使用后面列的数据覆盖了,因此从原理上而言,dul无法恢复drop col的数据(最后一列有可能可以恢复,因为他不会被覆盖),对于drop col,只能是通过备份不完全恢复,全库闪回,dg延迟应用等方法解决
ADHU(ASM Disk Header Utility)—asm disk header备份恢复工具
adhu(ASM Disk Header Utility)作为oracle asm中和kfed,amdu齐名的asm三大恢复神器之一,没有被oracle大力推广(属于内部工具),随着kfed功能增强和asm disk header自动备份功能的完善,adhu oracle基本上停止的开发支持,可以用来作为10.2.0.5之前asm版本的磁盘头保护工具
adhu预览
这里可以通过shell封装的utildhu调用adhu程序,实现更加人性化和自动化操作,它含有install,check,repair三个命令参数.
[root@xff1 tmp]# su - grid xff1:/home/grid> cd /tmp/adhu/ xff1:/tmp/adhu> ls -l total 68 -rwxr-xr-x 1 grid oinstall 18902 Nov 1 2008 adhu -rw-r--r-- 1 grid oinstall 1970 Nov 1 2008 README -rwxr-xr-x 1 grid oinstall 6964 Mar 21 16:20 utildhu -rw-r--r-- 1 root root 12634 Mar 21 16:05 utildhu.zip xff1:/tmp/adhu> ./utildhu Usage: utildhu install/check/repair [device name] $utildhu install Will gather a list of member ASM disks and create the backup directory ./HeaderBackup The ./HeaderBackup directory will contain the backup header of every asm disk in this database $utildhu check Will run /tmp/adhu/adhu for every disk discovered by $utildhu install and will email recipients configured in RECIPIENTS if there are errors in the disk header It is hoped that the user will enter valid RECIPIENT email addresses, and will place this utility in $ORA_ASM_HOME $utildhu repair <device name> Will repair the device provided using the backup header blocks that have been copied previously. This does assume that you have backup header blocks in ./HeaderBackup Sample crontab entry to run a check every 5 minutes #Minute (0-59) Hour (0-23) Day of Month (1-31) Month (1-12 or Jan-Dec) Day of Week (0-6 or Sun-Sat) Command 0,5,10,15,20,25,30,35,40,45,50,55 * * * * * utildhu check Please read the README for more information
adhu install
install主要是实现utildhu.config配置文件生成和第一次asm 磁盘头备份
xff1:/tmp/adhu> ./utildhu install xff1:/tmp/adhu> ls -l total 64 -rwxr-xr-x 1 grid oinstall 18902 Nov 1 2008 adhu drwxr-xr-x 2 grid oinstall 4096 Mar 21 16:23 HeaderBackup -rw-r--r-- 1 grid oinstall 1117 Mar 21 16:23 persistent-log.utildhu -rw-r--r-- 1 grid oinstall 1970 Nov 1 2008 README -rwxr-xr-x 1 grid oinstall 6964 Mar 21 16:20 utildhu -rw-r--r-- 1 grid oinstall 243 Mar 21 16:23 utildhu.config -rw-r--r-- 1 grid oinstall 710 Mar 21 16:23 utildhu.out -rw-r--r-- 1 root root 12634 Mar 21 16:05 utildhu.zip xff1:/tmp/adhu> cd HeaderBackup/ xff1:/tmp/adhu/HeaderBackup> ls -ltr total 12 -rw-r--r-- 1 grid oinstall 4096 Mar 21 16:23 oradata1p1 -rw-r--r-- 1 grid oinstall 4096 Mar 21 16:23 oradata2p1 -rw-r--r-- 1 grid oinstall 4096 Mar 21 16:23 ocrvotep1 xff1:/tmp/adhu/HeaderBackup> more ../utildhu.config /dev/mapper/oradata1p1 /dev/mapper/oradata2p1 /dev/mapper/ocrvotep1 xff1:/tmp/adhu> more ../persistent-log.utildhu Mon Mar 21 16:23:29 CST 2016 ASM Disk Header Check Utility Installed on Devices configured are: /dev/mapper/oradata1p1 /dev/mapper/oradata2p1 /dev/mapper/ocrvotep1 ADHU: /dev/mapper/oradata1p1: Status 0x01 Mon Mar 21 16:23:29 2016 ADHU: /dev/mapper/oradata1p1: Diskgroup:DATA Disk:DATA_0000 #0 ADHU: /dev/mapper/oradata1p1: valid disk header found ADHU: /dev/mapper/oradata1p1: backup block updated ###ADHU check run at Mon Mar 21 16:23:29 CST 2016 NO ERRORS FOUND xff1:/tmp/adhu> ls -l HeaderBackup/ total 16 -rw-r--r-- 1 grid oinstall 4096 Mar 21 23:04 ocrvotep1 -rw-r--r-- 1 grid oinstall 4096 Mar 21 23:08 oradata1p1 -rw-r--r-- 1 grid oinstall 4096 Mar 21 23:08 oradata1p1.corrupt -rw-r--r-- 1 grid oinstall 4096 Mar 21 23:04 oradata2p1
adhu check
对于正常的asm disk,主要是为了生成新的磁盘头备份
xff1:/tmp/adhu> ls -l HeaderBackup/ total 16 -rw-r--r-- 1 grid oinstall 4096 Mar 21 23:04 ocrvotep1 -rw-r--r-- 1 grid oinstall 4096 Mar 21 23:08 oradata1p1 -rw-r--r-- 1 grid oinstall 4096 Mar 21 23:08 oradata1p1.corrupt -rw-r--r-- 1 grid oinstall 4096 Mar 21 23:04 oradata2p1 xff1:/tmp/adhu> ./utildhu check xff1:/tmp/adhu> ls -l HeaderBackup/ total 16 -rw-r--r-- 1 grid oinstall 4096 Mar 21 23:11 ocrvotep1 -rw-r--r-- 1 grid oinstall 4096 Mar 21 23:11 oradata1p1 -rw-r--r-- 1 grid oinstall 4096 Mar 21 23:08 oradata1p1.corrupt -rw-r--r-- 1 grid oinstall 4096 Mar 21 23:11 oradata2p1
adhu repair
repair主要是修复磁盘头,当asm 磁盘头损坏之时,可以通过这个命令实现磁盘头修复
xff1:/tmp/adhu> dd if=/dev/zero of=/dev/mapper/oradata1p1 bs=4096 count=1 1+0 records in 1+0 records out 4096 bytes (4.1 kB) copied, 0.000282838 s, 14.5 MB/s xff1:/tmp/adhu> ./utildhu check xff1:/tmp/adhu> tail -f persistent-log.utildhu ###ADHU check run at Mon Mar 21 23:04:04 CST 2016 ERRORS FOUND ADHU: /dev/mapper/oradata1p1: Status 0x08 Mon Mar 21 23:04:04 2016 ADHU: /dev/mapper/oradata1p1: Diskgroup:DATA Disk:DATA_0000 #0 ADHU: /dev/mapper/oradata1p1: corrupt disk header encountered ADHU: /dev/mapper/oradata1p1: valid backup block found ADHU: /dev/mapper/oradata1p1: CORRUPT HEADER NOT REPAIRED xff1:/tmp/adhu> kfed read /dev/mapper/oradata1p1 kfbh.endian: 0 ; 0x000: 0x00 kfbh.hard: 0 ; 0x001: 0x00 kfbh.type: 0 ; 0x002: KFBTYP_INVALID kfbh.datfmt: 0 ; 0x003: 0x00 kfbh.block.blk: 0 ; 0x004: blk=0 kfbh.block.obj: 0 ; 0x008: file=0 kfbh.check: 0 ; 0x00c: 0x00000000 kfbh.fcn.base: 0 ; 0x010: 0x00000000 kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 kfbh.spare1: 0 ; 0x018: 0x00000000 kfbh.spare2: 0 ; 0x01c: 0x00000000 7F6BD9981400 00000000 00000000 00000000 00000000 [................] Repeat 255 times KFED-00322: Invalid content encountered during block traversal: [kfbtTraverseBlock][Invalid OSM block type][][0] xff1:/tmp/adhu> sqlplus / as sysasm SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 23:07:25 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management options SQL> alter diskgroup data dismount; alter diskgroup data dismount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15027: active use of diskgroup "DATA" precludes its dismount SQL> alter diskgroup data mount; alter diskgroup data mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15017: diskgroup "DATA" cannot be mounted ORA-15013: diskgroup "DATA" is already mounted SQL> alter diskgroup data dismount force; Diskgroup altered. SQL> alter diskgroup data mount; alter diskgroup data mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15017: diskgroup "DATA" cannot be mounted ORA-15040: diskgroup is incomplete xff1:/tmp/adhu> ./utildhu repair /dev/mapper/oradata1p1 DEVICE /dev/mapper/oradata1p1 REPAIRED AT Mon Mar 21 23:06:06 CST 2016 ADHU: /dev/mapper/oradata1p1: Status 0x04 Mon Mar 21 23:06:06 2016 ADHU: /dev/mapper/oradata1p1: Diskgroup:DATA Disk:DATA_0000 #0 ADHU: /dev/mapper/oradata1p1: corrupt disk header encountered ADHU: /dev/mapper/oradata1p1: valid backup block found ADHU: /dev/mapper/oradata1p1: disk header repaired xff1:/tmp/adhu> sqlplus / as sysasm SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 23:08:48 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management options SQL> alter diskgroup data mount; Diskgroup altered.
adhu直接使用
adhu [-dir dirname ] [-repair] [-quiet] [-readonly] [-syslog mask ] devname
默认情况下adhu将disk header备份为当前目录下的备份文件。 使用-dir选项可以指定存放的目录。
当需要使用adhu去修复一个损坏的asm disk header时使用-repair 选项。
-quiet 选项将过滤所有正常的输出信息,若执行成功则不打印任何输出。
-readonly选项 以只读方式来打开disk device,这样备份block将不被写入,而备份文件将在可能的情况下写入。
-syslog选项控制是否写出结果到系统日志和标准输出。
devname代表为asm disk的设备文件,asm头的备份文件将以该device name为基础,并存放在当前目录或者-dir指定的目录。