标签云
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 2131 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)
- 操作系统 (102)
- 数据库 (1,681)
- DB2 (22)
- MySQL (73)
- Oracle (1,543)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (67)
- Oracle Bug (8)
- Oracle RAC (53)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (564)
- Oracle安装升级 (92)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (79)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- ORA-00227: corrupt block detected in control file
- 手工删除19c rac
- 解决oracle数据文件路径有回车故障
- .wstop扩展名勒索数据库恢复
- Oracle Recovery Tools工具一键解决ORA-00376 ORA-01110故障(文件offline)
- OGG-02771 Input trail file format RELEASE 19.1 is different from previous trail file form at RELEASE 11.2.
- OGG-02246 Source redo compatibility level 19.0.0 requires trail FORMAT 12.2 or higher
- GoldenGate 19安装和打patch
- dd破坏asm磁盘头恢复
- 删除asmlib磁盘导致磁盘组故障恢复
- Kylin Linux 安装19c
- ORA-600 krse_arc_complete.4
- Oracle 19c 202410补丁(RUs+OJVM)
- ntfs MFT损坏(ntfs文件系统故障)导致oracle异常恢复
- .mkp扩展名oracle数据文件加密恢复
- 清空redo,导致ORA-27048: skgfifi: file header information is invalid
- A_H_README_TO_RECOVER勒索恢复
- 通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评
- ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME
- ORA-01092 ORA-00604 ORA-01558故障处理
分类目录归档:ORACLE 21C
Oracle 21c强制使用cdb模式
Oracle dul 依旧支持Oracle 21c
ORACEL 21C版本数据库信息
[oracle@www.xifenfei.com ~]$ ss SQL*Plus: Release 21.0.0.0.0 - Production on Sat Aug 14 02:05:14 2021 Version 21.3.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/XFF/system01.dbf /u01/app/oracle/oradata/XFF/sysaux01.dbf /u01/app/oracle/oradata/XFF/undotbs01.dbf /u01/app/oracle/oradata/XFF/pdbseed/system01.dbf /u01/app/oracle/oradata/XFF/pdbseed/sysaux01.dbf /u01/app/oracle/oradata/XFF/users01.dbf /u01/app/oracle/oradata/XFF/pdbseed/undotbs01.dbf /u01/app/oracle/oradata/XFF/XFFpdb1/system01.dbf /u01/app/oracle/oradata/XFF/XFFpdb1/sysaux01.dbf /u01/app/oracle/oradata/XFF/XFFpdb1/undotbs01.dbf /u01/app/oracle/oradata/XFF/XFFpdb1/users01.dbf 11 rows selected. SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- BANNER_FULL -------------------------------------------------------------------------------- BANNER_LEGACY -------------------------------------------------------------------------------- CON_ID ---------- Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production 0
dul 依旧支持 oracle 12c
[oracle@www.xifenfei.com dul]$ ./dul Data UnLoader: 12.2.0.0.2 - Internal Only - on Sat Aug 14 02:20:28 2021 with 64-bit io functions and the decompression option Copyright (c) 1994 2021 Bernard van Duijnen All rights reserved. Strictly Oracle Internal Use Only DUL: Warning: ulimit process stack size is only 33554432 Found db_id = 1608306320 Found db_name = ORCL DUL> show datafiles; ts# rf# start blocks offs open err file name 0 1 0 170241 0 1 0 /u01/app/oracle/oradata/XFF/system01.dbf 1 3 0 74241 0 1 0 /u01/app/oracle/oradata/XFF/sysaux01.dbf DUL> bootstrap; Probing file = 1, block = 520 . unloading table BOOTSTRAP$ DUL: Warning: block number is non zero but marked deferred trying to process it anyhow 60 rows unloaded Reading BOOTSTRAP.dat 60 entries loaded Parsing Bootstrap$ contents Generating dict.ddl for version 12 OBJ$: segobjno 18, file 1 block 240 TAB$: segobjno 2, tabno 1, file 1 block 144 COL$: segobjno 2, tabno 5, file 1 block 144 USER$: segobjno 10, tabno 1, file 1 block 208 Running generated file "@dict.ddl" to unload the dictionary tables . unloading table OBJ$ 75192 rows unloaded . unloading table TAB$ 2389 rows unloaded . unloading table COL$ 130794 rows unloaded . unloading table USER$ 129 rows unloaded Reading USER.dat 129 entries loaded Reading OBJ.dat 75192 entries loaded and sorted 75192 entries Reading TAB.dat 2389 entries loaded Reading COL.dat 130794 entries loaded and sorted 130794 entries Reading BOOTSTRAP.dat 60 entries loaded DUL: Warning: Recreating file "dict.ddl" Generating dict.ddl for version 12 OBJ$: segobjno 18, file 1 block 240 TAB$: segobjno 2, tabno 1, file 1 block 144 COL$: segobjno 2, tabno 5, file 1 block 144 USER$: segobjno 10, tabno 1, file 1 block 208 TABPART$: segobjno 835, file 1 block 5560 INDPART$: segobjno 840, file 1 block 5600 TABCOMPART$: segobjno 857, file 1 block 5736 INDCOMPART$: segobjno 862, file 1 block 5784 TABSUBPART$: segobjno 847, file 1 block 5656 INDSUBPART$: segobjno 852, file 1 block 5696 IND$: segobjno 2, tabno 3, file 1 block 144 ICOL$: segobjno 2, tabno 4, file 1 block 144 LOB$: segobjno 2, tabno 6, file 1 block 144 COLTYPE$: segobjno 2, tabno 7, file 1 block 144 TYPE$: segobjno 761, tabno 1, file 1 block 5024 COLLECTION$: segobjno 761, tabno 2, file 1 block 5024 ATTRIBUTE$: segobjno 761, tabno 3, file 1 block 5024 LOBFRAG$: segobjno 868, file 1 block 5832 LOBCOMPPART$: segobjno 871, file 1 block 5856 UNDO$: segobjno 15, file 1 block 224 TS$: segobjno 6, tabno 2, file 1 block 176 PROPS$: segobjno 127, file 1 block 1320 Running generated file "@dict.ddl" to unload the dictionary tables . unloading table OBJ$ DUL: Warning: Recreating file "OBJ.ctl" 75192 rows unloaded . unloading table TAB$ DUL: Warning: Recreating file "TAB.ctl" 2389 rows unloaded . unloading table COL$ DUL: Warning: Recreating file "COL.ctl" 130794 rows unloaded . unloading table USER$ DUL: Warning: Recreating file "USER.ctl" 129 rows unloaded . unloading table TABPART$ 492 rows unloaded . unloading table INDPART$ 365 rows unloaded . unloading table TABCOMPART$ 1 row unloaded . unloading table INDCOMPART$ 0 rows unloaded . unloading table TABSUBPART$ 32 rows unloaded . unloading table INDSUBPART$ 0 rows unloaded . unloading table IND$ 3095 rows unloaded . unloading table ICOL$ 5657 rows unloaded . unloading table LOB$ 712 rows unloaded . unloading table COLTYPE$ 3251 rows unloaded . unloading table TYPE$ 6053 rows unloaded . unloading table COLLECTION$ 1450 rows unloaded . unloading table ATTRIBUTE$ 15958 rows unloaded . unloading table LOBFRAG$ 19 rows unloaded . unloading table LOBCOMPPART$ 0 rows unloaded . unloading table UNDO$ 21 rows unloaded . unloading table TS$ 6 rows unloaded . unloading table PROPS$ 45 rows unloaded Reading USER.dat 129 entries loaded Reading OBJ.dat 75192 entries loaded and sorted 75192 entries Reading TAB.dat 2389 entries loaded Reading COL.dat 130794 entries loaded and sorted 130794 entries Reading TABPART.dat 492 entries loaded and sorted 492 entries Reading TABCOMPART.dat 1 entries loaded and sorted 1 entries Reading TABSUBPART.dat 32 entries loaded and sorted 32 entries Reading INDPART.dat 365 entries loaded and sorted 365 entries Reading INDCOMPART.dat 0 entries loaded and sorted 0 entries Reading INDSUBPART.dat 0 entries loaded and sorted 0 entries Reading IND.dat 3095 entries loaded Reading LOB.dat 712 entries loaded Reading ICOL.dat 5657 entries loaded Reading COLTYPE.dat 3251 entries loaded Reading TYPE.dat DUL: Notice: Increased the size of DC_TYPES from 4096 to 32768 entries 6053 entries loaded Reading ATTRIBUTE.dat 15958 entries loaded Reading COLLECTION.dat DUL: Notice: Increased the size of DC_COLLECTIONS from 1024 to 8192 entries 1450 entries loaded Reading BOOTSTRAP.dat 60 entries loaded Reading LOBFRAG.dat 19 entries loaded and sorted 19 entries Reading LOBCOMPPART.dat 0 entries loaded and sorted 0 entries Reading UNDO.dat 21 entries loaded Reading TS.dat 6 entries loaded Reading PROPS.dat 45 entries loaded Database character set is AL32UTF8 Database national character set is AL16UTF16 DUL> unload table sys.props$; . unloading table PROPS$ 45 rows unloaded DUL> exit Life is DUL without it [oracle@www.xifenfei.com dul]$ grep NLS_RDBMS_VERSION SYS_PROPS.dat |NLS_RDBMS_VERSION| |21.0.0.0.0| |RDBMS version for NLS parameters|
bbed依旧支持Oracle 21c
ORACEL 21C版本数据库信息
[oracle@www.xifenfei.com ~]$ ss SQL*Plus: Release 21.0.0.0.0 - Production on Sat Aug 14 02:05:14 2021 Version 21.3.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/XFF/system01.dbf /u01/app/oracle/oradata/XFF/sysaux01.dbf /u01/app/oracle/oradata/XFF/undotbs01.dbf /u01/app/oracle/oradata/XFF/pdbseed/system01.dbf /u01/app/oracle/oradata/XFF/pdbseed/sysaux01.dbf /u01/app/oracle/oradata/XFF/users01.dbf /u01/app/oracle/oradata/XFF/pdbseed/undotbs01.dbf /u01/app/oracle/oradata/XFF/XFFpdb1/system01.dbf /u01/app/oracle/oradata/XFF/XFFpdb1/sysaux01.dbf /u01/app/oracle/oradata/XFF/XFFpdb1/undotbs01.dbf /u01/app/oracle/oradata/XFF/XFFpdb1/users01.dbf 11 rows selected. SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- BANNER_FULL -------------------------------------------------------------------------------- BANNER_LEGACY -------------------------------------------------------------------------------- CON_ID ---------- Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production 0
bbed可以正常使用
[oracle@www.xifenfei.com db_1]$ bbed Password: BBED: Release 2.0.0.0.0 - Limited Production on Sat Aug 14 02:06:58 2021 Copyright (c) 1982, 2021, Oracle and/or its affiliates. All rights reserved. ************* !!! For Oracle Internal Use only !!! *************** BBED> set filename '/u01/app/oracle/oradata/XFF/system01.dbf' FILENAME /u01/app/oracle/oradata/XFF/system01.dbf BBED> set blocksize 8192 BLOCKSIZE 8192 BBED> map /v File: /u01/app/oracle/oradata/XFF/system01.dbf (0) Block: 1 Dba:0x00000000 ------------------------------------------------------------ Data File Header struct kcvfh, 1272 bytes @0 struct kcvfhbfh, 20 bytes @0 struct kcvfhhdr, 76 bytes @20 ub4 kcvfhrdb @96 struct kcvfhcrs, 8 bytes @100 ub4 kcvfhcrt @108 ub4 kcvfhrlc @112 struct kcvfhrls, 8 bytes @116 ub4 kcvfhbti @124 struct kcvfhbsc, 8 bytes @128 ub2 kcvfhbth @136 ub2 kcvfhsta @138 struct kcvfhckp, 36 bytes @484 ub4 kcvfhcpc @140 ub4 kcvfhrts @144 ub4 kcvfhccc @148 struct kcvfhbcp, 36 bytes @152 ub4 kcvfhbhz @312 struct kcvfhxcd, 16 bytes @316 sword kcvfhtsn @332 ub2 kcvfhtln @336 text kcvfhtnm[30] @338 ub4 kcvfhrfn @368 struct kcvfhrfs, 8 bytes @372 ub4 kcvfhrft @380 struct kcvfhafs, 8 bytes @384 ub4 kcvfhbbc @392 ub4 kcvfhncb @396 ub4 kcvfhmcb @400 ub4 kcvfhlcb @404 ub4 kcvfhbcs @408 ub2 kcvfhofb @412 ub2 kcvfhnfb @414 ub4 kcvfhprc @416 struct kcvfhprs, 8 bytes @420 struct kcvfhprfs, 8 bytes @428 ub4 kcvfhtrt @444 ub4 tailchk @8188 BBED> p kcvfh struct kcvfh, 1272 bytes @0 struct kcvfhbfh, 20 bytes @0 ub1 type_kcbh @0 0x0b ub1 frmt_kcbh @1 0xa2 ub2 wrp2_kcbh @2 0x0000 ub4 rdba_kcbh @4 0x00400001 ub4 bas_kcbh @8 0x00000000 ub2 wrp_kcbh @12 0x0000 ub1 seq_kcbh @14 0x01 ub1 flg_kcbh @15 0x04 (KCBHFCKV) ub2 chkval_kcbh @16 0xeeed ub2 spare3_kcbh @18 0x0000 struct kcvfhhdr, 76 bytes @20 ub4 kccfhswv @20 0x00000000 ub4 kccfhcvn @24 0x15000000 ub4 kccfhdbi @28 0x5fdcce90 text kccfhdbn[0] @32 O text kccfhdbn[1] @33 R text kccfhdbn[2] @34 C text kccfhdbn[3] @35 L text kccfhdbn[4] @36 text kccfhdbn[5] @37 text kccfhdbn[6] @38 text kccfhdbn[7] @39 ub4 kccfhcsq @40 0x000004c7 ub4 kccfhfsz @44 0x00029900 s_blkz kccfhbsz @48 0x00 ub2 kccfhfno @52 0x0001 ub2 kccfhtyp @54 0x0003 ub4 kccfhacid @56 0x00000000 ub4 kccfhcks @60 0x00000000 text kccfhtag[0] @64 text kccfhtag[1] @65 text kccfhtag[2] @66 text kccfhtag[3] @67 text kccfhtag[4] @68 text kccfhtag[5] @69 text kccfhtag[6] @70 text kccfhtag[7] @71 text kccfhtag[8] @72 text kccfhtag[9] @73 text kccfhtag[10] @74 text kccfhtag[11] @75 text kccfhtag[12] @76 text kccfhtag[13] @77 text kccfhtag[14] @78 text kccfhtag[15] @79 text kccfhtag[16] @80 text kccfhtag[17] @81 text kccfhtag[18] @82 text kccfhtag[19] @83 text kccfhtag[20] @84 text kccfhtag[21] @85 text kccfhtag[22] @86 text kccfhtag[23] @87 text kccfhtag[24] @88 text kccfhtag[25] @89 text kccfhtag[26] @90 text kccfhtag[27] @91 text kccfhtag[28] @92 text kccfhtag[29] @93 text kccfhtag[30] @94 text kccfhtag[31] @95 ub4 kcvfhrdb @96 0x00400208 struct kcvfhcrs, 8 bytes @100 ub4 kscnbas @100 0x00000008 ub2 kscnwrp @104 0x8000 ub2 kscnwrp2 @106 0x0000 ub4 kcvfhcrt @108 0x4050b9a0 ub4 kcvfhrlc @112 0x40678310 struct kcvfhrls, 8 bytes @116 ub4 kscnbas @116 0x0027b373 ub2 kscnwrp @120 0x8000 ub2 kscnwrp2 @122 0x0000 ub4 kcvfhbti @124 0x00000000 struct kcvfhbsc, 8 bytes @128 ub4 kscnbas @128 0x00000000 ub2 kscnwrp @132 0x0000 ub2 kscnwrp2 @134 0x0000 ub2 kcvfhbth @136 0x0000 ub2 kcvfhsta @138 0x2004 (KCVFHOFZ) struct kcvfhckp, 36 bytes @484 struct kcvcpscn, 8 bytes @484 ub4 kscnbas @484 0x002874e0 ub2 kscnwrp @488 0x8000 ub2 kscnwrp2 @490 0x0000 ub4 kcvcptim @492 0x406783fd ub2 kcvcpthr @496 0x0001 union u, 12 bytes @500 struct kcvcprba, 12 bytes @500 ub4 kcrbaseq @500 0x00000003 ub4 kcrbabno @504 0x00000f12 ub2 kcrbabof @508 0x0010 ub1 kcvcpetb[0] @512 0x02 ub1 kcvcpetb[1] @513 0x00 ub1 kcvcpetb[2] @514 0x00 ub1 kcvcpetb[3] @515 0x00 ub1 kcvcpetb[4] @516 0x00 ub1 kcvcpetb[5] @517 0x00 ub1 kcvcpetb[6] @518 0x00 ub1 kcvcpetb[7] @519 0x00 ub4 kcvfhcpc @140 0x00000030 ub4 kcvfhrts @144 0x406782f4 ub4 kcvfhccc @148 0x0000002f struct kcvfhbcp, 36 bytes @152 struct kcvcpscn, 8 bytes @152 ub4 kscnbas @152 0x00000000 ub2 kscnwrp @156 0x0000 ub2 kscnwrp2 @158 0x0000 ub4 kcvcptim @160 0x00000000 ub2 kcvcpthr @164 0x0000 union u, 12 bytes @168 struct kcvcprba, 12 bytes @168 ub4 kcrbaseq @168 0x00000000 ub4 kcrbabno @172 0x00000000 ub2 kcrbabof @176 0x0000 ub1 kcvcpetb[0] @180 0x00 ub1 kcvcpetb[1] @181 0x00 ub1 kcvcpetb[2] @182 0x00 ub1 kcvcpetb[3] @183 0x00 ub1 kcvcpetb[4] @184 0x00 ub1 kcvcpetb[5] @185 0x00 ub1 kcvcpetb[6] @186 0x00 ub1 kcvcpetb[7] @187 0x00 ub4 kcvfhbhz @312 0x00000000 struct kcvfhxcd, 16 bytes @316 ub4 space_kcvmxcd[0] @316 0x00000000 ub4 space_kcvmxcd[1] @320 0x00000000 ub4 space_kcvmxcd[2] @324 0x00000000 ub4 space_kcvmxcd[3] @328 0x00000000 sword kcvfhtsn @332 0 ub2 kcvfhtln @336 0x0006 text kcvfhtnm[0] @338 S text kcvfhtnm[1] @339 Y text kcvfhtnm[2] @340 S text kcvfhtnm[3] @341 T text kcvfhtnm[4] @342 E text kcvfhtnm[5] @343 M text kcvfhtnm[6] @344 text kcvfhtnm[7] @345 text kcvfhtnm[8] @346 text kcvfhtnm[9] @347 text kcvfhtnm[10] @348 text kcvfhtnm[11] @349 text kcvfhtnm[12] @350 text kcvfhtnm[13] @351 text kcvfhtnm[14] @352 text kcvfhtnm[15] @353 text kcvfhtnm[16] @354 text kcvfhtnm[17] @355 text kcvfhtnm[18] @356 text kcvfhtnm[19] @357 text kcvfhtnm[20] @358 text kcvfhtnm[21] @359 text kcvfhtnm[22] @360 text kcvfhtnm[23] @361 text kcvfhtnm[24] @362 text kcvfhtnm[25] @363 text kcvfhtnm[26] @364 text kcvfhtnm[27] @365 text kcvfhtnm[28] @366 text kcvfhtnm[29] @367 ub4 kcvfhrfn @368 0x00000001 struct kcvfhrfs, 8 bytes @372 ub4 kscnbas @372 0x00000000 ub2 kscnwrp @376 0x0000 ub2 kscnwrp2 @378 0x0000 ub4 kcvfhrft @380 0x00000000 struct kcvfhafs, 8 bytes @384 ub4 kscnbas @384 0x00000000 ub2 kscnwrp @388 0x0000 ub2 kscnwrp2 @390 0x0000 ub4 kcvfhbbc @392 0x00000000 ub4 kcvfhncb @396 0x00000000 ub4 kcvfhmcb @400 0x00000000 ub4 kcvfhlcb @404 0x00000000 ub4 kcvfhbcs @408 0x00000000 ub2 kcvfhofb @412 0x000a ub2 kcvfhnfb @414 0x000a ub4 kcvfhprc @416 0x4050b99a struct kcvfhprs, 8 bytes @420 ub4 kscnbas @420 0x00000001 ub2 kscnwrp @424 0x0000 ub2 kscnwrp2 @426 0x0000 struct kcvfhprfs, 8 bytes @428 ub4 kscnbas @428 0x00000000 ub2 kscnwrp @432 0x0000 ub2 kscnwrp2 @434 0x0000 ub4 kcvfhtrt @444 0x00000000 BBED>
bbed真的是一个生命力强大的工具,到21c依旧可以很好的支持