联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
有一朋友医院客户的oracle数据库所在服务器被加密,导致数据库无法正常工作
E-Mail:dba@xifenfei.com
联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
| Patchsets | |
| 12.1.0.2 (12.1.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER) | 21419221 |
| 11.2.0.4 (11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER) | 13390677 |
| 11.2.0.3 (11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER) | 10404530 |
| 11.2.0.2 (11.2.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER) | 10098816 |
| 11.1.0.7 (11.1.0.7.0 PATCH SET FOR ORACLE DATABASE SERVER) | 6890831 |
| 10.2.0.5 (10.2.0.5 PATCH SET FOR ORACLE DATABASE SERVER) | 8202632 |
| A10.2.0.4 (10.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER) | 6810189 |
| B10.2.0.3 (10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER) | 5337014 |
| 10.2.0.2 (10.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER) | 4547817 |
| 10.1.0.5 (10.1.0.5 PATCH SET FOR ORACLE DATABASE SERVER) | 4505133 |
| 10.1.0.4 (10.1.0.4 PATCH SET FOR ORACLE DATABASE SERVER) | 4163362 |
| 10.1.0.3 (10.1.0.3 PATCH SET FOR ORACLE DATABASE SERVER) | 3761843 |
| 9.2.0.8 (9.2.0.8 PATCH SET FOR ORACLE DATABASE SERVER) | 4547809 |
| 9.2.0.7 (9.2.0.7 PATCH SET FOR ORACLE DATABASE SERVER) | 4163445 |
| 9.2.0.6 (9.2.0.6 PATCH SET FOR ORACLE DATABASE SERVER) | 3948480 |
| 9.2.0.5 (ORACLE 9I DATABASE SERVER RELEASE 2 – PATCH SET 4 VERSION 9.2.0.5.0) | 3501955 |
| 9.2.0.4 (9.2.0.4 PATCH SET FOR ORACLE DATABASE SERVER) | 3095277 |
| 9.2.0.3 (9.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER) | 2761332 |
| 9.2.0.2 (9.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER) | 2632931 |
| 9.0.1.5 (9.0.1.5 PATCHSET) | 3301544 |
| 9.0.1.4 (9.0.1.4 PATCH SET FOR ORACLE DATABASE SERVER) | 2517300 |
| 9.0.1.3 (9.0.1.3. PATCH SET FOR ORACLE DATA SERVER) | 2271678 |
| 8.1.7.4 (8.1.7.4 PATCH SET FOR ORACLE DATA SERVER) | 2376472 |
| 8.1.7.3 (8.1.7.3 PATCH SET FOR ORACLE DATA SERVER) | 2189751 |
| 8.1.7.2 (8.1.7.2.1 PATCH SET FOR ORACLE DATA SERVER) | 1909158 |
| 19.0.0.0 | |||
| Description | OJVM Update | OJVM + DB Update | OJVM + GI Update |
| OCT2020 (19.9.0.0.201020) | 31668882 | 31720396 | 31720429 |
| JUL2020 (19.8.0.0.200714) | 31219897 | 31326362 | 31326369 |
| APR2020 (19.7.0.0.200414) | 30805684 | 30783543 | 30783556 |
| JAN2020 (19.6.0.0.200114) | 30484981 | 30463595 | 30463609 |
| OCT2019 (19.5.0.0.191015) | 30128191 | 30133124 | 30133178 |
| JUL2019 (19.4.0.0.190716) | 29774421 | 29699079 | 29699097 |
| APR2019 (19.3.0.0.190416) | 29548437 | 29621253 | 29621299 |
| 19.0.0.0 | ||||
| Release | DB Revision 1 | DB Revision 2 | GI Revision 1 | GI Revision 2 |
| OCT2020 | 31666885 (19.8.1.0.0) | 31667176 (19.7.2.0.0) | 31719890 (19.8.1.0.0) | 31719845 (19.7.2.0.0) |
| JUL2020 | 31204483 (19.7.1.0.0) | 31212138 (19.6.2.0.0) | 31326441 (19.7.1.0.0) | 31326451 (19.6.2.0.0) |
| APR2020 | 30797938 (19.6.1.0.0) | 30830913 (19.5.2.0.0) | 30923276 (19.6.1.0.0) | 30923448 (19.5.2.0.0) |
| JAN2020 | 30446054 (19.5.1.0.0) | 30446228 (19.4.2.0.0) | 30464035 (19.5.1.0.0) | 30463911 (19.4.2.0.0) |
| OCT2019 | 30080447 (19.4.1.0.0) | 30087906 (19.3.2.0.0) | 30134717 (19.4.1.0.0) | 30135696 (19.3.2.0.0) |
| 19.0.0.0 | |||
| Description | OJVM Update | OJVM + DB Update | OJVM + GI Update |
| JUL2020 (19.8.0.0.200714) | 31219897 | 31326362 | 31326369 |
| APR2020 (19.7.0.0.200414) | 30805684 | 30783543 | 30783556 |
| JAN2020 (19.6.0.0.200114) | 30484981 | 30463595 | 30463609 |
| OCT2019 (19.5.0.0.191015) | 30128191 | 30133124 | 30133178 |
| JUL2019 (19.4.0.0.190716) | 29774421 | 29699079 | 29699097 |
| APR2019 (19.3.0.0.190416) | 29548437 | 29621253 | 29621299 |
| 18.0.0.0 | |||
| Description | OJVM Update | OJVM + DB Update | OJVM + GI Update |
| OCT2020 (18.12.0.0.201020) | 31668892 | 31720435 | 31720457 |
| JUL2020 (18.11.0.0.200714) | 31219909 | 31326374 | 31326376 |
| APR2020 (18.10.0.0.200414) | 30805598 | 30783603 | 30783607 |
| JAN2020 (18.9.0.0.200114) | 30501926 | 30463620 | 30463635 |
| OCT2019 (18.8.0.0.191015) | 30133603 | 30133203 | 30133246 |
| JUL2091 (18.7.0.0.190716) | 29774410 | 29699112 | 29699160 |
| APR2019 (18.6.0.0.190416) | 29249584 | 29249695 | 29251992 |
| JAN2019 (18.5.0.0.190115) | 28790647 | 28980087 | 28980105 |
| OCT2018 (18.4.0.0.181016) | 28502229 | 28689117 | 28689122 |
| JUL2018 (18.3.0.0.180717) | 27923415 | 28317326 | 28317346 |
| APR2018 (18.2.0.0.180417) | 27636900 | 27726465 | 27726470 |
| 18.0.0.0 | ||||
| Release | DB Revision 1 | DB Revision 2 | GI Revision 1 | GI Revision 2 |
| OCT2020 | 31666917 (18.11.1.0.0) | 31667173 (18.10.2.0.0) | 31719758 (18.11.1.0.0) | 31719777 (18.10.2.0.0) |
| JUL2020 | 31211410 (18.10.1.0.0) | 31212186 (18.9.2.0.0) | 31326437 (18.10.1.0.0) | 31326455 (18.9.2.0.0) |
| APR2020 | 30798089 (18.9.1.0.0) | 30830887 (18.8.2.0.0) | 30923313 (18.9.1.0.0) | 30923359 (18.8.2.0.0) |
| JAN2020 | 30445895 (18.8.1.0.0) | 30446239(18.7.2.0.0) | 30463999 (18.8.1.0.0) | 30463931 (18.7.2.0.0) |
| OCT2019 | 30080518 (18.7.1.0.0) | 30087881(18.6.2.0.0) | 30135098 (18.7.1.0.0) | 30134851 (18.6.2.0.0) |
| JUL2019 | 29708235 (18.6.1.0.0) | 29708437(18.5.2.0.0) | 29708736 (18.6.1.0.0) | 29708805 (18.5.2.0.0) |
| APR2019 | 29230887 (18.5.1.0.0) | 29230809(18.4.2.0.0) | 29231062 (18.5.1.0.0) | 29230841 (18.4.2.0.0) |
| JAN2019 | 28822587 (18.4.1.0.0) | 28790643(18.3.2.0.0) | 28833172 (18.4.1.0.0) | 28833251 (18.3.1.0.0) |
| OCT2018 | 28507480 (18.3.1.0.0) | 28601267(18.2.2.0.0) | 28660077 (18.3.1.0.0) | 28702032 (18.2.2.0.0) |
| JUL2018 | 28346593 (18.2.1.0.0) | 28276290 (18.2.1.0.0) | ||
| 12.2.0.1 | ||||
| Description | OJVM Update | OJVM Windows Bundle Patch | Combo OJVM + DB Update | Combo OJVM + GI Update |
| OCT2020 (12.2.0.1.201020) | 31668898 | 31740064 | 31720473 | 31720486 |
| JUL2020 (12.2.0.1.200714) | 31219919 | 31465105 | 31326379 | 31326390 |
| APR2020 (12.2.0.1.200414) | 30805580 | 31035002 | 30783641 | 30783652 |
| JAN2020 (12.2.0.1.200114) | 30502018 | 30525838 | 30463660 | 30463673 |
| OCT2019 (12.2.0.1.191015) | 30133625 | 30268021 | 30133374 | 30133386 |
| JUL2019 (12.2.0.1.190716) | 29774415 | 29837425 | 29699168 | 29699173 |
| APR2019 (12.2.0.1.190416) | 29249637 | 29281550 | 29252035 | 29252072 |
| JAN2019 (12.2.0.1.190115) | 28790651 | 28994068 | 28980102 | 28980109 |
| NOV2018 (12.2.0.1.181130) | NA | 28412314 | NA | NA |
| OCT2018 (12.2.0.1.181016) | 28440725 | 28412312 | 28689128 | 28689130 |
| JUL2018 (12.2.0.1.180717) | 27923353 | 28135129 | 28317292 | 28317269 |
| APR2018 (12.2.0.1.180417) | 27475613 | 27650410 | 27726453 | 27726454 |
| JAN2018 (12.2.0.1.180116) | 27001739 | 27162975 | 27010695 | 27010711 |
| OCT2017 (12.2.0.1.171017) | 26635944 | 26792369 | 26636004 | 26636246 |
| AUG2017 (12.2.0.1.170814) | N/A | 26565082 | 26550033 | 26550314 |
| JUL2017 (12.2.0.1.170718) | 25811364 | 26182467 | 26146314 | 26146318 |
| 12.2.0.1 | ||||||
| Release | DB Update | DB Revision 1 | DB Revision 2 | GI Update | GI Revision 1 | GI Revision 2 |
| OCT2020 | 31741641 (12.2.0.1.201020) | 31666944 (JUL2020) | 31667168 (APR2020) | 31750094 (12.2.0.1.201020) | 31716471 (JUL2020) | 31718774 (APR2020) |
| JUL2020 | 31312468 (12.2.0.1.200714) | 31199988 (APR2020) | 31212219 (JAN2020) | 31305382 (12.2.0.1.200714) | 31326445 (APR2020) | 31326459 (JAN2020) |
| APR2020 | 30886680 (12.2.0.1.200414) | 30799484 (JAN2020) | 30831066 (OCT2019) | 30920127 (12.2.0.1.200414) | 30820944 (JAN2020) | 30820785 (OCT2019) |
| JAN2020 | 30593149 (12.2.0.1.200114) | 30445968 (OCT2020) | 30446254 (JUL2019) | 30501932 (12.2.0.1.200114) | 30464069 (OCT2019) | 30463942 (JUL2019) |
| OCT2019 | 30138470 (12.2.0.1.191015) | 30087824 (JUL2019) | 30087848 (APR2019) | 30116802 (12.2.0.1.191015) | 30135070 (JUL2019) | 30134879 (APR2019) |
| JUL2019 | 29757449 (12.2.0.1.190716) | 29708381 (APR2019) | 29708478 (JAN2019) | 29708720 (12.2.0.1.190716) | 29708786 (APR2019) | 29708822 (JAN2019) |
| APR2019 | 29314339 (12.2.0.1.190416) | 29230950 (JAN2019) | 29230821 (OCT2018) | 29301687 (12.2.0.1.190416) | 29231084 (JAN2019) | 29230829 (OCT2018) |
| JAN2019 | 28822515 (12.2.0.1.190115) | 28822638 (OCT2018) | 28790640 (JUL2018) | 28828733 (12.2.0.1.190115) | 28833185 (OCT2018) | 28833258 (JUL2018) |
| OCT2018 | 28662603 (12.2.0.1.181016) | 28507553 (JUL2018) | 28507749 (APR2018) | 28714316 (12.2.0.1.181016) | 28507693 (JUL2018) | 28507711 (APR2018) |
| JUL2018 | 28163133 (12.2.0.1.180717) | 27848049 (APR2018) | 27872031 (JAN2018) | NA | 28251239 (APR2018) | 28251142 (JAN2018) |
| APR2018 | 27674384 (12.2.0.1.180417) | 27856791 (JAN2018) | 27427077 (OCT2017) | 27468969 (12.2.0.1.180417) | 27696736 (JAN2018) | 27696758 (OCT2017) |
| JAN2018 | 27105253 (12.2.0.1.180116) | 27013510 (OCT2017) | 27013506 (JUL2017) | 27100009 ((12.2.0.1.180116) | 27224075 (OCT2017) | 27224023 (JUL2017) |
| OCT2017 | 26710464 (12.2.0.1.171017) | 26518812 (JUL2017) | 26737266 (12.2.0.1.171017) | 26878187 (JUL2017) | ||
| JUL2017 | 26123830 (12.2.0.1.170718) | 26133434 ((12.2.0.1.170718) | ||||
| 12.1.0.2 | ||||
| Description | PSU | GI PSU | Proactive Bundle Patch | Bundle Patch (Windows 32bit & 64bit) |
| OCT2020 (12.1.0.2.201020) | 31550110 | 31718737 | 31718813 | 31658987 |
| JUL2020 (12.1.0.2.200714) | 31113348 | 31305174 | 31307682 | 31211574 |
| APR2020 (12.1.0.2.200414) | 30700212 | 30805421 | 30805478 | 30861721 |
| JAN2020 (12.1.0.2.200114) | 30340202 | 30464119 | 30464171 | 30455401 |
| OCT2019 (12.1.0.2.191015) | 29918340 | 30070257 | 30070242 | 30049606 |
| JUL2019 (12.1.0.2.190716) | 29494060 | 29698592 | 29698629 | 29831650 |
| APR2019 (12.1.0.2.190416) | 29141015 | 29176115 | 29176139 | 29413116 |
| JAN2019 (12.1.0.2.190115) | 28729169 | 28813884 | 28833531 | 28810679 |
| NOV2018 (12.1.0.2.181130) | NA | NA | NA | 28810544 (64bit) |
| OCT2018 (12.1.0.2.181016) | 28259833 | 28349311 | 28349951 | 28563501 |
| JUL2018 (12.1.0.2.180717) | 27547329 | 27967747 | 27968010 | 27937907 |
| APR2018 (12.1.0.2.180417) | 27338041 | 27468957 | 27486326 | 27440294 |
| JAN2018 (12.1.0.2.180116) | 26925311 | 27010872 | 27010930 | 27162953 |
| OCT2017 (12.1.0.2.171017) | 26713565 | 26635815 | 26635880 | 26720785 |
| AUG2017(12.1.0.2.170814) | 26609783 | 26610308 | 26610322 | 26161726 |
| JUL2017 (12.1.0.2.170718) | 25755742 | 25901062 | 26022196 | 26161724 |
| APR2017 (12.1.0.2.170418) | 25171037 | 25434003 | 25433352 | 25632533 |
| JAN2017 (12.1.0.2.170117) | 24732082 | 24917825 | 24968615 | 25115951 |
| OCT2016 (12.1.0.2.161018) | 24006101 | 24412235 | 24448103 | 24591642 |
| JUL2016 (12.1.0.2.160719) | 23054246 | 23273629 | 23273686 | 23530387 |
| APR2016 (12.1.0.2.160419) | 22291127 | 22646084 | 22899531 | 22809813 |
| JAN2016 (12.1.0.2.160119) | 21948354 | 22191349 | 22243551 | 22310559 |
| OCT2015 | 21359755 (12.1.0.2.5) | 21523234 (12.1.0.2.5) | 21744410 (12.1.0.2.13) | 21821214 (12.1.0.2.10) |
| JUL2015 | 20831110 (12.1.0.2.4) | 20996835 (12.1.0.2.4) | 21188742 (12.1.0.2.10) | 21126814 (12.1.0.2.7) |
| APR2015 | 20299023 (12.1.0.2.3) | 20485724 (12.1.0.2.3) | 20698050 (12.1.0.2.7) | 20684004 (12.1.0.2.4) |
| JAN2015 | 19769480 (12.1.0.2.2) | 19954978 (12.1.0.2.2) | 20141343 (12.1.0.2.4) | 19720843 (12.1.0.2.1) |
| OCT2014 | 19303936 (12.1.0.2.1) | 19392646 (12.1.0.2.1) | 19404326 (12.1.0.2.1) | N/A |
| 12.1.0.2 | ||||||
| Description | OJVM PSU (Linux/Unix) | OJVM BP (Windows) | Combo OJVM + DB PSU | Combo OJVM + GI PSU | Combo OJVM + DB Proactive BP | Generic JDBC |
| OCT2020 (12.1.0.2.201020) | 31668915 | 31740134 | 31720729 | 31720761 | 31720769 | Included in OJVM PSU |
| JUL2020 (12.1.0.2.200714) | 31219939 | 31465095 | 31326396 | 31326400 | 31326402 | Included in OJVM PSU |
| APR2020 (12.1.0.2.200414) | 30805558 | 31037459 | 30783658 | 30783882 | 30783885 | Included in OJVM PSU |
| JAN2020 (12.1.0.2.200114) | 30502041 | 30671054 | 30463684 | 30463691 | 30463708 | Included in OJVM PSU |
| OCT2019 (12.1.0.2.191015) | 30128197 | 30268189 | 30133412 | 30133443 | 30133464 | Included in OJVM PSU |
| JUL2019 (12.1.0.2.190716) | 29774383 | 29837393 | 29699220 | 29699244 | 29699255 | Included in OJVM PSU |
| APR2019 (12.1.0.2.190416) | 29251241 | 29447962 | 29252146 | 29252164 | 29252171 | Included in OJVM PSU |
| JAN2019 (12.1.0.2.190115) | 28790654 | 28994063 | 28980115 | 28980120 | 28980123 | Included in OJVM PSU |
| NOV2018 (12.1.0.2.181130) | NA | 28412301 | NA | NA | NA | Included in OJVM PSU |
| OCT2018 (12.1.0.2.181016) | 28440711 | 28412299 | 28689146 | 28689148 | 28689151 | Included in OJVM PSU |
| JUL2018 (12.1.0.2.180717) | 27923320 | 28135126 | 28317232 | 28317214 | 28317206 | Included in OJVM PSU |
| APR2018 (12.1.0.2.180417) | 27475603 | 27650403 | 27726471 | 27726478 | 27726492 | Included in OJVM PSU |
| JAN2018 (12.1.0.2.180116) | 27001733 | 27162998 | 27010839 | 27010888 | 27010941 | Included in OJVM PSU |
| OCT2017 (12.1.0.2.171017) | 26635845 | 26792364 | 26636270 | 26636286 | 26636295 | Included in OJVM PSU |
| AUG2017 (12.1.0.2.170814) | N/A | 26182441 | 26550023 | 26550339 | 26550390 | Included in OJVM PSU |
| JUL2017 (12.1.0.2.170718) | 26027162 | 26182439 | 25901056 | 26030704 | 26030586 | Included in OJVM PSU |
| APR2017 (12.1.0.2.170418) | 25437695 | 25590993 | 25433980 | 25434018 | 25437795 | Included in OJVM PSU |
| JAN2017 (12.1.0.2.170117) | 24917972 | 25112498 | 24917069 | 24917916 | 24917987 | Included in OJVM PSU |
| OCT2016 (12.1.0.2.161018) | 24315824 | 24591630 | 24433133 | 24433148 | 24436306 | Included in OJVM PSU |
| JUL2016 (12.1.0.2.160719) | 23177536 | 23515290 | 23615289 | 23615308 | 23615334 | 23727148 (Included in OJVM PSU) |
| APR2016 (12.1.0.2.160419) | 22674709 | 22839633 | 22738582 | 22738641 | 22738657 |
N/A |
| JAN2016 (12.1.0.2.160119) | 22139226 | 22311086 | 22191659 | 22191676 | 22378102 | |
| OCT2015 | 21555660 (12.1.0.2.5) | 21788394 (12.1.0.2.4) | 21520444 | 21523260 | 21744313 | |
| JUL2015 | 21068507 (12.1.0.2.4) | 21153530 (12.1.0.2.3) | 21150768 | 21150782 | 21150792 | |
| APR2015 | 20415564 (12.1.0.2.3) | 20391199 (12.1.0.2.2) | 20834354 | 20834538 | 20834553 | |
| JAN2015 | 19877336 (12.1.0.2.2) | 20225938 (12.1.0.2.1) | 20132434 | 20132450 | 20132462 | |
| OCT2014 (12.1.0.2.1) | 19282028 | 19791366 | 19791375 | 19791399 | ||
| 12.1.0.1 | |||||
| Description | PSU | GI PSU | Bundle Patch | ||
| A | B | Windows 64 bit | Windows 32 bit | ||
| JUL2016 (12.1.0.1.160719) | 23054354 | 23273935 | 23273958 | 23530410 | |
| APR2016 (12.1.0.1.160419) | 22291141 | 22654153 | 22654166 | 22839614 | |
| JAN2016 (12.1.0.1.160119) | 21951844 | 22191492 | 22191511 | 22494866 | |
| OCT2015 | 21352619(12.1.0.1.9) | 21551666(12.1.0.1.9) | 21551685(12.1.0.1.9) | 21744907 (12.1.0.1.21) | |
| JUL2015 | 20831107(12.1.0.1.8) | 20996901(12.1.0.1.8) | 20996911(12.1.0.1.8) | 21076681 (12.1.0.1.20) | |
| APR2015 | 20299016(12.1.0.1.7) | 20485762(12.1.0.1.7) | 19971331(12.1.0.1.7) | 20558101 (12.1.0.1.18) | |
| JAN2015 | 19769486(12.1.0.1.6) | 19971324(12.1.0.1.6) | 19971331(12.1.0.1.6) | 20160748 (12.1.0.1.16) | |
| OCT2014 | 19121550(12.1.0.1.5) | 19392372(12.1.0.1.5) | 19392451(12.1.0.1.5) | 19542943 (12.1.0.1.14) | |
| JUL2014 | 18522516(12.1.0.1.4) | 18705901(12.1.0.1.4) | 18705972(12.1.0.1.4) | 19062327 (12.1.0.1.11) | |
| APR2014 | 18031528(12.1.0.1.3) | 18139660(12.1.0.1.3) | 18413105(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 | OJVM PSU (Linux/Unix) | OJVM BP (Windows) | Combo OJVM + DB PSU | Combo OJVM + DB SPU | Combo OJVM + GI PSU | Generic JDBC |
| OCT2020 (11.2.0.4.201020) | 31668908 | 31740195 | 31720776 | 31720810 | 31720783 | Included in OJVM PSU |
| JUL2020 (11.2.0.4.200714) | 31219953 | 31169933 | 31326405 | 31326415 | 31326410 | Included in OJVM PSU |
| APR2020 (11.2.0.4.200414) | 30805543 | 31169933 | 30783889 | 30783899 | 30783890 | Included in OJVM PSU |
| JAN2020 (11.2.0.4.200114) | 30503372 | 30671044 | 30463718 | 30463749 | 30463729 | Included in OJVM PSU |
| OCT2019 (11.2.0.4.191015) | 30132974 | 30268157 | 30133482 | 30133547 | 30133506 | Included in OJVM PSU |
| JUL2019 (11.2.0.4.190716) | 29610422 | 30012911 | 29699294 | N/A | 29699309 | Included in OJVM PSU |
| APR2019 (11.2.0.4.190416) | 29251270 | 29447971 | 29252186 | N/A | 29252208 | Included in OJVM PSU |
| JAN2019 (11.2.0.4.190115) | 28790660 | 28994059 | 28980129 | 28980145 | 28980134 | Included in OJVM PSU |
| OCT2018 (11.2.0.4.181016) | 28440700 | 28412269 | 28689165 | 28689160 | 28689170 | Included in OJVM PSU |
| JUL2018 (11.2.0.4.180717) | 27923163 | 28416098 | 28317183 | 28317175 | 28317141 | Included in OJVM PSU |
| APR2018 (11.2.0.4.180417) | 27475598 | 27650399 | 27726500 | 27726497 | 27726505 | Included in OJVM PSU |
| JAN2018 (11.2.0.4.180116) | 26925532 | 27163009 | 27011017 | 27010991 | 27282436 | Included in OJVM PSU |
| OCT2017 (11.2.0.4.171017) | 26635834 | 26792358 | 26636031 | 26636315 | 26636028 | Included in OJVM PSU |
| AUG2017 (11.2.0.4.170814) | N/A | 26182427 | 26568865 | N/A | 26550684 | Included in OJVM PSU |
| JUL2017 (11.2.0.4.170718) | 26027154 | 26182425 | 26031209 | 26031190 | 26030870 | Included in OJVM PSU |
| APR2017 (11.2.0.4.170418) | 25434033 | 25590979 | 25440428 | 25476166 | 25440422 | Included in OJVM PSU |
| JAN2017 (11.2.0.4.170117) | 24917954 | 25043019 | 24918033 | 25367810 | 24918228 | Included in OJVM PSU |
| OCT2016 (11.2.0.4.161018) | 24315821 | 24591637 | 24436313 | 24433791 | 24436346 | Included in OJVM PSU |
| JUL2016 (11.2.0.4.160719) | 23177551 | 23515277 | 23615392 | 23615381 | 23615403 | 23727132 (Included in OJVM PSU) |
| APR2016 (11.2.0.4.160419) | 22674697 | 22839614 | 22738777 | 22738732 | 22738793 |
Included in OJVM PSU |
| JAN2016 (11.2.0.4.160119) | 22139245 | 22311053 | 22378146 | 22378121 | 22378167 | |
| OCT2015 (11.2.0.4.5) | 21555791 | 21788344 | 21744343 | 21744335 | 21744348 | |
| JUL2015 (11.2.0.4.4) | 21068539 | 21153498 | 21150851 | 21150829 | 21150864 | |
| APR2015 (11.2.0.4.3) | 20406239 | 20225988 | 20834611 | 20834597 | 20834621 | |
| JAN2015 (11.2.0.4.2) | 19877440 | 20225982 | 20132580 | 20132517 | 20132615 | |
| OCT2014 (11.2.0.4.1) | 19282021 | 19799291 | 19791364 | 19791358 | 19791420 | 19852360 |
| 11.2.0.4 | ||||
| Description | PSU | SPU(CPU) | GI PSU | Bundle Patch (Windows 32bit & 64bit) |
| OCT2020 (11.2.0.4.201020) | 31537677 | 31834759 | 31718723 | 31659823 |
| JUL2020 (11.2.0.4.200714) | 31103343 | 31338362 | 31305209 | 31169916 |
| APR2020 (11.2.0.4.200414) | 30670774 | 31010960 | 30805461 | 31169916 |
| JAN2020 (11.2.0.4.200114) | 30298532 | 30559616 | 30501155 | 30502376 |
| OCT2019 (11.2.0.4.191015) | 29913194 | N/A | 30070097 | 30151661 |
| JUL2019 (11.2.0.4.190716) | 29497421 | N/A | 29698727 | 29596609 |
| APR2019 (11.2.0.4.190416) | 29141056 | 28790634 | 29255947 | 29218820 |
| JAN2019 (11.2.0.4.190115) | 28729262 | 28790634 | 28813878 | 28761877 |
| OCT2018 (11.2.0.4.181016) | 28204707 | 28364007 | 28429134 | 28265827 |
| JUL2018 (11.2.0.4.180717) | 27734982 | 27870645 | 27967757 | 27695940 |
| APR2018 (11.2.0.4.180417) | 27338049 | 26474853 | 27475913 | 27381640 |
| JAN2018 (11.2.0.4.180116) | 26925576 | N/A | 27107360 | 27162965 |
| OCT2017 (11.2.0.4.171017) | 26392168 | 26474853 | 26635745 | 26581376 |
| AUG2017 (11.2.0.4.170814) | 26609445 | N/A | 26610246 | 26194138 |
| JUL2017 (11.2.0.4.170718) | 25869727 | 25879656 | 26030799 | 26194136 |
| APR2017 (11.2.0.4.170418) | 24732075 | 25369547 | 25476126 | 25632525 |
| JAN2017 | N/A | N/A | N/A | N/A |
| OCT2016 (11.2.0.4.161018) | 24006111 | 24433711 | 24436338 | 24591646 |
| JUL2016 (11.2.0.4.160719) | 23054359 | 23177648 | 23274134 | 23530402 |
| APR2016 (11.2.0.4.160419) | 22502456 | 22502493 | 22646198 | 22839608 |
| JAN2016 (11.2.0.4.160119) | 21948347 | 21972320 | 22191577 | 22310544 |
| OCT2015 | 21352635 (11.2.0.4.8) | 21352646 | 21523375 (11.2.0.4.8) | 21821802 (11.2.0.4.20) |
| JUL2015 | 20760982 (11.2.0.4.7) | 20803583 | 20996923 (11.2.0.4.7) | 21469106 (11.2.0.4.18) |
| APR2015 | 20299013 (11.2.0.4.6) | 20299015 | 20485808 (11.2.0.4.6) | 20544696 (11.2.0.4.15) |
| JAN2015 | 19769489 (11.2.0.4.5) | 19854503 | 19955028 (11.2.0.4.5) | 20127071 (11.2.0.4.12) |
| OCT2014 | 19121551 (11.2.0.4.4) | 19271443 | 19380115 (11.2.0.4.4) | 19651773 (11.2.0.4.10) |
| JUL2014 | 18522509 (11.2.0.4.3) | 18681862 | 18706472 (11.2.0.4.3) | 18842982 (11.2.0.4.7) |
| APR2014 | 18031668 (11.2.0.4.2) | 18139690 | 18139609 (11.2.0.4.2) | 18296644 (11.2.0.4.4) |
| JAN2014 | 17478514 (11.2.0.4.1) | 17551709 | N/A | 17987366 (11.2.0.4.1) |
| 11.2.0.3 | |||||
| Description | PSU | SPU(CPU) | GI PSU | Bundle Patch (Windows 64bit) | Bundle Patch (Windows 32bit) |
| JUL2015 | 20760997 (11.2.0.3.15) | 20803576 | 20996944 (11.2.0.3.15) | 21104036 | 21104035 |
| APR2015 | 20299017 (11.2.0.3.14) | 20299010 | 20485830 (11.2.0.3.14) | 20420395 | 20420394 |
| JAN2015 | 19769496 (11.2.0.3.13) | 19854461 | 19971343 (11.2.0.3.13) | 20233168 | 20233167 |
| OCT2014 | 19121548 (11.2.0.3.12) | 19271438 | 19440385 (11.2.0.3.12) | 19618575 | 19618574 |
| JUL2014 | 18522512 (11.2.0.3.11) | 18681866 | 18706488 (11.2.0.3.11) | 18940194 | 18940193 |
| APR2014 | 18031683 (11.2.0.3.10) | 18139695 | 18139678 (11.2.0.3.10) | 18372244 | 18372243 |
| JAN2014 | 17540582 (11.2.0.3.9) | 17478415 | 17735354 (11.2.0.3.9) | 18075406 | 17906981 |
| OCT2013 | 16902043 (11.2.0.3.8) | 17082364 | 17272731 (11.2.0.3.8) | 17363850 | 17363844 |
| JUL2013 | 16619892 (11.2.0.3.7) | 16742095 | 16742216 (11.2.0.3.7) | 16803775 | 16803774 |
| APR2013 | 16056266 (11.2.0.3.6) | 16294378 | 16083653 (11.2.0.3.6) | 16345834 | 16345833 |
| JAN2013 | 14727310 (11.2.0.3.5) | 14841409 | 14727347 (11.2.0.3.5) | 16042648 | 16042647 |
| OCT2012 | 14275605 (11.2.0.3.4) | 14390252 | 14275572 (11.2.0.3.4) | 14613223 | 14613222 |
| JUL2012 | 13923374 (11.2.0.3.3) | 14038787 | 13919095 (11.2.0.3.3) | 14223718 | 14223717 |
| APR2012 | 13696216 (11.2.0.3.2) | 13632717 | 13696251 (11.2.0.3.2) | 13885389 | 13885388 |
| JAN2012 | 13343438 (11.2.0.3.1) | 13466801 | 13348650 (11.2.0.3.1) | 13413168 | 13413167 |
| 11.2.0.2 | |||||
| Description | PSU | SPU(CPU) | GI PSU | Bundle Patch (Windows 64bit) | Bundle Patch (Windows 32bit) |
| OCT2013 | 17082367 (11.2.0.2.12) | 17082375 | 17272753 (11.2.0.2.12) | 17363838 | 17363837 |
| JUL2013 | 16619893 (11.2.0.2.11) | 16742100 | 16742320 (11.2.0.2.11) | 16345852 | 16345851 |
| APR2013 | 16056267 (11.2.0.2.10) | 16294412 | 16166868 (11.2.0.2.10) | 16345846 | 16345845 |
| JAN2013 | 14727315 (11.2.0.2.9) | 14841437 | 14841385 (11.2.0.2.9) | 16100399 | 16100398 |
| OCT2012 | 14275621 (11.2.0.2.8) | 14390377 | 14390437 (11.2.0.2.8) | 14672268 | 14672267 |
| JUL2012 | 13923804 (11.2.0.2.7) | 14038791 | 14192201 (11.2.0.2.7) | 14134043 | 14134042 |
| APR2012 | 13696224 (11.2.0.2.6) | 13632725 | 13696242 (11.2.0.2.6) | 13697074 | 13697073 |
| JAN2012 | 13343424 (11.2.0.2.5) | 13343244 | 13653086 (11.2.0.2.5) | 13413155 | 13413154 |
| OCT2011 | 12827726 (11.2.0.2.4) | 12828071 | 12827731 (11.2.0.2.4) | 13038788 | 13038787 |
| JUL2011 | 12419331 (11.2.0.2.3) | 12419321 | 12419353 (11.2.0.2.3) | 12714463 | 12714462 |
| APR2011 | 11724916 (11.2.0.2.2) | 11724984 | 12311357 (11.2.0.2.2) | 11896292 | 11896290 |
| JAN2011 | 10248523 (11.2.0.2.1) | N/A | N/A | 10432053 | 10432052 |
| 11.2.0.1 | ||||
| Description | PSU | CPU | Bundle Patch (Windows 64bit) | Bundle Patch (Windows 32bit) |
| JUL2011 | 12419378 (11.2.0.1.6) | 12419278 | 12429529 | 12429528 |
| APR2011 | 11724930 (11.2.0.1.5) | 11724991 | 11731176 | 11883240 |
| JAN2011 | 10248516 (11.2.0.1.4) | 10249532 | 10432045 | 10432044 |
| OCT2010 | 9952216 (11.2.0.1.3) | 9952260 | 10100101 | 10100100 |
| JUL2010 | 9654983 (11.2.0.1.2) | 9655013 | 9736865 | 9736864 |
| APR2010 | 9352237 (11.2.0.1.1) | 9369797 | N/A | N/A |
| 10.2.0.5 | |||||
| Description | PSU | SPU(CPU) | Bundle Patch (Windows 64bit) | Bundle Patch (Windows 32bit) | Bundle Patch (Windows Itanium) |
| JUL2015 | 20299014(10.2.0.5.19) | 20299021 | 20420387 | 20420386 | N/A |
| APR2015 | N/A | N/A | N/A | N/A | N/A |
| JAN2015 | 19769505(10.2.0.5.18) | 19854436 | 20126868 | 20126867 | N/A |
| OCT2014 | 19274523(10.2.0.5.17) | 19274521 | 19618565 | 19618563 | N/A |
| JUL2014 | 18522511(10.2.0.5.16) | 18681879 | 18940198 | 18940196 | N/A |
| APR2014 | 18031728(10.2.0.5.15) | 18139709 | 18372261 | 18372259 | N/A |
| JAN2014 | 17465584(10.2.0.5.14) | 17551414 | 17906974 | 17906972 | N/A |
| OCT2013 | 17082365(10.2.0.5.13) | 17082371 | N/A | 17363822 | N/A |
| JUL2013 | 16619894(10.2.0.5.12) | 16742123 | 16803782 | 16803780 | 16803781 |
| APR2013 | 16056270(10.2.0.5.11) | 16270946 | 16345857 | 16345855 | 16345856 |
| JAN2013 | 14727319(10.2.0.5.10) | 14841459 | 15848062 | 15848060 | 15848061 |
| OCT2012 | 14275629(10.2.0.5.9) | 14390396 | 14553358 | 14553356 | 14553357 |
| JUL2012 | 13923855(10.2.0.5.8) | 14038805 | 14134053 | 14134051 | 14134052 |
| APR2012 | 13632743(10.2.0.5.7) | 13632738 | 13654815 | 13654814 | 13870404 |
| JAN2012 | 13343471(10.2.0.5.6) | 13343467 | 13460968 | 13460967 | N/A |
| OCT2011 | 12827745(10.2.0.5.5) | 12828105 | N/A | 12914911 | N/A |
| JUL2011 | 12419392(10.2.0.5.4) | 12419258 | 12429524 | 12429523 | N/A |
| APR2011 | 11724962(10.2.0.5.3) | 11725006 | 12328269 | 12328268 | N/A |
| JAN2011 | 10248542(10.2.0.5.2) | 10249537 | 10352673 | 10352672 | N/A |
| OCT2010 | 9952230(10.2.0.5.1) | 9952270 | 10099855 | 10058290 | N/A |
| 10.2.0.4 | |||||
| Description | PSU | SPU(CPU) | Bundle Patch (Windows 32bit) | Bundle Patch (Windows 64bit) | Bundle Patch (Windows Itanium) |
| JUL2013 | 16619897 (10.2.0.4.17) | 16742253 | N/A | N/A | N/A |
| APR2013 | 16056269 (10.2.0.4.16) | 16270931 | N/A | N/A | N/A |
| JAN2013 | 14736542 (10.2.0.4.15) | 14841471 | N/A | N/A | N/A |
| OCT2012 | 14275630 (10.2.0.4.14) | 14390410 | N/A | N/A | N/A |
| JUL2012 | 13923851 (10.2.0.4.13) | 14038814 | N/A | N/A | N/A |
| APR2012 | 12879933 (10.2.0.4.12) | 12879926 | 13928775 | 13928776 | N/A |
| JAN2012 | 12879929 (10.2.0.4.11) | 12879912 | 13654060 | N/A | N/A |
| OCT2011 | 12827778 (10.2.0.4.10) | 12828112 | 12914908 | 12914910 | 12914909 |
| JUL2011 | 12419397 (10.2.0.4.9) | 12419249 | 12429519 | 12429521 | 12429520 |
| APR2011 | 11724977 (10.2.0.4.8) | 11725015 | 12328501 | 12328503 | 12328502 |
| JAN2011 | 10248636 (10.2.0.4.7) | 10249540 | 10349197 | 10349200 | 10349198 |
| OCT2010 | 9952234 (10.2.0.4.6) | 9952272 | 10084980 | 10084982 | 10084981 |
| JUL2010 | 9654991 (10.2.0.4.5) | 9655017 | 9777076 | 9777078 | 9777077 |
| APR2010 | 9352164 (10.2.0.4.4) | 9352191 | 9393548 | 9393550 | 9393549 |
| JAN2010 | 9119284 (10.2.0.4.3) | 9119226 | 9169457 | 9169460 | 9169458 |
| OCT2009 | 8833280 (10.2.0.4.2) | 8836308 | 8880857 | 8880861 | 8880858 |
| JUL2009 | 8576156 (10.2.0.4.1) | 8534387 | 8559466 | 8559467 | 8541782 |
| APR2009 | N/A | 8290506 | 8307237 | 8307238 | 8333678 |
| JAN2009 | N/A | 7592346 | 7584866 | 7584867 | N/A |
| OCT2008 | N/A | 7375644 | 7386320 | 7386321 | N/A |
| JUL2008 | N/A | 7150470 | 7218676 | 7218677 | N/A |
| 10.2.0.3 | ||||
| Description | CPU (Unix/Linux) | Bundle Patch (Windows 32bit) | Bundle Patch (Windows Itanium) | Bundle Patch (Windows 64bit) |
| JAN2009 | 7592354 | 7631956 | 7631958 | 7631957 |
| OCT2008 | 7369190 | 7353782 | 7353784 | 7353785 |
| JUL2008 | 7150622 | 7252496 | 7252497 | 7252498 |
| APR2008 | 6864068 | 6867054 | 6867055 | 6867056 |
| JAN2008 | 6646853 | 6637237 | 6637238 | 6637239 |
| OCT2007 | 6394981 | 6430171 | 6430173 | 6430174 |
| JUL2007 | 6079591 | 6116131 | 6038242 | 6116139 |
| APR2007 | 5901891 | 5948242 | 5916262 | 5948243 |
| JAN2007 | 5881721 | 5846376 | 5846377 | 5846378 |
| 10.2.0.2 | ||||
| Description | CPU (Unix/Linux) | Bundle Patch (Windows 32bit) | Bundle Patch (Windows 64bit) | Bundle Patch (Windows Itanium) |
| JAN2009 | 7592355 | N/A | N/A | N/A |
| OCT2008 | 7375660 | N/A | N/A | N/A |
| JUL2008 | 7154083 | N/A | N/A | N/A |
| APR2008 | 6864071 | N/A | N/A | N/A |
| JAN2008 | 6646850 | N/A | N/A | N/A |
| OCT2007 | 6394997 | 6397028 | 6397030 | 6397029 |
| JUL2007 | 6079588 | 6013105 | 6013121 | 6013118 |
| APR2007 | 5901881 | 5912173 | 5912179 | 5912176 |
| JAN2007 | 5689957 | 5716143 | 5699839 | 5699824 |
| OCT2006 | 5490848 | 5502226 | 5500921 | 5500894 |
| JUL2006 | 5225799 | 5251025 | 5251028 | 5251026 |
| APR2006 | 5079037 | 5140461 | 5140567 | 5140508 |
| 10.2.0.1 | ||||
| Description | CPU (Unix/Linux) | Bundle Patch (Windows 32bit) | Bundle Patch (Windows 64bit) | Bundle Patch (Windows Itanium) |
| APR2007 | 5901880 | N/A | N/A | N/A |
| JAN2007 | 5689937 | 5695784 | 5695786 | 5695785 |
| OCT2006 | 5490846 | 5500927 | 5500954 | 5500951 |
| JUL2006 | 5225798 | 5239698 | 5239701 | 5239699 |
| APR2006 | 5049080 | 5059238 | 5059261 | 5059251 |
| JAN2006 | 4751931 | 4751539 | 4770480 | 4751549 |
| 10.1.0.5 | |||
| Description | CPU (Unix/Linux) | Bundle Patch (Windows 32bit) | Bundle Patch (Windows Itanium) |
| JAN2012 | 13343482 | 13413002 | 13413003 |
| OCT2011 | 12828135 | 12914905 | 12914906 |
| JUL2011 | 12419228 | 12429517 | 12429518 |
| APR2011 | 11725035 | 11731119 | 11731120 |
| JAN2011 | N/A | N/A | N/A |
| OCT2010 | 9952279 | 10089559 | 10089560 |
| JUL2010 | 9655023 | 9683651 | 9683652 |
| APR2010 | 9352208 | 9390288 | 9390289 |
| JAN2010 | 9119261 | 9187104 | 9187105 |
| OCT2009 | 8836540 | 8785211 | 8785212 |
| JUL2009 | 8534394 | 8656224 | 8656226 |
| APR2009 | 8290534 | 8300356 | 8300360 |
| JAN2009 | 7592360 | 7486619 | 7586049 |
| OCT2008 | 7375686 | 7367493 | 7367494 |
| JUL2008 | 7154097 | 7047034 | 7047037 |
| APR2008 | 6864078 | 6867107 | 6867108 |
| JAN2008 | 6647005 | 6637274 | 6637275 |
| OCT2007 | 6395024 | 6408393 | 6408394 |
| JUL2007 | 6079585 | 6115804 | 6115818 |
| APR2007 | 5901877 | 5907304 | 5907305 |
| JAN2007 | 5689908 | 5716295 | 5634747 |
| OCT2006 | 5490845 | 5500883 | 5500885 |
| JUL2006 | 5225797 | 5251148 | 5251140 |
| APR2006 | 5049074 | 5057606 | 5057609 |
| JAN2006 | 4751932 | 4882231 | 4882236 |
| 10.1.0.4 | |||
| Description | CPU (Unix/Linux) | Bundle Patch (Windows 32bit) | Bundle Patch (Windows Itanium) |
| APR2007 | 5901876 | 5909871 | 5909879 |
| JAN2007 | 5689894 | 5695771 | 5695772 |
| OCT2006 | 5490844 | 5500878 | 5500880 |
| JUL2006 | 5225796 | 5239736 | 5239737 |
| APR2006 | 5049067 | 5059200 | 5059227 |
| JAN2006 | 4751928 | 4751259 | 4745040 |
| OCT2005 | 4567866 | 4579182 | 4579188 |
| JUL2005 | 4392423 | 4440706 | 4404600 |
| APR2005 | 4210374 | 4287619 | 4287611 |
| 10.1.0.3 | |||
| Description | CPU (Unix/Linux) | Bundle Patch (Windows 32bit) | Bundle Patch (Windows Itanium) |
| JAN2007 | 5923277 | N/A | N/A |
| OCT2006 | 5566825 | N/A | N/A |
| JUL2006 | 5435164 | N/A | N/A |
| APR2006 | 5158022 | N/A | N/A |
| JAN2006 | 4751926 | 4741077 | 4741084 |
| OCT2005 | 4567863 | 4567518 | 4567523 |
| JUL2005 | 4392409 | 4389012 | 4389014 |
| APR2005 | 4193286 | 4269715 | 4158888 |
| JAN2005 | 4003062 | 4074232 | 3990812 |
| 10.1.0.2 | |||
| Description | CPU (Unix/Linux) | Bundle Patch (Windows 32bit) | Bundle Patch (Windows Itanium) |
| APR2005 | 4193293 | 4181849 | 4213305 |
| JUL2005 | 4400766 | 4388944 | 4388948 |
| JAN2005 | 4003051 | 4104364 | 4083038 |
| 9.2.0.8 | |||
| Description | CPU (Unix/Linux) | Bundle Patch (Windows 32bit) | Bundle Patch (Windows Itanium) |
| JUL2010 | 9655027 | 9683644 | 9683645 |
| APR2010 | 9352224 | 9390286 | N/A |
| JAN2010 | 9119275 | 9187106 | N/A |
| OCT2009 | 8836758 | 8785185 | 8785186 |
| JUL2009 | 8534403 | 8427417 | 8427418 |
| APR2009 | 8290549 | 8300340 | 8300346 |
| JAN2009 | 7592365 | 7703210 | 7703212 |
| OCT2008 | 7375695 | 7394394 | 7394402 |
| JUL2008 | 7154111 | 7047026 | 7047029 |
| APR2008 | 6864082 | 6867138 | 6867139 |
| JAN2008 | 6646842 | 6637265 | 6637266 |
| OCT2007 | 6395038 | 6417013 | 6417014 |
| JUL2007 | 6079582 | 6130293 | 6130295 |
| APR2007 | 5901875 | 5916268 | 5916275 |
| JAN2007 | N/A | N/A | N/A |
| OCT2006 | 5490859 | 5652380 | 5639519 |
| 9.2.0.7 | |||
| Description | CPU (Unix/Linux) | Bundle Patch (Windows 32bit) | Bundle Patch (Windows Itanium) |
| JUL2007 | 6079579 | 6146759 | 6146748 |
| APR2007 | 5901872 | 5907274 | 5907275 |
| JAN2007 | 5689875 | 5654905 | 5654909 |
| OCT2006 | 5490841 | 5500873 | 5500874 |
| JUL2006 | 5225794 | 5250980 | 5250981 |
| APR2006 | 5049060 | 5064365 | 5064364 |
| JAN2006 | 4751923 | 4751528 | 4741074 |
| OCT2005 | 4567854 | 4579590 | 4579599 |
| JUL2005 | 4547566 | N/A | N/A |
| 9.2.0.6 | |||
| Description | CPU (Unix/Linux) | Bundle Patch (Windows 32bit) | Bundle Patch (Windows Itanium) |
| OCT2006 | 5490840 | 5500865 | 5500871 |
| JUL2006 | 5225793 | 5239794 | 5239793 |
| APR2006 | 5049051 | 5059614 | 5059615 |
| JAN2006 | 4751921 | 4751261 | 4751262 |
| OCT2005 | 4567846 | 4579093 | 4579097 |
| JUL2005 | 4392392 | 4445852 | 4401917 |
| APR2005 | 4193295 | 4269928 | 4213298 |
| 9.2.0.5 | |||
| Description | CPU (Unix/Linux) | Bundle Patch (Windows 32bit) | Bundle Patch (Windows Itanium) |
| OCT2006 | 5689708 | N/A | N/A |
| JUL2006 | 5435138 | N/A | N/A |
| APR2006 | 5219762 | N/A | N/A |
| OCT2005 | 4560421 | N/A | N/A |
| JUL2005 | 4392256 | 4387563 | 4391819 |
| APR2005 | 4193299 | 4195791 | 4214192 |
| JAN2005 | 4003006 | 4104374 | 3990809 |
| 9.2.0.4 | |||
| Description | CPU (Unix/Linux) | Bundle Patch (Windows 32bit) | Bundle Patch (Windows Itanium) |
| JAN2005 | 4002994 | 4104369 | 4083202 |
| 8.1.7.4 | ||
| Description | CPU (Unix/Linux) | Bundle Patch (Windows 32bit) |
| JAN2007 | 5689799 | 5686514 |
| OCT2006 | 5490835 | 5496067 |
| JUL2006 | 5225788 | 5236412 |
| APR2006 | 5045247 | 5057601 |
| JAN2006 | 4751906 | 4751570 |
| OCT2005 | 4560405 | 4554818 |
| JUL2005 | 4392446 | 4437058 |
| APR2005 | 4193312 | 4180163 |
| JAN2005 | 4002909 | 3921893 |
参考：Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (文档 ID 2118136.2)
联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
客户的数据库通过监听访问报ORA-01034 ORA-27101错误无法正常使用：
SQL> conn app/xxxxx@192.168.129.145/orcl ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory Process ID: 0 Session ID: 0 Serial number: 0 SQL> conn app/xxxxx Connected.
检查数据库状态和tnsping都正常
SQL> select open_mode from v$database; OPEN_MODE -------------------- READ WRITE SQL> !tnsping orcl TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 18-OCT-2020 22:11:49 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.129.1) (PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl))) OK (0 msec)
检查主机之间ping操作也正常：
[XIFENFEI@DB1 trace]$ [XIFENFEI@DB1 trace]$ ping 192.168.129.1 PING 192.168.129.1 (192.168.129.1) 56(84) bytes of data. 64 bytes from 192.168.129.1: icmp_seq=1 ttl=64 time=0.025 ms 64 bytes from 192.168.129.1: icmp_seq=2 ttl=64 time=0.032 ms 64 bytes from 192.168.129.1: icmp_seq=3 ttl=64 time=0.034 ms ^C --- 192.168.129.1 ping statistics --- 3 packets transmitted, 3 received, 0% packet loss, time 2318ms rtt min/avg/max/mdev = 0.025/0.030/0.034/0.006 ms
检查数据库和监听配置：
[XIFENFEI@DB1 trace]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Oct 18 22:13:50 2020
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 Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name string
db_file_name_convert string
db_name string orcl
db_unique_name string orcl
global_names boolean FALSE
instance_name string oracle
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string orcl
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[XIFENFEI@DB1 trace]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 18-OCT-2020 22:15:16
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 18-OCT-2020 22:05:04
Uptime 0 days 0 hr. 10 min. 12 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /usr/local/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /usr/local/oracle/diag/tnslsnr/DB1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.129.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[XIFENFEI@DB1 trace]$ cat /usr/local/oracle/product/11.2.0/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /usr/local/oracle/product/11.2.0/db_1)
(GLOBAL_DBNAME= orcl)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/local/oracle/product/11.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.129.1) (PORT = 1521))
)
)
ADR_BASE_LISTENER = /usr/local/oracle
[XIFENFEI@DB1 trace]$
[XIFENFEI@DB1 trace]$
这里看到数据库配置和监听配置不匹配，因此需要调整。
[XIFENFEI@DB1 admin]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sun Oct 18 22:21:16 2020 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 Partitioning, OLAP, Data Mining and Real Application Testing options SQL> conn app/xxxxx@192.168.129.145/orcl Connected. SQL> SQL> SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [XIFENFEI@DB1 admin]$
联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
数据库启动报ORA-08103
朋友反馈,客户的一套sap历史数据系统,无备份,由于硬件故障导致,数据库启动报ORA-08103: object no longer exists错误,无法正常启动
SMON: enabling tx recovery Mon Oct 12 09:51:56 2020 Database Characterset is UTF8 Opening with internal Resource Manager plan where NUMA PG = 1, CPUs = 32 Starting background process QMNC QMNC started with pid=36, OS id=14942376 Mon Oct 12 09:51:58 2020 Errors in file /oracle/XFF/saptrace/usertrace/xff_ora_15204508.trc: ORA-00604: error occurred at recursive SQL level 2 ORA-08103: object no longer exists Mon Oct 12 09:51:58 2020 ORA-604 signalled during: ALTER DATABASE OPEN... Mon Oct 12 09:51:58 2020 Errors in file /oracle/XFF/saptrace/background/xff_smon_8978452.trc: ORA-08103: object no longer exists Mon Oct 12 09:52:50 2020 Errors in file /oracle/XFF/saptrace/background/xff_reco_8781998.trc: ORA-08103: object no longer exists Mon Oct 12 09:52:50 2020 RECO: terminating instance due to error 8103 Instance terminated by RECO, pid = 8781998
dbv检查system文件
PARSING IN CURSOR #14 len=210 dep=2 uid=0 oct=3 lid=0 tim=191031051961382 hv=864012087 ad='cabb8a10' select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 END OF STMT PARSE #14:c=0,e=21,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=191031051961380 BINDS #14: kkscoacd Bind#0 oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00 oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0 kxsbbbfp=110919308 bln=22 avl=02 flg=05 value=96 Bind#1 oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00 oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0 kxsbbbfp=1109192d8 bln=24 avl=02 flg=05 value=1 EXEC #14:c=0,e=128,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=191031051961618 FETCH #14:c=0,e=40,p=1,cr=1,cu=0,mis=0,r=0,dep=2,og=3,tim=191031051961676 ORA-00604: error occurred at recursive SQL level 2 ORA-08103: object no longer exists
比较明显是由于hist_head$异常导致，而且报ORA-08103错误和dbv检查system文件有一些空块错误匹配。这个错误比较简单,有几种处理方法：
1. 直接把空块标记为坏块,然后启动库
2. 在数据库启动过程跳过该sql,启动数据库,然后对这个表进行处理
该库进行恢复之后,正常打开数据库
联系：手机/微信(+86 17813235971) QQ(107644445)
标题：ORA-15196: invalid ASM block header [kfc.c:26368]故障恢复
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
有客户对asm的data磁盘组增加磁盘进行扩容,在做reblance的过程中重启了主机,结果导致data磁盘组mount之后自动dismount
Fri Oct 09 20:48:06 2020 NOTE: PST enabling heartbeating (grp 1) Fri Oct 09 20:48:06 2020 NOTE: ASM did background COD recovery for group 1/0x739536c (DATA) NOTE: starting rebalance of group 1/0x739536c (DATA) at power 10 Starting background process ARB0 Fri Oct 09 20:48:07 2020 ARB0 started with pid=28, OS id=39278 NOTE: assigning ARB0 to group 1/0x739536c (DATA) with 10 parallel I/Os cellip.ora not found. WARNING:cache read a corrupt block:group=1(DATA) dsk=8 blk=7 disk=8(DATA_0008)incarn=3916014506 au=0 blk=7 count=1 Errors in file /u01/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_39278.trc: ORA-15196: invalid ASM block header [kfc.c:26368] [check_kfbh] [2147483656] [7] [2182009786 != 2190395015] NOTE: a corrupted block from group DATA was dumped to /u01/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_39278.trc WARNING:cache read(retry)a corrupt block:group=1(DATA) dsk=8 blk=7 disk=8(DATA_0008)incarn=3916014506 au=0 blk=7 count=1 Errors in file /u01/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_39278.trc: ORA-15196: invalid ASM block header [kfc.c:26368] [check_kfbh] [2147483656] [7] [2182009786 != 2190395015] ORA-15196: invalid ASM block header [kfc.c:26368] [check_kfbh] [2147483656] [7] [2182009786 != 2190395015] ERROR: cache failed to read group=1(DATA) dsk=8 blk=7 from disk(s): 8(DATA_0008) Fri Oct 09 20:48:13 2020 NOTE: GroupBlock outside rolling migration privileged region ORA-15196: invalid ASM block header [kfc.c:26368] [check_kfbh] [2147483656] [7] [2182009786 != 2190395015] ORA-15196: invalid ASM block header [kfc.c:26368] [check_kfbh] [2147483656] [7] [2182009786 != 2190395015] NOTE: requesting all-instance membership refresh for group=1 NOTE: cache initiating offline of disk 8 group DATA NOTE: process _arb0_+asm1 (39278) initiating offline of disk 8.3916014506 (DATA_0008) with mask 0x7e in group 1 NOTE: initiating PST update: grp = 1, dsk = 8/0xe969a3aa, mask = 0x6a, op = clear GMON updating disk modes for group 1 at 7 for pid 28, osid 39278 ERROR: Disk 8 cannot be offlined, since diskgroup has external redundancy. ERROR: too many offline disks in PST (grp 1) Fri Oct 09 20:48:13 2020 NOTE: cache dismounting (not clean) group 1/0x0739536C (DATA) NOTE: messaging CKPT to quiesce pins Unix process pid: 39346, image: oracle@rac1 (B000) Fri Oct 09 20:48:13 2020 NOTE: halting all I/Os to diskgroup 1 (DATA) Fri Oct 09 20:48:13 2020 NOTE: LGWR doing non-clean dismount of group 1 (DATA) NOTE: LGWR sync ABA=32.4749 last written ABA 32.4749 WARNING: Offline for disk DATA_0008 in mode 0x7f failed. Fri Oct 09 20:48:13 2020 kjbdomdet send to inst 2 detach from dom 1, sending detach message to inst 2 Fri Oct 09 20:48:13 2020 List of instances: 1 2 Dirty detach reconfiguration started (new ddet inc 2, cluster inc 4) Errors in file /u01/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_39278.trc (incident=337185): ORA-15335: ASM metadata corruption detected in disk group 'DATA' ORA-15130: diskgroup "DATA" is being dismounted ORA-15066: offlining disk "DATA_0008" in group "DATA" may result in a data loss ORA-15196: invalid ASM block header [kfc.c:26368] [check_kfbh] [2147483656] [7] [2182009786 != 2190395015] ORA-15196: invalid ASM block header [kfc.c:26368] [check_kfbh] [2147483656] [7] [2182009786 != 2190395015] Incident details in: /u01/grid/diag/asm/+asm/+ASM1/incident/incdir_337185/+ASM1_arb0_39278_i337185.trc Global Resource Directory partially frozen for dirty detach * dirty detach - domain 1 invalid = TRUE 2341 GCS resources traversed, 0 cancelled Dirty Detach Reconfiguration complete freeing rdom 1 Fri Oct 09 20:48:13 2020 WARNING: dirty detached from domain 1 NOTE: cache dismounted group 1/0x0739536C (DATA)
错误信息比较明显dsk=8 blk=7 au=0 blk=7 的check值不对,本来应该是2190395015现在变为了2182009786,通过kfed分析确实如此
C:\Users\Administrator>kfed read f:/temp/xff/2.dd blkn=7|more kfbh.endian: 1 ; 0x000: 0x01 kfbh.hard: 130 ; 0x001: 0x82 kfbh.type: 3 ; 0x002: KFBTYP_ALLOCTBL kfbh.datfmt: 2 ; 0x003: 0x02 kfbh.block.blk: 7 ; 0x004: blk=7 kfbh.block.obj: 2147483656 ; 0x008: disk=8 kfbh.check: 2182009786 ; 0x00c: 0x820ed3ba kfbh.fcn.base: 2711248 ; 0x010: 0x00295ed0 kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 kfbh.spare1: 0 ; 0x018: 0x00000000 kfbh.spare2: 0 ; 0x01c: 0x00000000 kfdatb.aunum: 2240 ; 0x000: 0x000008c0 kfdatb.shrink: 448 ; 0x004: 0x01c0 kfdatb.ub2pad: 0 ; 0x006: 0x0000 kfdatb.auinfo[0].link.next: 8 ; 0x008: 0x0008 kfdatb.auinfo[0].link.prev: 8 ; 0x00a: 0x0008 kfdatb.auinfo[1].link.next: 12 ; 0x00c: 0x000c kfdatb.auinfo[1].link.prev: 12 ; 0x00e: 0x000c kfdatb.auinfo[2].link.next: 16 ; 0x010: 0x0010 kfdatb.auinfo[2].link.prev: 16 ; 0x012: 0x0010 kfdatb.auinfo[3].link.next: 20 ; 0x014: 0x0014 kfdatb.auinfo[3].link.prev: 20 ; 0x016: 0x0014 kfdatb.auinfo[4].link.next: 24 ; 0x018: 0x0018 kfdatb.auinfo[4].link.prev: 24 ; 0x01a: 0x0018 kfdatb.auinfo[5].link.next: 28 ; 0x01c: 0x001c kfdatb.auinfo[5].link.prev: 28 ; 0x01e: 0x001c kfdatb.auinfo[6].link.next: 32 ; 0x020: 0x0020 kfdatb.auinfo[6].link.prev: 32 ; 0x022: 0x0020 kfdatb.spare: 0 ; 0x024: 0x00000000
修改该值之后,再次mount data磁盘组,报错如下
Sat Oct 10 13:49:22 2020 ARB0 started with pid=28, OS id=10329 NOTE: assigning ARB0 to group 1/0x3759521c (DATA) with 10 parallel I/Os cellip.ora not found. Sat Oct 10 13:49:26 2020 NOTE: GroupBlock outside rolling migration privileged region NOTE: requesting all-instance membership refresh for group=1 WARNING: cache read a corrupt block: group=1(DATA) dsk=8 blk=8 disk=8 (DATA_0008) incarn=3916014011 au=0 blk=8 count=1 Errors in file /u01/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_10329.trc: ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [8] [0 != 1] NOTE: a corrupted block from group DATA was dumped to /u01/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_10329.trc WARNING:cache read(retry)a corrupt block: group=1(DATA)dsk=8 blk=8 disk=8(DATA_0008)incarn=3916014011 au=0 blk=8 count=1 Errors in file /u01/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_10329.trc: ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [8] [0 != 1] ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [8] [0 != 1] ERROR: cache failed to read group=1(DATA) dsk=8 blk=8 from disk(s): 8(DATA_0008) ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [8] [0 != 1] ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [8] [0 != 1] NOTE: cache initiating offline of disk 8 group DATA NOTE: process _arb0_+asm1 (10329) initiating offline of disk 8.3916014011 (DATA_0008) with mask 0x7e in group 1 NOTE: initiating PST update: grp = 1, dsk = 8/0xe969a1bb, mask = 0x6a, op = clear GMON updating disk modes for group 1 at 64 for pid 28, osid 10329 ERROR: Disk 8 cannot be offlined, since diskgroup has external redundancy. ERROR: too many offline disks in PST (grp 1) Sat Oct 10 13:49:28 2020 NOTE: cache dismounting (not clean) group 1/0x3759521C (DATA) WARNING: Offline for disk DATA_0008 in mode 0x7f failed. Sat Oct 10 13:49:28 2020 NOTE: halting all I/Os to diskgroup 1 (DATA) NOTE: messaging CKPT to quiesce pins Unix process pid: 10346, image: oracle@rac1 (B000) Errors in file /u01/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_10329.trc (incident=363107): ORA-15335: ASM metadata corruption detected in disk group 'DATA' ORA-15130: diskgroup "DATA" is being dismounted ORA-15066: offlining disk "DATA_0008" in group "DATA" may result in a data loss ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [8] [0 != 1] ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483656] [8] [0 != 1] Incident details in: /u01/grid/diag/asm/+asm/+ASM1/incident/incdir_363107/+ASM1_arb0_10329_i363107.trc
该报错为:dsk=8 blk=7 au=0 blk=8异常,通过kfed查看发现
C:\Users\Administrator>kfed read f:/temp/xff/2.dd blkn=8
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
006BE8C00 00000000 00000000 00000000 00000000 [................]
Repeat 31 times
006BE8E00 012C0000 04AFFC07 003BFFCD 03F15BD0 [..,.......;..[..]
006BE8E10 012BFC30 00000000 00000002 00000002 [0.+.............]
006BE8E20 00008000 00008000 00002000 564F22AF [......... ..."OV]
006BE8E30 5F805293 FFFF0002 0001EF53 00000001 [.R._....S.......]
006BE8E40 545AE384 00000000 00000000 00000001 [..ZT............]
006BE8E50 00000000 0000000B 00000100 0000003C [............<...]
006BE8E60 00000242 0000007B 52438BA0 C44FFA90 [B...{.....CR..O.]
006BE8E70 33B6F381 919E2DBA 00000000 00000000 [...3.-..........]
006BE8E80 00000000 00000000 6361622F 0070756B [......../backup.]
006BE8E90 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
006BE8EC0 00000000 00000000 00000000 03ED0000 [................]
006BE8ED0 00000000 00000000 00000000 00000000 [................]
006BE8EE0 00000008 00000000 00000000 AC3C87D6 [..............<.]
006BE8EF0 F1401174 F4F036BD 274FB92F 00000101 [t.@..6../.O'....]
006BE8F00 0000000C 00000000 545AE384 0002F30A [..........ZT....]
006BE8F10 00000004 00000000 00000000 00007FFF [................]
006BE8F20 02508000 00007FFF 00000001 0250FFFF [..P...........P.]
006BE8F30 00000000 00000000 00000000 00000000 [................]
006BE8F40 00000000 00000000 00000000 08000000 [................]
006BE8F50 00000000 00000000 00000000 001C001C [................]
006BE8F60 00000001 00000000 00000000 00000000 [................]
006BE8F70 00000000 00000004 A9AF72B9 0000003B [.........r..;...]
006BE8F80 00000000 00000000 00000000 00000000 [................]
Repeat 167 times
006BE9A00 00001CC4 00800101 00001CC9 00800101 [................]
006BE9A10 00001CCD 00800101 00001CD2 00800101 [................]
006BE9A20 00001CD7 00800101 00001CDE 00800101 [................]
006BE9A30 00001CE3 00800101 00001CE8 00800101 [................]
006BE9A40 00001CEC 00800101 00000000 00000000 [................]
006BE9A50 00000000 00000000 00000000 00000000 [................]
Repeat 26 times
KFED-00322:Invalid content encountered during block traversal: [kfbtTraverseBlock][Invalid OSM block type][][0]
该block完全损坏,基本上无直接修复的可能,通过对data 磁盘组进行patch操作,让其mount之后不再dismount
NOTE: GMON heartbeating for grp 1 GMON querying group 1 at 76 for pid 27, osid 14466 NOTE: cache opening disk 0 of grp 1: DATA_0000 path:/dev/emcpowere NOTE: F1X0 found on disk 0 au 2 fcn 0.2708382 NOTE: cache opening disk 1 of grp 1: DATA_0001 path:/dev/emcpowerf NOTE: cache opening disk 2 of grp 1: DATA_0002 path:/dev/emcpowerg NOTE: cache opening disk 3 of grp 1: DATA_0003 path:/dev/emcpowerh NOTE: cache opening disk 4 of grp 1: DATA_0004 path:/dev/emcpoweri NOTE: cache opening disk 5 of grp 1: DATA_0005 path:/dev/emcpowerj NOTE: cache opening disk 6 of grp 1: DATA_0006 path:/dev/emcpowerk NOTE: cache opening disk 7 of grp 1: DATA_0007 path:/dev/emcpowerl NOTE: cache opening disk 8 of grp 1: DATA_0008 path:/dev/emcpowerc NOTE: cache mounting (first) external redundancy group 1/0x47495222 (DATA) Sat Oct 10 13:59:38 2020 * allocate domain 1, invalid = TRUE Sat Oct 10 13:59:38 2020 NOTE: attached to recovery domain 1 NOTE: starting recovery of thread=1 ckpt=53.6778 group=1 (DATA) NOTE: advancing ckpt for group 1 (DATA) thread=1 ckpt=53.6778 NOTE: cache recovered group 1 to fcn 0.2961429 NOTE: redo buffer size is 256 blocks (1053184 bytes) Sat Oct 10 13:59:38 2020 NOTE: LGWR attempting to mount thread 1 for diskgroup 1 (DATA) NOTE: LGWR found thread 1 closed at ABA 53.6777 NOTE: LGWR mounted thread 1 for diskgroup 1 (DATA) NOTE: LGWR opening thread 1 at fcn 0.2961429 ABA 54.6778 NOTE: cache mounting group 1/0x47495222 (DATA) succeeded NOTE: cache ending mount (success) of group DATA number=1 incarn=0x47495222 NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1 SUCCESS: diskgroup DATA was mounted SUCCESS: alter diskgroup data mount
然后通过rman备份数据库,删除老磁盘组,创建新磁盘组,恢复数据,实现数据库完美恢复,数据0丢失.
 |
|