标签云
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,664)
- DB2 (22)
- MySQL (72)
- Oracle (1,527)
- Data Guard (51)
- EXADATA (8)
- GoldenGate (21)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (14)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (65)
- Oracle Bug (8)
- Oracle RAC (52)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (558)
- Oracle安装升级 (90)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (77)
- 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)
-
最近发表
- 通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评
- ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME
- ORA-01092 ORA-00604 ORA-01558故障处理
- ORA-65088: database open should be retried
- Oracle 19c异常恢复—ORA-01209/ORA-65088
- ORA-600 16703故障再现
- 数据库启动报ORA-27102 OSD-00026 O/S-Error: (OS 1455)
- .[metro777@cock.li].Elbie勒索病毒加密数据库恢复
- 应用连接错误,初始化mysql数据库恢复
- RAC默认服务配置优先节点
- Oracle 19c RAC 替换私网操作
- 监听报TNS-12541 TNS-12560 TNS-00511错误
- drop tablespace xxx including contents恢复
- Linux 8 修改网卡名称
- 如何修改集群的公网信息(包括 VIP) (Doc ID 1674442.1)
- 如何在 oracle 集群环境下修改私网信息 (Doc ID 2103317.1)
- ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt] 相关bug
- ORA-600 krhpfh_03-1210故障处理
- 19c库启动报ORA-600 kcbzib_kcrsds_1
- DBMS_SESSION.set_context提示ORA-01031问题解决
标签归档:csc
csc higher than block scn类型坏块修复
数据库虽然正常open了,但是由于system有坏块,导致数据库导出有部分表报错,客户希望通过修复坏块完美解决该问题
bbed检查system报坏块
C:\Users\FAL>dbv file=D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF DBVERIFY: Release 11.2.0.1.0 - Production on 星期六 5月 14 15:40:55 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. DBVERIFY - 开始验证: FILE = D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF csc(0x0000.1f8adab3) higher than block scn(0x0000.00000000) 页 122146 失败, 校验代码为 6054 DBVERIFY - 验证完成 检查的页总数: 252160 处理的页总数 (数据): 178921 失败的页总数 (数据): 0 处理的页总数 (索引): 52576 失败的页总数 (索引): 1 处理的页总数 (其他): 3201 处理的总页数 (段) : 1 失败的总页数 (段) : 0 空的页总数: 17462 标记为损坏的总页数: 0 流入的页总数: 0 加密的总页数 : 0 最高块 SCN : 529420540 (0.529420540)
bbed修复坏块
C:\Users\FAL>bbed password=blockedit filename=D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF BBED: Release 2.0.0.0.0 - Limited Production on Sat May 14 15:37:01 2016 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. ************* !!! For Oracle Internal Use only !!! *************** BBED> set blocksize 8192 BLOCKSIZE 8192 BBED> set block 2 BLOCK# 2 BBED> map File: D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF (0) Block: 2 Dba:0x00000000 ------------------------------------------------------------ Data File Header struct kcvfh, 360 bytes @0 ub4 tailchk @8188 BBED> set block 122147 BLOCK# 122147 BBED> map File: D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF (0) Block: 122147 Dba:0x00000000 ------------------------------------------------------------ KTB Data Block (Index Leaf) struct kcbh, 20 bytes @0 struct ktbbh, 3720 bytes @20 struct kdxle, 32 bytes @3740 b2 kd_off[188] @3772 ub1 freespace[1534] @4148 ub1 rowdata[2442] @5682 ub4 tailchk @8188 BBED> p kcbh struct kcbh, 20 bytes @0 ub1 type_kcbh @0 0x06 ub1 frmt_kcbh @1 0xa2 ub1 spare1_kcbh @2 0x00 ub1 spare2_kcbh @3 0x00 ub4 rdba_kcbh @4 0x0041dd22 ub4 bas_kcbh @8 0x00000000 ub2 wrp_kcbh @12 0x0000 ub1 seq_kcbh @14 0xff ub1 flg_kcbh @15 0x04 (KCBHFCKV) ub2 chkval_kcbh @16 0x6cee ub2 spare3_kcbh @18 0x0000 BBED> verify DBVERIFY - Verification starting FILE = D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF BLOCK = 122146 Block Checking: DBA = 4316450, Block Type = KTB-managed data block Found block already marked corrupted DBVERIFY - Verification complete Total Blocks Examined : 1 Total Blocks Processed (Data) : 0 Total Blocks Failing (Data) : 0 Total Blocks Processed (Index): 1 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 BBED> set offset 8188 OFFSET 8188 BBED> map File: D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF (0) Block: 122147 Dba:0x00000000 ------------------------------------------------------------ KTB Data Block (Index Leaf) struct kcbh, 20 bytes @0 struct ktbbh, 3720 bytes @20 struct kdxle, 32 bytes @3740 b2 kd_off[188] @3772 ub1 freespace[1534] @4148 ub1 rowdata[2442] @5682 ub4 tailchk @8188 BBED> d File: D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF (0) Block: 122147 Offsets: 8188 to 8191 Dba:0x00000000 ------------------------------------------------------------------------ ff060000 <32 bytes per line> BBED> set mode edit MODE Edit BBED> m /x 01 offset 14 File: D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF (0) Block: 122147 Offsets: 14 to 525 Dba:0x00000000 ------------------------------------------------------------------------ 0104ee6c 00000200 00003500 0000b3da 8a1f0000 00009a00 030021dd 41000900 0700443d 0600531c c000628b 010000c0 00002c3f 5a1f0300 0000ca5e 05002b0a c0008685 01000080 000073d7 8a1f0400 200057a2 0500d530 c000a88e 2c000080 0000b3d7 8a1f0a00 01002848 08001101 c00084be 29000080 0000e3d7 8a1f0800 0d00d612 06008f0a c000258d 3c000080 000026d8 8a1f0100 1f0063c1 04006007 c0002887 4b000080 000046d8 8a1f0700 1e005403 0600a707 c000bd8e 40000080 00006bd8 8a1f0a00 0b000c48 08001301 c00084be 41000080 0000a2d8 8a1f0600 1b0055e6 0500c508 c0000f8b 23000080 0000fad8 8a1f0300 0600ca5e 0500220a c0008685 34000080 000040d9 8a1f0800 1300d412 0600900a c000258d 2e000080 000064d9 8a1f0600 0b0092e6 0500c608 c0000f8b 1c000080 000089d9 8a1f0a00 05001d48 08001401 c00084be 05000080 0000aed9 8a1f0400 100030a2 0500d730 c000a88e 0e000080 000016da 8a1f0800 1700c712 0600910a c000258d 33000080 000022da 8a1f0200 1100450d 0500930c c000c085 28000080 00002fda 8a1f0200 0800610d 0500940c c000c085 20000080 00004eda 8a1f0700 12003303 0600aa07 c000bd8e 0a000120 0f00b7da 8a1f0a00 13000048 08001501 c00084be 07000220 1e00f5da 8a1f0900 07000b44 0600650f c000968d 05000120 0f0004db 8a1f0300 <32 bytes per line> BBED> sum apply Check value for File 0, Block 122147: current = 0x6cee, required = 0x6cee BBED> verify DBVERIFY - Verification starting FILE = D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF BLOCK = 122146 DBVERIFY - Verification complete Total Blocks Examined : 1 Total Blocks Processed (Data) : 0 Total Blocks Failing (Data) : 0 Total Blocks Processed (Index): 1 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 BBED> m /x c1da8a1f offset 8 File: D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF (0) Block: 122147 Offsets: 8 to 519 Dba:0x00000000 ------------------------------------------------------------------------ c1da8a1f 00000104 ee6c0000 02000000 35000000 b3da8a1f 00000000 9a000300 21dd4100 09000700 443d0600 531cc000 628b0100 00c00000 2c3f5a1f 03000000 ca5e0500 2b0ac000 86850100 00800000 73d78a1f 04002000 57a20500 d530c000 a88e2c00 00800000 b3d78a1f 0a000100 28480800 1101c000 84be2900 00800000 e3d78a1f 08000d00 d6120600 8f0ac000 258d3c00 00800000 26d88a1f 01001f00 63c10400 6007c000 28874b00 00800000 46d88a1f 07001e00 54030600 a707c000 bd8e4000 00800000 6bd88a1f 0a000b00 0c480800 1301c000 84be4100 00800000 a2d88a1f 06001b00 55e60500 c508c000 0f8b2300 00800000 fad88a1f 03000600 ca5e0500 220ac000 86853400 00800000 40d98a1f 08001300 d4120600 900ac000 258d2e00 00800000 64d98a1f 06000b00 92e60500 c608c000 0f8b1c00 00800000 89d98a1f 0a000500 1d480800 1401c000 84be0500 00800000 aed98a1f 04001000 30a20500 d730c000 a88e0e00 00800000 16da8a1f 08001700 c7120600 910ac000 258d3300 00800000 22da8a1f 02001100 450d0500 930cc000 c0852800 00800000 2fda8a1f 02000800 610d0500 940cc000 c0852000 00800000 4eda8a1f 07001200 33030600 aa07c000 bd8e0a00 01200f00 b7da8a1f 0a001300 00480800 1501c000 84be0700 02201e00 f5da8a1f 09000700 0b440600 650fc000 968d0500 01200f00 <32 bytes per line> BBED> p kcbh struct kcbh, 20 bytes @0 ub1 type_kcbh @0 0x06 ub1 frmt_kcbh @1 0xa2 ub1 spare1_kcbh @2 0x00 ub1 spare2_kcbh @3 0x00 ub4 rdba_kcbh @4 0x0041dd22 ub4 bas_kcbh @8 0x1f8adac1 ub2 wrp_kcbh @12 0x0000 ub1 seq_kcbh @14 0x01 ub1 flg_kcbh @15 0x04 (KCBHFCKV) ub2 chkval_kcbh @16 0x6cee ub2 spare3_kcbh @18 0x0000 BBED> sum apply Check value for File 0, Block 122147: current = 0x7364, required = 0x7364 BBED> verify DBVERIFY - Verification starting FILE = D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF BLOCK = 122146 DBVERIFY - Verification complete Total Blocks Examined : 1 Total Blocks Processed (Data) : 0 Total Blocks Failing (Data) : 0 Total Blocks Processed (Index): 1 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0
dbv再次验证,坏块完美修复
C:\Users\FAL>dbv file=D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF DBVERIFY: Release 11.2.0.1.0 - Production on 星期六 5月 14 22:00:06 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. DBVERIFY - 开始验证: FILE = D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF DBVERIFY - 验证完成 检查的页总数: 259840 处理的页总数 (数据): 181934 失败的页总数 (数据): 0 处理的页总数 (索引): 57381 失败的页总数 (索引): 0 处理的页总数 (其他): 3218 处理的总页数 (段) : 1 失败的总页数 (段) : 0 空的页总数: 17307 标记为损坏的总页数: 0 流入的页总数: 0 加密的总页数 : 0 最高块 SCN : 530218225 (0.530218225)
通过修复之后重新导出数据
参考相似篇章:file 1 block 128 corrupted/坏块恢复—system rollback坏块修复