BBED处理RMAN-03009，ORA-1956

最新推荐文章于 2021-09-14 22:06:06 发布
最新推荐文章于 2021-09-14 22:06:06 发布
阅读量752 收藏
点赞数
分类专栏： Oracle-故障处理 文章标签： oracle 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43299769/article/details/110192997
版权

之前模拟了allocate extent datafile方式处理free block，趁热打铁，再试下bbed处理方法,正好也学一下bbed的使用。
参考：

https://www.cnblogs.com/simple-oracle/p/10749321.html

故障环境

手里有一个11.2.0.4虚拟机，同样用bbed造坏块和truncate消除，已经重置为free blcok。检验结果如下：

  • RMAN
RMAN> backup datafile 5;   
Starting backup at 26-NOV-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=34 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/t1.dbf
channel ORA_DISK_1: starting piece 1 at 26-NOV-20
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/26/2020 14:44:05
ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/app/oracle/oradata/orcl/t1.dbf
  • DBV
[oracle@testdb ~]$ dbv file='/u01/app/oracle/oradata/orcl/t1.dbf'
DBVERIFY: Release 11.2.0.1.0 - Production on Thu Nov 26 14:44:22 2020
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/orcl/t1.dbf
Page 135 is marked corrupt
Corrupt block relative dba: 0x01400087 (file 5, block 135)
Bad header found during dbv: 
Data in bad block:
type: 1 format: 0 rdba: 0x01400087
last change scn: 0x0000.002be4ec seq: 0x1 flg: 0x06
spare1: 0x59 spare2: 0x20 spare3: 0x0
consistency value in tail: 0xe4ec0601
check value in block header: 0x4a09
computed block checksum: 0x0
Page 269 is marked corrupt
Corrupt block relative dba: 0x0140010d (file 5, block 269)
Bad header found during dbv: 
Data in bad block:
type: 18 format: 4 rdba: 0x0140010d
last change scn: 0x0000.002ac591 seq: 0x1 flg: 0x04
spare1: 0x56 spare2: 0x78 spare3: 0x0
consistency value in tail: 0xc5910601
check value in block header: 0xb862
computed block checksum: 0x0
DBVERIFY - Verification complete
Total Pages Examined         : 1792
Total Pages Processed (Data) : 1349
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 101
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 212
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 128
Total Pages Marked Corrupt   : 2
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 3184207 (0.3184207)
两个坏块： file# 5 block# 135/269

处理过程

  • bbed修改
[oracle@testdb ~]$ bbed filename='/u01/app/oracle/oradata/orcl/t1.dbf'
BBED> show mode;
        MODE            Browse

BBED> set mode edit;
        MODE            Edit

BBED> set block 269;     --修改269号块
        BLOCK#          269

BBED> show all
        FILE#           0
        BLOCK#          269
        OFFSET          0
        DBA             0x00000000 (0 0,269)
        FILENAME        /u01/app/oracle/oradata/orcl/t1.dbf
        BIFILE          bifile.bbd
        LISTFILE       
        BLOCKSIZE       8192
        MODE            Edit
        EDIT            Unrecoverable
        IBASE           Dec
        OBASE           Dec
        WIDTH           80
        COUNT           512
        LOGFILE         log.bbd
        SPOOL           No

BBED> d
 File: /u01/app/oracle/oradata/orcl/t1.dbf (0)
 Block: 269              Offsets:    0 to  511           Dba:0x00000000
------------------------------------------------------------------------
 12345678 0d014001 91c52a00 00000104 62b80000 01001700 bc1f0100 c8c42a00 
 0000e81f 021f3200 08014001 0a002100 81020000 9e35c000 c1001900 00800000 
 70c62900 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 0001cf00 0200b001 e904a61d a61d0000 cf00771f 561f0300 04000500 
 06000700 08000900 0a000b00 0c000d00 0e000f00 10001100 12001300 14001500 
 16001700 18001900 1a001b00 1c001d00 1e001f00 20002100 22002300 24002500 
 26002700 28002900 2a002b00 2c002d00 2e002f00 30003100 32003300 34003500 
 36003700 38003900 3a003b00 3c003d00 3e003f00 40004100 42004300 44004500 
 46004700 48004900 4a004b00 4c004d00 4e004f00 50005100 52005300 54005500 
 56005700 58005900 5a005b00 5c005d00 5e005f00 60006100 62006300 64006500 
 66006700 68006900 6a006b00 6c006d00 6e006f00 70007100 72007300 74007500 
 76007700 78007900 7a007b00 7c007d00 7e007f00 80008100 82008300 84008500 
 86008700 88008900 8a008b00 8c008d00 8e008f00 90009100 92009300 94009500 
 96009700 98009900 9a009b00 9c009d00 9e009f00 a000a100 a200a300 a400a500 
 a600a700 a800a900 aa00ab00 ac00ad00 ae00af00 b000b100 b200b300 b400b500 
 b600b700 b800b900 ba00bb00 bc00bd00 be00bf00 c000c100 c200c300 c400c500 

 <32 bytes per line>


BBED> copy block 268 to block 269     --拷贝前一个块，主要是方便修改rdba
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
 File: /u01/app/oracle/oradata/orcl/t1.dbf (0)
 Block: 269              Offsets:    0 to  511           Dba:0x00000000
------------------------------------------------------------------------
 06a20000 0c014001 91c52a00 00000504 f0860000 01001700 bc1f0100 0ac62900 
 0000e81f 021f3200 08014001 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 0001cf00 0000b001 e904e81d e81d0000 cf000100 02000300 04000500 
 06000700 08000900 0a000b00 0c000d00 0e000f00 10001100 12001300 14001500 
 16001700 18001900 1a001b00 1c001d00 1e001f00 20002100 22002300 24002500 
 26002700 28002900 2a002b00 2c002d00 2e002f00 30003100 32003300 34003500 
 36003700 38003900 3a003b00 3c003d00 3e003f00 40004100 42004300 44004500 
 46004700 48004900 4a004b00 4c004d00 4e004f00 50005100 52005300 54005500 
 56005700 58005900 5a005b00 5c005d00 5e005f00 60006100 62006300 64006500 
 66006700 68006900 6a006b00 6c006d00 6e006f00 70007100 72007300 74007500 
 76007700 78007900 7a007b00 7c007d00 7e007f00 80008100 82008300 84008500 
 86008700 88008900 8a008b00 8c008d00 8e008f00 90009100 92009300 94009500 
 96009700 98009900 9a009b00 9c009d00 9e009f00 a000a100 a200a300 a400a500 
 a600a700 a800a900 aa00ab00 ac00ad00 ae00af00 b000b100 b200b300 b400b500 
 b600b700 b800b900 ba00bb00 bc00bd00 be00bf00 c000c100 c200c300 c400c500 

 <32 bytes per line>

BBED> show all
        FILE#           0
        BLOCK#          269
        OFFSET          0
        DBA             0x00000000 (0 0,269)
        FILENAME        /u01/app/oracle/oradata/orcl/t1.dbf
        BIFILE          bifile.bbd
        LISTFILE       
        BLOCKSIZE       8192
        MODE            Edit
        EDIT            Unrecoverable
        IBASE           Dec
        OBASE           Dec
        WIDTH           80
        COUNT           512
        LOGFILE         log.bbd
        SPOOL           No

BBED> show block
        BLOCK#          269

--修改数据块之后，重新计算并更新checksum
BBED> sum  
Check value for File 0, Block 269:
current = 0x86f0, required = 0x86f0

BBED> v
DBVERIFY - Verification starting
FILE = /u01/app/oracle/oradata/orcl/t1.dbf
BLOCK = 269

Block 269 is corrupt
Corrupt block relative dba: 0x0140010d (file 0, block 269)  --dba: 0x0140010d  --正确的标头
Bad header found during verification   --验证期间发现错误的标头
Data in bad block:
 type: 6 format: 2 rdba: 0x0140010c    --因为是复制的，rdba还是之前一个块的值。rdba手动修改为正确的值，在第一行已经提示了          
 last change scn: 0x0000.002ac591 seq: 0x5 flg: 0x04
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0xc5910605
 check value in block header: 0x86f0
 computed block checksum: 0x0


DBVERIFY - Verification complete

Total Blocks Examined         : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing   (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing   (Index): 0
Total Blocks Empty            : 0
Total Blocks Marked Corrupt   : 1
Total Blocks Influx           : 0
Message 531 not found;  product=RDBMS; facility=BBED

-- 打印结构的详细字段
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        0x0140010c
   ub4 bas_kcbh                             @8        0x002ac591
   ub2 wrp_kcbh                             @12       0x0000
   ub1 seq_kcbh                             @14       0x05
   ub1 flg_kcbh                             @15       0x04 (KCBHFCKV)
   ub2 chkval_kcbh                          @16       0x86f0
   ub2 spare3_kcbh                          @18       0x0000



BBED> set offset 4
        OFFSET          4
-- dump命令可以将block 内容显示到屏幕。 
-- 每次显示的bytes由count 控制，默认是512 bytes。 使用 /v 选项，可以显示更多详细信息。
BBED> d /v count 4
 File: /u01/app/oracle/oradata/orcl/t1.dbf (0)
 Block: 269     Offsets:    4 to    7  Dba:0x00000000
-------------------------------------------------------
 b4014001                            l             --这个值是错误的，开始手工修改写错了，无需在意
 <16 bytes per line>

BBED> m /x 0d                                   --更改为后两位的正确值   其实就是0x0140010c改为0x0140010d
 File: /u01/app/oracle/oradata/orcl/t1.dbf (0)
 Block: 269              Offsets:    4 to    7           Dba:0x00000000
------------------------------------------------------------------------
 0d014001 

 <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        0x0140010d       --已经是正常的了
   ub4 bas_kcbh                             @8        0x002ac591
   ub2 wrp_kcbh                             @12       0x0000
   ub1 seq_kcbh                             @14       0x05
   ub1 flg_kcbh                             @15       0x04 (KCBHFCKV)
   ub2 chkval_kcbh                          @16       0x8648
   ub2 spare3_kcbh                          @18       0x0000

BBED> v
DBVERIFY - Verification starting
FILE = /u01/app/oracle/oradata/orcl/t1.dbf
BLOCK = 269

Block 269 is corrupt
Corrupt block relative dba: 0x0140010d (file 0, block 269)
Bad check value found during verification
Data in bad block:
 type: 6 format: 2 rdba: 0x0140010d  --正确的标头，但未提交仍然报错
 last change scn: 0x0000.002ac591 seq: 0x5 flg: 0x04
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0xc5910605
 check value in block header: 0x8648
 computed block checksum: 0xb9


DBVERIFY - Verification complete

Total Blocks Examined         : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing   (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing   (Index): 0
Total Blocks Empty            : 0
Total Blocks Marked Corrupt   : 1
Total Blocks Influx           : 0
Message 531 not found;  product=RDBMS; facility=BBED



BBED> sum
Check value for File 0, Block 269:
current = 0x8648, required = 0x86f1

BBED> sum apply
Check value for File 0, Block 269:
current = 0x86f1, required = 0x86f1

BBED> v
DBVERIFY - Verification starting
FILE = /u01/app/oracle/oradata/orcl/t1.dbf
BLOCK = 269
DBVERIFY - Verification complete
Total Blocks Examined         : 1
Total Blocks Processed (Data) : 1
Total Blocks Failing   (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing   (Index): 0
Total Blocks Empty            : 0
Total Blocks Marked Corrupt   : 0
Total Blocks Influx           : 0
Message 531 not found;  product=RDBMS; facility=BBED

-- 使用同让的方式继续修复135坏块：
BBED> set mode edit;
        MODE            Edit

BBED> set block 135;
        BLOCK#          135

BBED> show all;
        FILE#           0
        BLOCK#          135
        OFFSET          0
        DBA             0x00000000 (0 0,135)
        FILENAME        /u01/app/oracle/oradata/orcl/t1.dbf
        BIFILE          bifile.bbd
        LISTFILE       
        BLOCKSIZE       8192
        MODE            Edit
        EDIT            Unrecoverable
        IBASE           Dec
        OBASE           Dec
        WIDTH           80
        COUNT           512
        LOGFILE         log.bbd
        SPOOL           No

BBED> d
 File: /u01/app/oracle/oradata/orcl/t1.dbf (0)
 Block: 135              Offsets:    0 to  511           Dba:0x00000000
------------------------------------------------------------------------
 01105920 87004001 ece42b00 00000106 094a0000 01000800 ae200100 e7e42b00 
 0000e81f 021f3200 80004001 06001b00 83030000 9110c000 0b010300 02200000 
 ece42b00 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00010200 ffff1600 8c1f701f 701f0000 0200921f 8c1f0a00 00000a00 
 6200881f 701f581f 401f281f 101ff81e e01ec81e b01e681e 231edd1d 981d541d 
 111dc61c 7d1c361c f11bb11b 6e1b2d1b ee1aaa1a 701a2c1a ed19bc19 81194719 
 0d19ce18 8f185218 1418d517 95175717 2017e616 ac167316 2e16f715 b3157a15 
 3815f514 bc147414 2b14e913 a2135c13 1c13e212 a3126a12 2a12e911 a2116311 
 2511ef10 b0107110 3210fb0f bc0f850f 390fed0e a10e540e 1d0ed10d 850d390d 
 ec0cae0c 770c2b0c df0b930b 460b080b d10a850a 390aed09 a0096209 2509f308 
 bc087008 2408d807 8b074d07 1007de06 a7065b06 0f06c305 76059b00 030d0000 
 5d7b0200 dc4b4000 6c021400 026c0214 0602c107 02c10702 c1090180 19535550 
 504c454d 454e5441 4c5f4c4f 475f4441 54415f41 4c4c02c1 0202c109 0180ffff 
 0180ffff 02c16c02 140902c1 0802c108 02c10901 80185355 50504c45 4d454e54 
 414c5f4c 4f475f44 4154415f 464b02c1 0202c109 0180ffff 0180ffff 02c10804 
 c3022c25 03c2094a 02c10201 80018002 c1096c02 140902c1 0702c107 02c10901 

 <32 bytes per line>

BBED> copy block 134 to block 135
 File: /u01/app/oracle/oradata/orcl/t1.dbf (0)
 Block: 135              Offsets:    0 to  511           Dba:0x00000000
------------------------------------------------------------------------
 06a20000 86004001 e7e42b00 00000204 a6670000 01000000 ae200100 e7e42b00 
 00000000 02003200 80004001 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 ffff0e00 981f8a1f 8a1f0000 00000000 59f98000 5cf98000 
 06000000 601f0000 3c025802 74029002 ac02c802 e4020003 1c033803 54037003 
 8c03a803 c403e003 fc031804 34045004 6c048804 a404c004 dc04f804 14053005 
 4c056805 84059f05 ba05d505 f0050b06 26064106 5c067706 9206ad06 c806e306 
 fe061907 35075107 6d078907 a507c107 dd07f907 15083108 4d086908 8508a108 
 bd08d908 f5081109 2d094909 65098109 9d09b909 d509f109 0d0a290a 450a610a 
 7d0a990a b50ad10a ed0a090b 250b410b 5d0b790b 950bb10b cd0be90b 050c210c 
 3d0c590c 750c910c ad0cc90c e50c010d 1d0d390d 550d710d 8d0da90d c50de10d 
 fd0d190e 350e510e 6d0e890e a50ec10e dd0ef90e 150f310f 4d0f690f 850fa10f 
 bd0fd90f f50f1110 2d104910 65108110 9d10b910 d510f110 0d112911 45116111 
 7d119911 b511d111 ed110912 25124112 5d127912 9512b112 cd12e912 05132113 
 3d135913 75139113 ad13c913 e5130114 1d143914 55147114 8d14a914 c514e114 
 fd141915 35155115 6d158915 a515c115 dd15f915 15163116 4d166916 8516a116 

 <32 bytes per line>

BBED> show block
        BLOCK#          135

BBED> sum
Check value for File 0, Block 135:
current = 0x67a6, required = 0x67a6

BBED> sum apply
Check value for File 0, Block 135:
current = 0x67a6, required = 0x67a6

BBED> v
DBVERIFY - Verification starting
FILE = /u01/app/oracle/oradata/orcl/t1.dbf
BLOCK = 135

Block 135 is corrupt
Corrupt block relative dba: 0x01400087 (file 0, block 135)  --一样的问题，标头手工修改
Bad header found during verification
Data in bad block:
 type: 6 format: 2 rdba: 0x01400086
 last change scn: 0x0000.002be4e7 seq: 0x2 flg: 0x04
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0xe4e70602
 check value in block header: 0x67a6
 computed block checksum: 0x0


DBVERIFY - Verification complete

Total Blocks Examined         : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing   (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing   (Index): 0
Total Blocks Empty            : 0
Total Blocks Marked Corrupt   : 1
Total Blocks Influx           : 0
Message 531 not found;  product=RDBMS; facility=BBED


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        0x01400086
   ub4 bas_kcbh                             @8        0x002be4e7
   ub2 wrp_kcbh                             @12       0x0000
   ub1 seq_kcbh                             @14       0x02
   ub1 flg_kcbh                             @15       0x04 (KCBHFCKV)
   ub2 chkval_kcbh                          @16       0x67a6
   ub2 spare3_kcbh                          @18       0x0000

BBED> set offset 4
        OFFSET          4

BBED> d /v count 4
 File: /u01/app/oracle/oradata/orcl/t1.dbf (0)
 Block: 135     Offsets:    4 to    7  Dba:0x00000000
-------------------------------------------------------
 86004001                            l ..@.

 <16 bytes per line>

BBED> m /x 87  
 File: /u01/app/oracle/oradata/orcl/t1.dbf (0)
 Block: 135              Offsets:    4 to    7           Dba:0x00000000
------------------------------------------------------------------------
 87004001 

 <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        0x01400087
   ub4 bas_kcbh                             @8        0x002be4e7
   ub2 wrp_kcbh                             @12       0x0000
   ub1 seq_kcbh                             @14       0x02
   ub1 flg_kcbh                             @15       0x04 (KCBHFCKV)
   ub2 chkval_kcbh                          @16       0x67a6
   ub2 spare3_kcbh                          @18       0x0000

BBED> sum
Check value for File 0, Block 135:
current = 0x67a6, required = 0x67a7


BBED> sum apply
Check value for File 0, Block 135:
current = 0x67a7, required = 0x67a7

BBED> v
DBVERIFY - Verification starting
FILE = /u01/app/oracle/oradata/orcl/t1.dbf
BLOCK = 135
DBVERIFY - Verification complete
Total Blocks Examined         : 1
Total Blocks Processed (Data) : 1
Total Blocks Failing   (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing   (Index): 0
Total Blocks Empty            : 0
Total Blocks Marked Corrupt   : 0
Total Blocks Influx           : 0
Message 531 not found;  product=RDBMS; facility=BBED
BBED> exit
  • DBV验证
[oracle@testdb trace]$ dbv file='/u01/app/oracle/oradata/orcl/t1.dbf';    

DBVERIFY: Release 11.2.0.1.0 - Production on Thu Nov 26 15:02:37 2020

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/orcl/t1.dbf


DBVERIFY - Verification complete

Total Pages Examined         : 1792
Total Pages Processed (Data) : 1351
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 101
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 212
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 128
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 3184207 (0.3184207)
[oracle@testdb trace]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Nov 26 15:02:46 2020

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1580034340)
  • 备份验证
RMAN> backup datafile 5;

Starting backup at 26-NOV-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=33 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/t1.dbf
channel ORA_DISK_1: starting piece 1 at 26-NOV-20
channel ORA_DISK_1: finished piece 1 at 26-NOV-20
piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/1lvggegv_1_1 tag=TAG20201126T150255 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-NOV-20
茂材异等
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
BBED-32-64file.rar
03-25
BBED(Oracle Block Browerand EDitor Tool)，用来直接查看和修改数据文件数据的一个工具，是Oracle一款内部工具，可以直接修改Oracle数据文件块的内容，在一些极端恢复场景下比较有用。
RMAN-03009: failure of backup command on ORA_DISK_1 channel
congsikuai0611的博客
11-22 1588
最近Oracle出现了好多问题，这个问题暂时还没有解决，通过更换操作系统版本和数据库版本可以使用。从原来的x86-64更换为i386oracle版本是10.2操作系统：Red Hat Enterprise Linux AS re...
allocate处理free block报错RMAN-03009，ORA-1956
weixin_43299769的博客
11-25 675
故障描述 最近迁移中遇到一个free block 问题。模拟记录。 xtts迁移备份报错（测试环境数据）： RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ==============================================
rman-03009错误的一个原因
mituan1234567的专栏
12-20 1万+
备份文件可以自定义各种各样的格式，如下 %c 备份片的拷贝数 %d 数据库名称 %D 位于该月中的第几天 (DD) %M 位于该年中的第几月 (MM) %F 一个基于DBID 唯一的名称,这个格式的形式为c-IIIIIIIIII-YYYYMMDD-QQ, 其中IIIIIIIIII 为该数据库的DBID，YYYYMMDD 为日期，QQ 是一个1-256 的序 列 %n 数据库名称，向
RMAN备份：RMAN-03009 ORA-19809 ORA-19804
congfazun4983的博客
03-17 176
在Oracle10g中，不管是否启用FLASHBACK，但只要设置了db_recovery_file_dest和db_recovery_file_dest_size参数值，那么RMAN默认会将备份集存储db_recovery_f...
bad block表上坏块的处理
ckomuo086028的博客
11-11 431
今天一台数据库出现块块，日志文件如下：04:38:44 2009Corrupt Block Found TSN = 8, TSNAME = DEALSPACE RFN = 4, BLK = 393...
bbed-10g-src-x32.rar
05-24
32位的bbed安装包，
BLOG_Oracle_lhr_【BBED】BBED模拟并修复ORA-08102错误
08-09
BLOG_Oracle_lhr_【BBED】BBED模拟并修复ORA-08102错误BLOG_Oracle_lhr_【BBED】BBED模拟并修复ORA-08102错误
bbed64-10g,11g,12c,18c,19c,21c.zip
05-12
Oracle bbed 适用于10g,11g,12c,18c,19c,21c
oracle bbed for windows
10-15
之前找了很多，下载下来在win10上运行不了，总算找到可以运行在win10上的bbed了
bad block 坏块修复
u012232730的博客
12-21 8798
转自：http://blog.itpub.net/23135684/viewspace-732378/ 笔者认为不能简单的说物理硬盘的损坏导致块的物理损坏，Oracle bug导致块的逻辑损坏。这篇文章我们来详细讨论一下Oracle数据库的物理损坏以及逻辑损坏的概念。下面是一篇METALINK的文章： Physical and Logical Block Corruptio
记一次ORA-19506:文件同名
qq_40066204的博客
03-17 1005
描述 nbu联系到dba说备份一直报错 全备失败 这个是nbu那边的输出日志 released channel: ch00 released channel: ch01 released channel: ch02 released channel: ch03 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLL
NBU备份Oracle时报错ORA-19506，ORA-27028，ORA-19511的处理办法及技术点解析。
08-05 2562
今天同事处理一个NBU备份Oracle数据库的故障，简略的流程就是应用人员那边对数据库服务器的IP，及/etc/hosts文件进行了更改，然后第二天早上NBU备份数据库就失败。 1. 相关日志如下： 1.1...
关于javax.crypto.BadPaddingException: Blocktype异常的几种解决办法
热门推荐
在路上的专栏
03-28 2万+
转载请注明出处：http://blog.csdn.net/caoshichao520326/article/details/8731680 1.异常描述：最近做项目为了增强数据传输的安全性用到了RSA加密。即android客户端将要传送的信息，用私钥通过RSA非对称加密算法加密后，传到服务器端(PC端)。服务器端用对应(密钥)的公钥来解密时解密失败，抛出“javax.crypto.BadPadd
关于android端和java端的javax.crypto.BadPaddingException异常问题总结
Hank-Android
06-09 9885
关于javax.crypto.BadPaddingException: Blocktype异常的几种解决办法 转载请注明出处 1.异常描述：最近做项目为了增强数据传输的安全性用到了RSA加密。即android客户端将要传送的信息，用私钥通过RSA非对称加密算法加密后，传到服务器端(PC端)。服务器端用对应(密钥)的公钥来解密时解密失败，抛出“javax.crypto.BadPaddin
关于javax.crypto.BadPaddingException: Blocktype错误的几种解决方法
dodod2012的专栏
06-22 6007
此文章转载自：http://www.myexception.cn/mobile/1259076.html 关于javax.crypto.BadPaddingException: Blocktype异常的几种解决办法 1.异常描述：最近做项目为了增强数据传输的安全性用到了RSA加密。即android客户端将要传送的信息，用私钥通过RSA非对称加密算法加密后，传到服务器端(PC端)。服务器端用对应(密...
Linux操作系统中vi无法输入中文的原因， E35: No previous regular expression
weixin_50746407的博客
09-14 1万+
用一句话概括原因以及解决方法的话： 就是默认vi进去的是命令模式，你需要通过在键盘输入“i，a，o”随便一个英文进入编辑模式，然后按一下shift键切换为中文就行了。 （适用于不知道怎么切换中文，以及适用于看到输入的中文，按回车键却没有中文输入进去的情况） 1.首先我们在终端执行 ‘’vi test‘’命令时，默认打开test文件（若没有则会自动创建） 此处我已经在test文件里面编辑了一些内容了： 2.接着我们处于的是vi工作模式（一共有命令模式，编辑模式，命令项模式或底行模式.
windows oracle bbed
最新发布
09-25
BBED可以用于处理损坏的数据文件、恢复误删除的数据等。 Windows Oracle BBED结合了Windows操作系统、Oracle数据库和BBED工具的功能，提供了一个方便和强大的工具集。用户可以在Windows环境下使用BBED对Oracle...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值