BBED的一点使用

最新推荐文章于 2024-08-01 08:23:29 发布
最新推荐文章于 2024-08-01 08:23:29 发布
阅读量192 收藏
点赞数
文章标签： 数据库

BBED>
BBED>
BBED>
BBED> exit

[oracle@Moracle ~]$ bbed password =blockedit parfile=par.bbd

BBED: Release 2.0.0.0.0 - Limited Production on Sun Jul 4 09:40:41 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

************* !!! For Oracle Internal Use only !!! ***************

BBED>
BBED>
BBED>
BBED> set file 5
BBED-00205: illegal or out of range DBA (File 5, Block 1)


BBED> set file 4
FILE# 4

BBED> set file 7
BBED-00205: illegal or out of range DBA (File 7, Block 1)


BBED> exit

[oracle@Moracle ~]$ ls
10201_database_linux32.zip bbedpar.par database par.bbd yyyyyyyyy.lst
a.txt bifile.bbd log.bbd ttttttttttttttttttttttttttttt.lst
[oracle@Moracle ~]$ vi a.txt
1 /oradata/openlab/system01.dbf 503316480
2 /oradata/openlab/undotbs01.dbf 26214400
3 /oradata/openlab/sysaux01.dbf 251658240
4 /oradata/openlab/users01.dbf 5242880
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
1 /oradata/openlab/system01.dbf 503316480
2 /oradata/openlab/undotbs01.dbf 26214400
3 /oradata/openlab/sysaux01.dbf 251658240
"a.txt" 5L, 217C written
[oracle@Moracle ~]$
[oracle@Moracle ~]$
[oracle@Moracle ~]$
[oracle@Moracle ~]$ bbed password =blockedit parfile=par.bbd

BBED: Release 2.0.0.0.0 - Limited Production on Sun Jul 4 09:44:50 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

************* !!! For Oracle Internal Use only !!! ***************

BBED> set file 6
FILE# 6

BBED> set block 1
BLOCK# 1

BBED> dump
File: /oradata/openlab/user_tb01.dbf (6)
Block: 1 Offsets: 0 to 511 Dba:0x01800001
------------------------------------------------------------------------
0ba20000 01008001 00000000 00000104 603e0000 00000000 0001200a 67783143
4f50454e 4c414200 3d050000 00320000 00200000 06000300 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 688d0b00 00000000 4eab1b2b d3ba082b b8dd0800 00000000 00000000
00000000 00000000 00000400 0e000000 4b271f2b 0d000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 07000000 08005553 45525f54 42310000 00000000
00000000 00000000 00000000 00000000 06000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
acb9082b d2dc0800 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 44330d00 0000ffbf 4b271f2b 0100bc0c 12000000 02000000 10000000

<32 bytes per line>

BBED> modify /x 32 file 6 block 1 offset 46
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) Y
File: /oradata/openlab/user_tb01.dbf (6)
Block: 1 Offsets: 46 to 557 Dba:0x01800001
------------------------------------------------------------------------
32000020 00000600 03000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 0000688d 0b000000 00004eab
1b2bd3ba 082bb8dd 08000000 00000000 00000000 00000000 00000000 04000e00
00004b27 1f2b0d00 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000700
00000800 55534552 5f544231 00000000 00000000 00000000 00000000 00000000
00000600 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 0000acb9 082bd2dc 08000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00004433 0d000000 ffbf4b27
1f2b0100 bc0c1200 00000200 00001000 00000200 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

BBED> undo
BBED> modify /x 00 filename '/oradata/openlab/user_tb01.dbf' block 1. offset 46.
File: /oradata/openlab/user_tb01.dbf (6)
Block: 1 Offsets: 46 to 557 Dba:0x01800001
------------------------------------------------------------------------
00000020 00000600 03000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 0000688d 0b000000 00004eab
1b2bd3ba 082bb8dd 08000000 00000000 00000000 00000000 00000000 04000e00
00004b27 1f2b0d00 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000700
00000800 55534552 5f544231 00000000 00000000 00000000 00000000 00000000
00000600 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 0000acb9 082bd2dc 08000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00004433 0d000000 ffbf4b27
1f2b0100 bc0c1200 00000200 00001000 00000200 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>


BBED>
BBED>
BBED> modify /x 33 file 6 block 1 offset 45
File: /oradata/openlab/user_tb01.dbf (6)
Block: 1 Offsets: 45 to 556 Dba:0x01800001
------------------------------------------------------------------------
33000000 20000006 00030000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000068 8d0b0000 0000004e
ab1b2bd3 ba082bb8 dd080000 00000000 00000000 00000000 00000000 0004000e
0000004b 271f2b0d 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000007
00000008 00555345 525f5442 31000000 00000000 00000000 00000000 00000000
00000006 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 000000ac b9082bd2 dc080000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000044 330d0000 00ffbf4b
271f2b01 00bc0c12 00000002 00000010 00000002 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

BBED> set offet 0
BBED-00202: invalid parameter (offet)


BBED> set offset 0
OFFSET 0

BBED> dump
File: /oradata/openlab/user_tb01.dbf (6)
Block: 1 Offsets: 0 to 511 Dba:0x01800001
------------------------------------------------------------------------
0ba20000 01008001 00000000 00000104 603e0000 00000000 0001200a 67783143
4f50454e 4c414200 3d050000 00330000 00200000 06000300 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 688d0b00 00000000 4eab1b2b d3ba082b b8dd0800 00000000 00000000
00000000 00000000 00000400 0e000000 4b271f2b 0d000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 07000000 08005553 45525f54 42310000 00000000
00000000 00000000 00000000 00000000 06000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
acb9082b d2dc0800 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 44330d00 0000ffbf 4b271f2b 0100bc0c 12000000 02000000 10000000

<32 bytes per line>

BBED> help all
SET DBA [ dba | file#, block# ]
SET FILENAME 'filename'
SET FILE file#
SET BLOCK [+/-]block#
SET OFFSET [ [+/-]byte offset | symbol | *symbol ]
SET BLOCKSIZE bytes
SET LIST[FILE] 'filename'
SET WIDTH character_count
SET COUNT bytes_to_display
SET IBASE [ HEX | OCT | DEC ]
SET OBASE [ HEX | OCT | DEC ]
SET MODE [ BROWSE | EDIT ]
SET SPOOL [ Y | N ]
SHOW [ | ALL ]
INFO
MAP[/v] [ DBA | FILENAME | FILE | BLOCK ]
DUMP[/v] [ DBA | FILENAME | FILE | BLOCK | OFFSET | COUNT ]
PRINT[/x|d|u|o|c] [ DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]
EXAMINE[/Nuf] [ DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]
:
N - a number which specifies a repeat count.
u - a letter which specifies a unit size:
b - b1, ub1 (byte)
h - b2, ub2 (half-word)
w - b4, ub4(word)
r - Oracle table/index row
f - a letter which specifies a display format:
x - hexadecimal
d - decimal
u - unsigned decimal
o - octal
c - character (native)
n - Oracle number
t - Oracle date
i - Oracle rowid
FIND[/x|d|u|o|c] numeric/character string [ TOP | CURR ]
COPY [ DBA | FILE | FILENAME | BLOCK ] TO [ DBA | FILE | FILENAME | BLOCK ]
MODIFY[/x|d|u|o|c] numeric/character string
[ DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]
ASSIGN[/x|d|u|o] =
: [ DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]
: [ value | ]
SUM [ DBA | FILE | FILENAME | BLOCK ] [ APPLY ]
PUSH [ DBA | FILE | FILENAME | BLOCK | OFFSET ]
POP [ALL]
REVERT [ DBA | FILE | FILENAME | BLOCK ]
UNDO
HELP [ | ALL ]
VERIFY [ DBA | FILE | FILENAME | BLOCK ]
CORRUPT [ DBA | FILE | FILENAME | BLOCK ]

BBED> verify dba 6 block 1
BBED-00205: illegal or out of range DBA (File 0, Block 6)


BBED> verify dba 6,1
DBVERIFY - Verification starting
FILE = /oradata/openlab/user_tb01.dbf
BLOCK = 1

Block 1 is corrupt
Corrupt block relative dba: 0x01800001 (file 0, block 1)
Bad check value found during verification
Data in bad block:
type: 11 format: 2 rdba: 0x01800001
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00000b01
check value in block header: 0x3e60
computed block checksum: 0x100


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

BBED> help dum
BBED-00202: invalid parameter (dum)


BBED> help sum
SUM [ DBA | FILE | FILENAME | BLOCK ] [ APPLY ]

BBED> sum file 6 block 1
Check value for File 6, Block 1:
current = 0x3e60, required = 0x3f60

BBED> dump
File: /oradata/openlab/user_tb01.dbf (6)
Block: 1 Offsets: 0 to 511 Dba:0x01800001
------------------------------------------------------------------------
0ba20000 01008001 00000000 00000104 603e0000 00000000 0001200a 67783143
4f50454e 4c414200 3d050000 00330000 00200000 06000300 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 688d0b00 00000000 4eab1b2b d3ba082b b8dd0800 00000000 00000000
00000000 00000000 00000400 0e000000 4b271f2b 0d000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 07000000 08005553 45525f54 42310000 00000000
00000000 00000000 00000000 00000000 06000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
acb9082b d2dc0800 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 44330d00 0000ffbf 4b271f2b 0100bc0c 12000000 02000000 10000000

<32 bytes per line>

BBED> modify /x 3f file 6 block 1 offset 16
File: /oradata/openlab/user_tb01.dbf (6)
Block: 1 Offsets: 16 to 527 Dba:0x01800001
------------------------------------------------------------------------
3f3e0000 00000000 0001200a 67783143 4f50454e 4c414200 3d050000 00330000
00200000 06000300 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 688d0b00 00000000 4eab1b2b
d3ba082b b8dd0800 00000000 00000000 00000000 00000000 00000400 0e000000
4b271f2b 0d000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 07000000
08005553 45525f54 42310000 00000000 00000000 00000000 00000000 00000000
06000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 acb9082b d2dc0800 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 44330d00 0000ffbf 4b271f2b
0100bc0c 12000000 02000000 10000000 02000000 00000000 00000000 00000000

<32 bytes per line>

BBED> undo
BBED> modify /x 60 filename '/oradata/openlab/user_tb01.dbf' block 1. offset 16.
File: /oradata/openlab/user_tb01.dbf (6)
Block: 1 Offsets: 16 to 527 Dba:0x01800001
------------------------------------------------------------------------
603e0000 00000000 0001200a 67783143 4f50454e 4c414200 3d050000 00330000
00200000 06000300 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 688d0b00 00000000 4eab1b2b
d3ba082b b8dd0800 00000000 00000000 00000000 00000000 00000400 0e000000
4b271f2b 0d000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 07000000
08005553 45525f54 42310000 00000000 00000000 00000000 00000000 00000000
06000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 acb9082b d2dc0800 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 44330d00 0000ffbf 4b271f2b
0100bc0c 12000000 02000000 10000000 02000000 00000000 00000000 00000000

<32 bytes per line>


BBED> modify /x 3f file 6 block 1 offset 17
File: /oradata/openlab/user_tb01.dbf (6)
Block: 1 Offsets: 17 to 528 Dba:0x01800001
------------------------------------------------------------------------
3f000000 00000000 01200a67 7831434f 50454e4c 4142003d 05000000 33000000
20000006 00030000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000068 8d0b0000 0000004e ab1b2bd3
ba082bb8 dd080000 00000000 00000000 00000000 00000000 0004000e 0000004b
271f2b0d 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000007 00000008
00555345 525f5442 31000000 00000000 00000000 00000000 00000000 00000006
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 000000ac b9082bd2 dc080000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000044 330d0000 00ffbf4b 271f2b01
00bc0c12 00000002 00000010 00000002 00000000 00000000 00000000 00000000

<32 bytes per line>

BBED> set offset 0
OFFSET 0

BBED> dump
File: /oradata/openlab/user_tb01.dbf (6)
Block: 1 Offsets: 0 to 511 Dba:0x01800001
------------------------------------------------------------------------
0ba20000 01008001 00000000 00000104 603f0000 00000000 0001200a 67783143
4f50454e 4c414200 3d050000 00330000 00200000 06000300 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 688d0b00 00000000 4eab1b2b d3ba082b b8dd0800 00000000 00000000
00000000 00000000 00000400 0e000000 4b271f2b 0d000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 07000000 08005553 45525f54 42310000 00000000
00000000 00000000 00000000 00000000 06000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
acb9082b d2dc0800 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 44330d00 0000ffbf 4b271f2b 0100bc0c 12000000 02000000 10000000

<32 bytes per line>

BBED> sum file 6 block 1 apply
Check value for File 6, Block 1:
current = 0x3f60, required = 0x3f60

BBED>
BBED>
BBED>
BBED>
BBED>

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8432937/viewspace-1043020/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8432937/viewspace-1043020/

clg10015
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
bbed使用.docx
07-07
**bbed工具详解** 在Oracle数据库管理中，`bbed`是一个非常实用的工具，主要用于...请注意，直接修改数据库文件可能对数据造成不可逆的破坏，因此在使用`bbed`时务必谨慎，并确保在进行任何操作前有完整的数据库备份。
BBED 使用手册
07-10
BBED 使用手册 BBED（Block EDitor）是 Oracle 提供的块编辑器，借助 BBED，可以帮助我们更好地理解 Oracle 的 Block 结构。BBED 使用手册详细介绍了 BBED 的使用，非常适合初学者学习。下面是 BBED 的详细使用介绍...
oracle12c 修改scn值,Oracle 12c SCN推进方法汇总（三）之BBED
weixin_42500454的博客
04-08 159
查看当前SCN约1000W将数据文件加入bbed filelistSQL> select current_scn from v$database;CURRENT_SCN-----------10108366SQL> select file#,name from v$datafile;FILE# NAME---------- -------------------------------...
BBED的安装及简单的使用方法
还不算晕的专栏
11-21 4784
记录下BBED的安装--ORACLE 11.2.0.4下 1.在ORACLE 11G下安装BBED，需要从ORACLE 10G中复制三个包 bbedus.msb               sbbdpt.o                 ssbbded.o   下载地址：32位 http://download.csdn.net/detail/q947817003/6587001  64
[20161031]rman备份与数据文件OS块.txt
10-31 64
[20161031]rman备份与数据文件OS块.txt --每个数据文件都有一个OS块，位于数据文件的第1块(也是0块).通过bbed无法访问： BBED> set dba 7,0 BBED-00205: ill...
oracle12c 修改scn值6,Oracle 12c SCN推进方法汇总（三）之BBED
weixin_39834084的博客
04-04 96
1，查看当前SCN约1000W将数据文件加入bbed filelistSQL>selectcurrent_scnfromv$database;CURRENT_SCN-----------10108366SQL>selectfile#,namefromv$datafile;FILE#NAME---------------------------------------...
[20160325]bbed是否有4G的限制.txt
03-25 60
[20160325]bbed是否有4G的限制.txt http://www.itpub.net/thread-2053982-1-1.html --前一段时间，我想使用bbed查看某个块的信息，我发现如果我访问的操作在4G之...
oracle bbed 使用,Oracle bbed 五个 实用示例
weixin_42364609的博客
04-15 310
0206d773 l ..×s<16 bytes per line>这里已经出现了我们3c(deleted)标志，但是注意这里的位置的根据我们的查找的字符串来分的，实际在block里的分割方式不一样按照我们的offset 来进行。 我们可以通过row directory 来进行一个确认。我们print row directory 确...
BBED的详细说明
白非马的博客
05-02 5567
一. BBED介绍 “` Thename bbed is an acronym for Block Browser and EDitor and it is shipped with thedatabase. It is intended for Oracle internal use only and the company neverpublishes any details...
在Windows上使用Oracle BBED工具
Data & Analysis
09-04 2093
在Windows上使用Oracle BBED工具 2013/06/26 BY MACLEAN LIU LEAVE A COMMENT 最近，我不得不在Windows2008 R2环境中使用BBED（在数据文件头中修改检查点SCN）。要做到这一点，我喜欢用BBED。但是这一次，是在11.2数据库中在Windows2008 R2服务器上。 2个问题: – 9版本以后Oracle不装载BBED了...
BBED
LinusFay
04-15 1231
BBED是Oracle提供的块编辑器，借助BBED，可以帮助我们更好的理解Oracle的Block的结构。 当然，反过来说，也只有更加理解块的结构，才能更好的利用BBED完成某些特殊情况下的灾难恢复。、 Oracle Data Block的结构简图如下，其中从Data header到Row Data部分合称Data Layer: --------------------- - Cac...
BBED安装包
03-18
在使用BBED时，必须非常谨慎，遵循最佳实践，并确保有完整的数据库备份，以防万一。 在提供的压缩包文件中，"BBED_10g_源码 x64"表明这包含的是BBED在Oracle 10g版本的源代码，且适用于64位操作系统。源码的提供...
BBED使用手册
11-20
BBED(Oracle Block Browerand EDitor Tool)，用来直接查看和修改数据文件数据的一个工具，是Oracle一款内部工具，可以直接修改Oracle数据文件块的内容，在一些极端恢复场景下比较有用。
linux bbed
02-09
标题提到的"linux bbed"意味着我们要讨论的是如何在Linux环境下使用`bbed`来迁移10g版本的Oracle数据库到11g版本，并在11g中进行数据恢复。`bbed`全称为Block-Based Editor，它允许管理员直接对数据库的数据块进行读...
简单的 mongoDB 学习
qq_19342829的博客
07-31 442
mongodb入门学习整理
社区养老服务小程序的设计
Karen198的博客
07-31 389
管理员账户功能包括：系统首页，个人中心，用户管理，服务人员管理，服务产品管理，服务预约管理，服务状态管理，服务退订管理，活动管理，视频管理。主要技术：Java,Spring,mybatis,mysql,jquery,html。服务器：SpringBoot自带 apache tomcat。微信端账号功能包括：系统首页，服务产品，活动，视频，我的。JDK版本：Java JDK1.8。数据库可视化工具： navicat。数据库版本： mysql5.7。开发工具：IDEA(推荐)开发系统：Windows。
MySQL备份与恢复
最新发布
m0_74860678的博客
08-01 283
在生产环境中，数据的安全性至关重要任何数据的丢失都可能产生严重的后果造成数据丢失的原因程序错误人为操作错误运算错误磁盘故障灾难（如火灾、地震）和盗窃# 开启二进制日志功能[mysqld]# 重启服务# 有 mysql-bin.000001 就代表成功。
"BBED 使用手册：深入了解 Oracle 块编辑器的使用教程
在使用 BBED 之前，我们需要设置当前编辑或浏览的数据块地址。通过使用命令"set dba"，可以设置当前操作的数据块的地址。例如，要选择编号为4的数据文件的第16个数据块，可以输入"set dba 4,16"。这样，我们就可以在...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值