标签云
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
月归档:十月 2018
GANDCRAB V5.0.4 比特币加密oracle数据库恢复
接到朋友的恢复请求,win服务器文件被GANDCRAB V5.0.4的比特币勒索加密的oracle数据库(中联his[大量中文表名/xml类型]),让我们对其分析,判断是否可以恢复
通过工具对其分析,发现需要是文件头和数据文件空间使用位图相关block进行重构,主要业务数据理论上应该是好的.通过分析数据库表空间、数据文件等相关的数据库基础信息,通过人工重构,重建控制文件,经过一系列恢复,数据库强制open成功
SQL> select open_mode from v$database; OPEN_MODE -------------------- READ WRITE SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- E:\ORCLNEW1\SYSTEM01.DBF.HKNWFZ E:\ORCLNEW1\SYSAUX01.DBF.HKNWFZ E:\ORCLNEW1\UNDOTBS01.DBF.HKNWFZ E:\ORCLNEW1\USERS01.DBF.HKNWFZ E:\ORCLNEW1\BHDATA.DBF.HKNWFZ E:\ORCLNEW1\BHMAIL.DBF.HKNWFZ E:\ORCLNEW1\BHINDEX.DBF.HKNWFZ E:\ORCLNEW1\ZHBASIS.DBF.HKNWFZ E:\ORCLNEW1\ZHARCHIVES.DBF.HKNWFZ E:\ORCLNEW1\ZHSERVICES.DBF.HKNWFZ E:\ORCLNEW1\ZHADVICES.DBF.HKNWFZ E:\ORCLNEW1\ZHEXPENSES.DBF.HKNWFZ E:\ORCLNEW1\ZHMEDICINE.DBF.HKNWFZ E:\ORCLNEW1\ZHLAB.DBF.HKNWFZ E:\ORCLNEW1\ZHCHECK.DBF.HKNWFZ E:\ORCLNEW1\ZHLOB.DBF.HKNWFZ E:\ORCLNEW1\ZHINDEX.DBF.HKNWFZ E:\ORCLNEW1\SLREPORT.DBF.HKNWFZ E:\ORCLNEW1\ZHMATERIAL.DBF.HKNWFZ E:\ORCLNEW1\ZHMEDREC.DBF.HKNWFZ E:\ORCLNEW1\ZHINSURE.DBF.HKNWFZ
由于该客户的数据库中有大量的xml列类型,导致exp无法导出,只能使用expdp进行导出,因为expdp在导出过程中会创建中间表,因此又对数据库进行一些修复,确定数据库能够正常写入对象,并且数据库导出成功
发表在 Oracle备份恢复, 勒索恢复
标签为 GANDCRAB V5.0.4, oracle 比特币, oracle加密, YOUR FILES ARE ENCRYPTED, 比特币 oracle恢复
评论关闭
Assistant: Download Reference for Oracle Database/GI PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases—201810
Patchsets |
|
12.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) |
|
A10.2.0.4 (10.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
B10.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) |
18.0.0.0 |
|||
Description | Database Update | GI Update | Windows Bundle Patch |
OCT2018 (18.4.0.0.0) | 28655784 | 28659165 | NA |
JUL2018 (18.3.0.0.0) | 28090523 | 28096386 | NA |
APR2018 (18.2.0.0.0) | 27676517 | 27681568 | NA |
12.2.0.1 |
|||
Description | Database Update | GI Update | Windows Bundle Patch |
OCT2018 (12.2.0.1.181016) | 28662603 | 28714316 | 28574555 |
JUL2018 (12.2.0.1.180717) | 28163133 | 28183653 | 27937914 |
APR2018 (12.2.0.1.180417) | 27674384 | 27468969 | 27426753 |
JAN2018 (12.2.0.1.180116) | 27105253 | 27100009 | 27162931 |
NOV2017 (12.2.0.1.171121) | NA | 27010638 | NA |
OCT2017 (12.2.0.1.171017) | 26710464 | 26737266 | 26758841 |
AUG2017 (12.2.0.1.170814) | 26609817 | 26610291 | 26204214 |
JUL2017 (12.2.0.1.170718) | 26123830 | 26133434 | 26204212 |
12.1.0.2 |
||||
Description | PSU | GI PSU | Proactive Bundle Patch | Bundle Patch(Windows 32bit & 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) |
12.1.0.1 |
|||||
Description |
PSU |
GI PSU |
Bundle Patch |
||
A |
B |
Windows 64 bit |
Windows 32 bit |
||
JUL2016 (12.1.0.1.160719) |
23273935 | ||||
APR2016 (12.1.0.1.160419) |
|||||
JAN2016 (12.1.0.1.160119) |
|||||
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 | PSU | SPU(CPU) | GI PSU | Bundle Patch (Windows 32bit & 64bit) |
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) |
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 (Windows 64bit) |
Bundle Patch (Windows 32bit) |
OCT2013 |
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 (Windows 64bit) |
Bundle Patch (Windows 32bit) |
JUL2011 |
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 |
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) |
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 |
|||
OCT2013 |
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) |
N/A |
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 (Windows 32bit) |
Bundle Patch (Windows 64bit) |
Bundle Patch (Windows Itanium) |
JUL2013 |
16619897 (10.2.0.4.17) |
N/A |
N/A |
N/A |
|
APR2013 |
16056269 (10.2.0.4.16) |
N/A |
N/A |
N/A |
|
JAN2013 |
14736542 (10.2.0.4.15) |
N/A |
N/A |
N/A |
|
OCT2012 |
14275630 (10.2.0.4.14) |
N/A |
N/A |
N/A |
|
JUL2012 |
13923851 (10.2.0.4.13) |
N/A |
N/A |
N/A |
|
APR2012 |
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 (Windows 32bit) |
Bundle Patch (Windows Itanium) |
Bundle Patch (Windows 64bit) |
JAN2009 |
||||
OCT2008 |
||||
JUL2008 |
||||
APR2008 |
||||
JAN2008 |
||||
OCT2007 |
||||
JUL2007 |
||||
APR2007 |
||||
JAN2007 |
10.2.0.2 |
||||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows 64bit) |
Bundle Patch (Windows Itanium) |
JAN2009 |
N/A |
N/A |
N/A |
|
OCT2008 |
N/A |
N/A |
N/A |
|
JUL2008 |
N/A |
N/A |
N/A |
|
APR2008 |
N/A |
N/A |
N/A |
|
JAN2008 |
N/A |
N/A |
N/A |
|
OCT2007 |
||||
JUL2007 |
||||
APR2007 |
||||
JAN2007 |
||||
OCT2006 |
||||
JUL2006 |
||||
APR2006 |
10.2.0.1 |
||||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows 64bit) |
Bundle Patch (Windows Itanium) |
APR2007 |
N/A |
N/A |
N/A |
|
JAN2007 |
||||
OCT2006 |
||||
JUL2006 |
||||
APR2006 |
||||
JAN2006 |
10.1.0.5 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
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 (Windows 32bit) |
Bundle Patch (Windows Itanium) |
APR2007 |
|||
JAN2007 |
|||
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
|||
APR2005 |
10.1.0.3 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
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 (Windows 32bit) |
Bundle Patch (Windows Itanium) |
APR2005 |
|||
JUL2005 |
|||
JAN2005 |
9.2.0.8 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
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 (Windows 32bit) |
Bundle Patch (Windows Itanium) |
JUL2007 |
|||
APR2007 |
|||
JAN2007 |
|||
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
N/A |
N/A |
9.2.0.6 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
|||
APR2005 |
9.2.0.5 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
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 (Windows 32bit) |
Bundle Patch (Windows Itanium) |
JAN2005 |
8.1.7.4 |
||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
JAN2007 |
||
OCT2006 |
||
JUL2006 |
||
APR2006 |
||
JAN2006 |
||
OCT2005 |
||
JUL2005 |
||
APR2005 |
||
JAN2005 |
参考:Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (文档 ID 2118136.2)
restore database误操作恢复
接到朋友恢复请求,由于客户的误操作(生产库遇到问题,无法正常open,在没有确认备份和归档日志完全正常的情况下,直接restore database操作),导致原库数据文件被备份中的数据文件还原,而且中间归档丢失,无法一直应用归档把数据文件追到最新.通过Oracle Database Recovery Check脚本check数据库结果如下
这里很明显红色框中数据文件被还原,发现一个可喜的地方,被还原的文件相对都比较小,也就是说相对覆盖的部分可能不会太多.通过alert日志确认数据被rman还原覆盖
然后继续应用日志恢复
悲剧发生了明显thread 2的sequence 297归档日志发现丢失,进一步发现这个rac(2节点)一共丢失了300个左右的归档日志.到这一步常规方法来说,基本上无解,放弃数据库恢复,因为基于现在的情况客户2014-07-27 07:18:12创建的,目前只是恢复到了2014-10-20 08:26:43日期的数据,而且通过数据库现状判断,数据库主要是写入file 4,也就是users表空间的第一个数据文件中,而该文件已经被还原,强制拉库没有意义.考虑通过bbed修改文件头,跳过相关丢失的归档,继续应用以后的归档,因为跳过的归档太多,基本上不可行(跳过这些丢失的归档之后,后面的归档继续应用会报错).基于这样的情况,抱着一丝丝的希望,rman备份是业务上线之后备份(这样被还原的system里面就有完整的业务数据字典信息).通过对system文件进行分析,确认我们比较幸运,业务数据创建于2014-8月份,而且根据客户的反馈之后基本上没有变更.参考:asm disk header 彻底损坏恢复方法扫描效果比较好,file 4 的觉大部分block均存在
然后通过这些block重组成数据文件然后结合以前的system文件,强制open库,基本上实现客户数据的绝大部分恢复.
类似案例还有:
asm磁盘组误删除文件恢复
又一例asm格式化文件系统恢复
Oracle 数据文件大小为0kb或者文件丢失恢复
oracle asm disk格式化恢复—格式化为ntfs文件系统
oracle asm disk格式化恢复—格式化为ext4文件系统
alter database create datafile 导致数据文件丢失恢复
分享oracleasm createdisk重新创建asm disk后数据0丢失恢复案例