BBED的一点使用

最新推荐文章于 2024-11-13 22:17:16 发布
最新推荐文章于 2024-11-13 22:17:16 发布
阅读量214 收藏
点赞数
文章标签： 数据库

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
关注
Oracle BBED 简单使用手册
LuciferLiu_DBA
09-13 2437
每天一个 DBA 小知识，助你更进一步！
oracle12c 修改scn值,Oracle 12c SCN推进方法汇总（三）之BBED
weixin_42500454的博客
04-08 179
查看当前SCN约1000W将数据文件加入bbed filelistSQL> select current_scn from v$database;CURRENT_SCN-----------10108366SQL> select file#,name from v$datafile;FILE# NAME---------- -------------------------------...
BBED的安装及简单的使用方法
还不算晕的专栏
11-21 4813
记录下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 81
[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 111
1，查看当前SCN约1000W将数据文件加入bbed filelistSQL>selectcurrent_scnfromv$database;CURRENT_SCN-----------10108366SQL>selectfile#,namefromv$datafile;FILE#NAME---------------------------------------...
[20160325]bbed是否有4G的限制.txt
03-25 76
[20160325]bbed是否有4G的限制.txt http://www.itpub.net/thread-2053982-1-1.html --前一段时间，我想使用bbed查看某个块的信息，我发现如果我访问的操作在4G之...
oracle bbed 使用,Oracle bbed 五个 实用示例
weixin_42364609的博客
04-15 337
0206d773 l ..×s<16 bytes per line>这里已经出现了我们3c(deleted)标志，但是注意这里的位置的根据我们的查找的字符串来分的，实际在block里的分割方式不一样按照我们的offset 来进行。 我们可以通过row directory 来进行一个确认。我们print row directory 确...
BBED的详细说明
白非马的博客
05-02 5707
一. 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 2156
在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 1273
BBED是Oracle提供的块编辑器，借助BBED，可以帮助我们更好的理解Oracle的Block的结构。 当然，反过来说，也只有更加理解块的结构，才能更好的利用BBED完成某些特殊情况下的灾难恢复。、 Oracle Data Block的结构简图如下，其中从Data header到Row Data部分合称Data Layer: --------------------- - Cac...
bbed使用.docx
07-07
**bbed工具详解** 在Oracle数据库管理中，`bbed`是一个非常实用的工具，主要用于...请注意，直接修改数据库文件可能对数据造成不可逆的破坏，因此在使用`bbed`时务必谨慎，并确保在进行任何操作前有完整的数据库备份。
Oracle 11g下编译使用BBED的方法教程
09-09
首先，为了在Oracle 11g中使用BBED，你需要确保系统中缺少的文件已正确地从10g版本复制到相应的位置。这些文件包括： 1. `$ORACLE_HOME/rdbms/lib/sbbdpt.o` 2. `$ORACLE_HOME/rdbms/lib/ssbbded.o` 3. `$ORACLE_...
第3课-BBED工具命令使用.docx
08-29
在Oracle数据库管理中，BBED（Block Buffer...但要注意，由于BBED涉及直接操作数据库底层，因此使用时需谨慎，避免对生产环境造成不可逆的影响。熟悉并掌握这些命令，能让你在面对复杂数据库问题时，拥有更多解决手段。
BBED 使用手册
07-10
BBED 使用手册 BBED（Block EDitor）是 Oracle 提供的块编辑器，借助 BBED，可以帮助我们更好地理解 Oracle 的 Block 结构。BBED 使用手册详细介绍了 BBED 的使用，非常适合初学者学习。下面是 BBED 的详细使用介绍...
07 Oracle数据库恢复基础解析：从检查点到归档，一步步构建数据安全防线
超哥的博客
11-09 1300
检查点是Oracle数据库中的一个特殊事件，它的作用是将内存中的数据块同步到磁盘上，以确保数据的持久性。简单来说，就是让数据库“记住”到目前为止所有的更改。Redo日志是Oracle用来记录所有数据更改的日志文件。每次对数据库进行修改时，都会先写入Redo日志，然后再写入数据文件。这样，即使系统崩溃，也能通过Redo日志恢复数据。当数据库运行在归档模式下时，一旦当前的Redo日志文件满，Oracle会将其复制到一个安全的存储位置，并标记为已归档。这样可以长期保留Redo日志，便于历史数据的恢复。
Redis - 事务
ketil27的博客
11-08 964
Redis 的事务和MySQL的事务概念上是类似的.都是把⼀系列操作绑定成⼀组.让这⼀组能够批量执 ⾏.弱化的原⼦性:redis没有"回滚机制".只能做到这些操作"批量执⾏".不能做到"⼀个失败就恢复到 初始状态".不保证⼀致性:不涉及"约束". 也没有回滚.MySQL的⼀致性体现的是运⾏事务前和运⾏后,结果都 是合理有效的,不会出现中间⾮法状态.不需要隔离性:也没有隔离级别,因为不会并发执⾏事务(redis单线程处理请求).
云数据库和云服务器哪个便宜一些？
petaexpress的博客
11-12 387
云服务器的价格区间相对更广泛，因为用户可以根据实际需求选择不同配置和性能的服务器。而云数据库的价格则更多地依赖于数据库类型和规格。在相同配置下，云服务器的价格可能会略低于云数据库，但这并不是绝对的，因为两者都有不同的优惠政策和计费方式。
约束（MYSQL）
最新发布
2301_80363309的博客
11-13 197
not null（非空） unique（唯一） default（默认约束，规定值） 主键约束primary key（非空且唯一） auto_increment（自增类型） 复合主键 check（保证列中值符合指定条件） foreign key（外键约束）
gbase8s数据库常见的连接算法
wangyx01的博客
11-13 175
外表指针指向第一条数据，内表指针顺序移动，找到和外表匹配项，记录，内表循环结束后外边指针继续向下移动，一直到外表循环结束为止。hash 连接中只有极少量的随机读，大部分都为顺序读，极大缓解了大量随机读的压力。有则取捅中进行匹配（若捅中有多条数据则发生hash碰撞），没有则继续匹配下一。hash 连接避免了嵌套循环的大量的随机读，简单伪代码如下。在gbase8s 中 ，常见的连接算法主要分为如下几种。细分可分为索引嵌套循环，块嵌套循环，半嵌套循环等。嵌套循环的缺点，在大量数据下会发生大量的随机读。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值