BBED修改数据文件的SCN

最新推荐文章于 2023-07-26 10:10:27 发布
最新推荐文章于 2023-07-26 10:10:27 发布
阅读量280 收藏
点赞数
文章标签： 数据库
BBED修改数据文件的SCN


1.编译BBED

make: *** No rule to make target `ins_rdbms.mk'. Stop.
[oracle@linux2 oracle]$ cd $ORACLE_HOME/rdbms/lib
[oracle@linux2 lib]$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed

Linking BBED utility (bbed)
rm -f /oracle/ora9/product/92/rdbms/lib/bbed
gcc -o /oracle/ora9/product/92/rdbms/lib/bbed -L/oracle/ora9/product/92/rdbms/lib/ -L/oracle/ora9/product/92/lib/ -L/oracle/ora9/product/92/lib/stubs/ /oracle/ora9/product/92/lib/s0main.o /oracle/ora9/product/92/rdbms/lib/ssbbded.o /oracle/ora9/product/92/rdbms/lib/sbbdpt.o `cat /oracle/ora9/product/92/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 /oracle/ora9/product/92/rdbms/lib/defopt.o -ldbtools9 -lclntsh `cat /oracle/ora9/product/92/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /oracle/ora9/product/92/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lclient9 -lvsn9 -lwtc9 -lcommon9 -lgeneric9 -lwtc9 -lmm -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `cat /oracle/ora9/product/92/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /oracle/ora9/product/92/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lclient9 -lvsn9 -lwtc9 -lcommon9 -lgeneric9 -ltrace9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 -lclient9 -lvsn9 -lwtc9 -lcommon9 -lgeneric9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `cat /oracle/ora9/product/92/lib/sysliblist` -Wl,-rpath,/oracle/ora9/product/92/lib:/lib:/usr/lib -lm `cat /oracle/ora9/product/92/lib/sysliblist` -ldl -lm

这里的密码默认是blockedit
[oracle@linux2 lib]$ ./bbed
Password:

BBED: Release 2.0.0.0.0 - Limited Production on Wed May 9 13:19:23 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

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

BBED> exit

2. Data file headers

alter session set events 'immediate trace name FILE_HDRS level 10';

[oracle@linux2 udump]$ cat ora9i2_ora_3374.trc
/oracle/ora9/admin/ora9i/udump/ora9i2_ora_3374.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /oracle/ora9/product/92
System name: Linux
Node name: linux2
Release: 2.4.21-40.EL
Version: #1 Thu Feb 2 22:32:00 EST 2006
Machine: i686
Instance name: ora9i2
Redo thread mounted by this instance: 2
Oracle process number: 15
Unix process pid: 3374, image: oracle@linux2 (TNS V1-V3)

*** SESSION ID:(16.3) 2007-05-09 16:30:36.931
CMCLI WARNING: CMInitContext: init ctx(0xc8830c8)
*** 2007-05-09 17:23:35.040
DUMP OF DATA FILES: 6 files in database

DATA FILE #1:
(name #3) /dev/raw/raw4
creation size=51200 block size=8192 status=0xe head=3 tail=3 dup=1
tablespace 0, index=1 krfil=1 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:266 scn: 0x0000.000de710 05/09/2007 17:07:49
Stop scn: 0xffff.ffffffff 05/09/2007 15:07:30
Creation Checkpointed at scn: 0x0000.00000007 04/10/2007 13:52:09
thread:1 rba:(0x1.3.10)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.000ced7f prev_range: 0
Online Checkpointed at scn: 0x0000.000ced80 05/08/2007 14:00:21
thread:1 rba:(0x1.2.0)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=134217728=0x8000000
Db ID=2419156282=0x9031653a, Db Name='ORA9I'
Activation ID=0=0x0
Control Seq=2389=0x955, File size=51200=0xc800
File Number=1, Blksiz=8192, File Type=3 DATA
Tablespace #0 - SYSTEM rel_fn:1
Creation at scn: 0x0000.00000007 04/10/2007 13:52:09
Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0
reset logs count:0x2513a375 scn: 0x0000.000ced80 recovered at 05/09/2007 13:54:48
status:0x4 root dba:0x004001a1 chkpt cnt: 266 ctl cnt:265
begin-hot-backup file size: 0
Checkpointed at scn: 0x0000.000de710 05/09/2007 17:07:49
thread:2 rba:(0x2.53b.10)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Backup Checkpointed at scn: 0x0000.00000000
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
External cache id: 0x0 0x0 0x0 0x0
Absolute fuzzy scn: 0x0000.00000000
Recovery fuzzy scn: 0x0000.00000000 01/01/1988 00:00:00
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00

DATA FILE #2:
(name #4) /dev/raw/raw2
creation size=38400 block size=8192 status=0xe head=4 tail=4 dup=1
tablespace 1, index=2 krfil=2 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:266 scn: 0x0000.000de710 05/09/2007 17:07:49
Stop scn: 0xffff.ffffffff 05/09/2007 15:07:30
Creation Checkpointed at scn: 0x0000.00001356 04/10/2007 13:52:36
thread:1 rba:(0x1.4407.10)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.000ced7f prev_range: 0
Online Checkpointed at scn: 0x0000.000ced80 05/08/2007 14:00:21
thread:1 rba:(0x1.2.0)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=134217728=0x8000000
Db ID=2419156282=0x9031653a, Db Name='ORA9I'
Activation ID=0=0x0
Control Seq=2389=0x955, File size=38400=0x9600
File Number=2, Blksiz=8192, File Type=3 DATA
Tablespace #1 - UNDOTBS1 rel_fn:2
Creation at scn: 0x0000.00001356 04/10/2007 13:52:36
Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0
reset logs count:0x2513a375 scn: 0x0000.000ced80 recovered at 05/09/2007 13:54:48
status:0x4 root dba:0x00000000 chkpt cnt: 266 ctl cnt:265
begin-hot-backup file size: 0
Checkpointed at scn: 0x0000.000de710 05/09/2007 17:07:49
thread:2 rba:(0x2.53b.10)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Backup Checkpointed at scn: 0x0000.00000000
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
External cache id: 0x0 0x0 0x0 0x0
Absolute fuzzy scn: 0x0000.00000000
Recovery fuzzy scn: 0x0000.00000000 01/01/1988 00:00:00
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00

DATA FILE #3:
(name #6) /dev/raw/raw7
creation size=12800 block size=8192 status=0xe head=6 tail=6 dup=1
tablespace 3, index=4 krfil=3 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:263 scn: 0x0000.000de710 05/09/2007 17:07:49
Stop scn: 0xffff.ffffffff 05/09/2007 15:07:30
Creation Checkpointed at scn: 0x0000.00001928 04/10/2007 13:52:51
thread:1 rba:(0x2.6b9.10)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.000ced7f prev_range: 0
Online Checkpointed at scn: 0x0000.000ced80 05/08/2007 14:00:21
thread:1 rba:(0x1.2.0)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=134217728=0x8000000
Db ID=2419156282=0x9031653a, Db Name='ORA9I'
Activation ID=0=0x0
Control Seq=2389=0x955, File size=12800=0x3200
File Number=3, Blksiz=8192, File Type=3 DATA
Tablespace #3 - INDX rel_fn:3
Creation at scn: 0x0000.00001928 04/10/2007 13:52:51
Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0
reset logs count:0x2513a375 scn: 0x0000.000ced80 recovered at 05/09/2007 13:54:48
status:0x4 root dba:0x00000000 chkpt cnt: 263 ctl cnt:262
begin-hot-backup file size: 0
Checkpointed at scn: 0x0000.000de710 05/09/2007 17:07:49
thread:2 rba:(0x2.53b.10)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Backup Checkpointed at scn: 0x0000.00000000
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
External cache id: 0x0 0x0 0x0 0x0
Absolute fuzzy scn: 0x0000.00000000
Recovery fuzzy scn: 0x0000.00000000 01/01/1988 00:00:00
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00

DATA FILE #4:
(name #7) /dev/raw/raw3
creation size=38400 block size=8192 status=0xe head=7 tail=7 dup=1
tablespace 4, index=5 krfil=4 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:264 scn: 0x0000.000de710 05/09/2007 17:07:49
Stop scn: 0xffff.ffffffff 05/09/2007 15:07:30
Creation Checkpointed at scn: 0x0000.0000193d 04/10/2007 13:52:59
thread:1 rba:(0x2.6cd.10)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.000ced7f prev_range: 0
Online Checkpointed at scn: 0x0000.000ced80 05/08/2007 14:00:21
thread:1 rba:(0x1.2.0)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=134217728=0x8000000
Db ID=2419156282=0x9031653a, Db Name='ORA9I'
Activation ID=0=0x0
Control Seq=2389=0x955, File size=38400=0x9600
File Number=4, Blksiz=8192, File Type=3 DATA
Tablespace #4 - UNDOTBS2 rel_fn:4
Creation at scn: 0x0000.0000193d 04/10/2007 13:52:59
Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0
reset logs count:0x2513a375 scn: 0x0000.000ced80 recovered at 05/09/2007 13:54:48
status:0x4 root dba:0x00000000 chkpt cnt: 264 ctl cnt:263
begin-hot-backup file size: 0
Checkpointed at scn: 0x0000.000de710 05/09/2007 17:07:49
thread:2 rba:(0x2.53b.10)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Backup Checkpointed at scn: 0x0000.00000000
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
External cache id: 0x0 0x0 0x0 0x0
Absolute fuzzy scn: 0x0000.00000000
Recovery fuzzy scn: 0x0000.00000000 01/01/1988 00:00:00
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00

DATA FILE #5:
(name #12) /ocfs01/undotab3.dbf
creation size=38400 block size=8192 status=0xe head=12 tail=12 dup=1
tablespace 6, index=6 krfil=5 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:214 scn: 0x0000.000de710 05/09/2007 17:07:49
Stop scn: 0xffff.ffffffff 05/09/2007 15:07:30
Creation Checkpointed at scn: 0x0000.00037b9b 04/19/2007 10:08:20
thread:2 rba:(0xb.2a2.10)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.000ced7f prev_range: 0
Online Checkpointed at scn: 0x0000.000ced80 05/08/2007 14:00:21
thread:1 rba:(0x1.2.0)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=134217728=0x8000000
Db ID=2419156282=0x9031653a, Db Name='ORA9I'
Activation ID=0=0x0
Control Seq=2389=0x955, File size=38400=0x9600
File Number=5, Blksiz=8192, File Type=3 DATA
Tablespace #6 - UNDOTBS3 rel_fn:5
Creation at scn: 0x0000.00037b9b 04/19/2007 10:08:20
Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0
reset logs count:0x2513a375 scn: 0x0000.000ced80 recovered at 05/09/2007 13:54:48
status:0x4 root dba:0x00000000 chkpt cnt: 214 ctl cnt:213
begin-hot-backup file size: 0
Checkpointed at scn: 0x0000.000de710 05/09/2007 17:07:49
thread:2 rba:(0x2.53b.10)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Backup Checkpointed at scn: 0x0000.00000000
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
External cache id: 0x0 0x0 0x0 0x0
Absolute fuzzy scn: 0x0000.00000000
Recovery fuzzy scn: 0x0000.00000000 01/01/1988 00:00:00
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00

DATA FILE #6:
(name #11) /ocfs01/a1.ora
creation size=128 block size=8192 status=0xe head=11 tail=11 dup=1
tablespace 7, index=7 krfil=6 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:6 scn: 0x0000.000de710 05/09/2007 17:07:49
Stop scn: 0xffff.ffffffff 05/09/2007 15:07:30
Creation Checkpointed at scn: 0x0000.000d8fc1 05/09/2007 13:58:21
thread:2 rba:(0x2.81.10)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.00000000 prev_range: 0
Online Checkpointed at scn: 0x0000.00000000
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=134217728=0x8000000
Db ID=2419156282=0x9031653a, Db Name='ORA9I'
Activation ID=0=0x0
Control Seq=2389=0x955, File size=128=0x80
File Number=6, Blksiz=8192, File Type=3 DATA
Tablespace #7 - A1 rel_fn:6
Creation at scn: 0x0000.000d8fc1 05/09/2007 13:58:21
Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0
reset logs count:0x2513a375 scn: 0x0000.000ced80 recovered at 01/01/1988 00:00:00
status:0x4 root dba:0x00000000 chkpt cnt: 6 ctl cnt:5
begin-hot-backup file size: 0
Checkpointed at scn: 0x0000.000de710 05/09/2007 17:07:49
thread:2 rba:(0x2.53b.10)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Backup Checkpointed at scn: 0x0000.00000000
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
External cache id: 0x0 0x0 0x0 0x0
Absolute fuzzy scn: 0x0000.00000000
Recovery fuzzy scn: 0x0000.00000000 01/01/1988 00:00:00
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
DUMP OF TEMP FILES: 1 files in database

TEMP FILE #1: External File #201
creation size=32000 block size=8192 status=0xe head=0 tail=0 dup=0
tablespace 2, index=3 krfil=1 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00

可以看到数据文件 DATA FILE #6: /ocfs01/a1.ora的SCN:

Checkpointed at scn: 0x0000.000de710 05/09/2007 17:07:49

在FILE #6中用BBED搜索该scn:000de710.

数据文件头在数据文件的第一个BLOCK里.

BBED> show
FILE# 6
BLOCK# 1
OFFSET 112
DBA 0x01800001 (25165825 6,1)
FILENAME /ocfs01/a1.ora
BIFILE bifile.bbd
LISTFILE a.txt
BLOCKSIZE 8192
MODE Edit
EDIT Unrecoverable
IBASE Dec
OBASE Dec
WIDTH 80
COUNT 512
LOGFILE log.bbd
SPOOL No

BBED> find /x 10e70d00 top
File: /ocfs01/a1.ora (6)
Block: 1 Offsets: 140 to 651 Dba:0x01800001
------------------------------------------------------------------------
10e70d00 0000ffbf e5201525 02000000 02000000 3b050000 10000000 06000000
00000000 06000000 00000000 05000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 07000000 02004131 00000000 00000000 00000000 00000000
00000000 00000000 00000000 06000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

BBED> modify /x 000de710 file 6 block 1 offset 140
File: /ocfs01/a1.ora (6)
Block: 1 Offsets: 140 to 651 Dba:0x01800001
------------------------------------------------------------------------
000de710 0000ffbf e5201525 02000000 02000000 3b050000 10000000 06000000
00000000 06000000 00000000 05000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 07000000 02004131 00000000 00000000 00000000 00000000
00000000 00000000 00000000 06000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

BBED> dump file 6 block 1 offset 140
File: /ocfs01/a1.ora (6)
Block: 1 Offsets: 140 to 651 Dba:0x01800001
------------------------------------------------------------------------
000de710 0000ffbf e5201525 02000000 02000000 3b050000 10000000 06000000
00000000 06000000 00000000 05000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 07000000 02004131 00000000 00000000 00000000 00000000
00000000 00000000 00000000 06000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

再dump文件头,可以看到/ocfs01/a1.ora的SCN已经更改了.

Checkpointed at scn: 0x0000.10e70d00 05/09/2007 17:07:49


DATA FILE #6:
(name #11) /ocfs01/a1.ora
creation size=128 block size=8192 status=0xe head=11 tail=11 dup=1
tablespace 7, index=7 krfil=6 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:6 scn: 0x0000.000de710 05/09/2007 17:07:49
Stop scn: 0xffff.ffffffff 05/09/2007 15:07:30
Creation Checkpointed at scn: 0x0000.000d8fc1 05/09/2007 13:58:21
thread:2 rba:(0x2.81.10)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.00000000 prev_range: 0
Online Checkpointed at scn: 0x0000.00000000
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=134217728=0x8000000
Db ID=2419156282=0x9031653a, Db Name='ORA9I'
Activation ID=0=0x0
Control Seq=2389=0x955, File size=128=0x80
File Number=6, Blksiz=8192, File Type=3 DATA
Tablespace #7 - A1 rel_fn:6
Creation at scn: 0x0000.000d8fc1 05/09/2007 13:58:21
Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0
reset logs count:0x2513a375 scn: 0x0000.000ced80 recovered at 01/01/1988 00:00:00
status:0x4 root dba:0x00000000 chkpt cnt: 6 ctl cnt:5
begin-hot-backup file size: 0
Checkpointed at scn: 0x0000.10e70d00 05/09/2007 17:07:49
thread:2 rba:(0x2.53b.10)
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Backup Checkpointed at scn: 0x0000.00000000
thread:0 rba:(0x0.0.0)
enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
External cache id: 0x0 0x0 0x0 0x0
Absolute fuzzy scn: 0x0000.00000000
Recovery fuzzy scn: 0x0000.00000000 01/01/1988 00:00:00
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
DUMP OF TEMP FILES: 1 files in database

TEMP FILE #1: External File #201
creation size=32000 block size=8192 status=0xe head=0 tail=0 dup=0
tablespace 2, index=3 krfil=1 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00

SQL> select name,checkpoint_change# from v$datafile_header;

NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/dev/raw/raw4
911120

/dev/raw/raw2
911120

/dev/raw/raw7
911120


NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/dev/raw/raw3
911120

/ocfs01/undotab3.dbf
911120

/ocfs01/a1.ora
283577600


6 rows selected.

验证该block

BBED> verify
DBVERIFY - Verification starting
FILE = /ocfs01/a1.ora
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
consistency value in tail: 0x00000b01
check value in block header: 0xe603, computed block checksum: 0xfafa
spare1: 0x0, spare2: 0x0, spare3: 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

可以看到该BLOCK已经 Corrupt ,修复 该BLOCK

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

BBED> verify
DBVERIFY - Verification starting
FILE = /ocfs01/a1.ora
BLOCK = 1


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 : 0
Total Blocks Influx : 0

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

转载于:http://blog.itpub.net/51726/viewspace-65969/

cuishiping6190
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
bbed Oracle数据修复工具
04-06
这个工具允许用户直接操作Oracle数据文件（.dbf）中的数据块，进行读取、修改和写入操作。bbed的强大之处在于，它能帮助管理员对数据库进行低级别修复，尤其是在传统的备份和恢复方法无法解决问题时，bbed往往能成为...
文件的读写基本操作
热门推荐
范高伦的博客
09-07 1万+
一、文件是计算机中数据持久化存储的表现形式 读写文件标准操作格式1： 1、打开文件：file1 = open('文件名','读写模式') 2、操作文件 3、关闭文件：file1.close() 文件操作完毕后必须关闭，否则长期保持对文件的连接状态，造成内存溢出的现象发生 读写文件操作格式2： # 1、打开文件 file1 = open('demo.txt','w') # 2、操作文件 file1.write('hello world') # 3、关闭文件 file1.close() 1、打开文件：wi
bbed-修改数据文件scn
renyanjie123的博客
03-24 1316
bbed修改数据文件scn分为两种，online数据文件和offline数据文件，当然都是修改scnbase 和rbaseq，offline下还要多修改rbabno和kcvcptim。 一、bbed修改offine数据文件scn 1、准备环境 [oracle@renCAP ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Jun 19 19:09:21 2019 Copyright (c) 1982, 2
误删数据文件后，使用bbed修改数据文件头，启动数据库
满纸荒唐言
07-03 1331
最近遇到一个问题:本应该在页面上操作删除分区，但是有人直接关闭数据库，删除分区所属表空间的数据文件，导致数据库无法启动,报下面错： SYS >startup; ORA-01157: 无法标识/锁定数据文件 31 - 请参阅 DBWR 跟踪文件 ORA-01110: 数据文件 31: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLJJYF2\TA\SIM2
复现一个朋友的“三无”情况数据库恢复案例-BBED修改数据文件SCN
qq_22960681的博客
07-26 133
oracle极端故障恢复 BBED修复
【kingsql分享】使用BBED修改Oracle数据文件头推进SCN
cuishitan3439的博客
11-26 337
【kingsql分享】使用BBED修改Oracle数据文件头推进SCN 请看报大错： SQL> startup; ORACLE instance started. ...
oracle bbed数据块编辑命令（全）
最新发布
06-28
oracle bbed数据块编辑命令（全）
oracle10g bbed 库文件
11-03
7. **恢复更改**: 将修复的块写回数据文件，并根据需要执行数据库的检查点或实例重启。 值得注意的是，bbed工具的使用需要谨慎，因为它涉及到数据库的底层结构，误操作可能导致数据丢失。因此，只有经验丰富的DBA在...
oracle bbed恢复删除数据实例
12-16
恢复己删除数据一、创建模拟环境 代码如下:SQL> create table hr.xifenfei (id number,name varchar2(20)) tablespace xff;Table created.SQL> insert into hr.xifenfei values(1,’xifenfei’);1 row created.SQL> ...
Oracle BBED详解以及强制online数据文件修复数据文件头恢复truncate.md
12-19
使用bbed强制online数据文件，修复system头损坏，找回truncate数据
oracle恢复指定数据文件,Oracle特殊恢复-BBED修改某个数据文件头
weixin_29164081的博客
04-08 339
Oracle数据文件头中的scn要与控制文件中的scn一致，数据库才可以open，在open过程中我们可以通过bbed来修改某个数据文件头的scn，来欺骗oracle，来open库。1、环境如下使用Oracle 11gR2进行测试，具体版本为11.2.0.4SYS@linuxidc SQL>select file#,name,checkpoint_change#,checkpoint_tim...
Oracle 之利用BBED修改数据块SCN----没有备份数据文件的数据恢复
02-22 1175
测试环境 OS：redhat6.6 oracle:12.1.0.2 BBED(OracleBlockBrowerandEDitor Tool)，用来直接查看和修改数据文件数据的一个工具，是Oracle一款内部工具，可以直接修改Oracle数据文件块的内容，在一些极端恢复场景下比较有用。该工具不受Oracle支持，所以默认是没有生成可执行文件的，在使用前需要重新连接。 1.安装BBED [orac...
用bbed修改data block scn之模拟ora-0600[2662]一
cuandou3689的博客
12-29 112
案例出现背景：某个block的scn比该datafile header SCN要大 即是经典的ORA-0600[2662]错误 修改block的scn (除了block1),将该block的scn 更改为同当前data...
【BBED】bbed的使用(二)
cojm55771的博客
08-06 111
前面一章bbed的使用(一)介绍了BBED的编译安装，这一章主要介绍bbed的语法规则。使用bbed 需要使用parfile和listfile1 PARFILE：参数文件记录以下参数：此文件主要记录BLOCKSIZE:数据库的标...
【中亦安图】运维无小事之一次导致数据丢失的小变更（10）
coco3600的博客
04-18 268
第一章技术人生系列·我和数据中心的故事(第十期)·运维无小事之一次导致数据丢失的小变更 中亦安图 | 2016-04-08 22:05 前言 不知不觉，技术人生系列·我...
非常规方法，轻松应对Oracle数据库危急异常
weixin_33862514的博客
04-13 102
作者：唐小丹（浙江移动数据库管理员） 周 凯（上海新炬数据库工程师） 相信很多Oracle DBA在职业生涯中或多或少都遇到过这样的情况：数据文件被误删了，存储坏了无法识别数据文件，最糟糕的是，竟然rman备份也是坏的…… 遇到问题凌乱慌张是没用的，而贸然动手也是非常危险的，当遇到紧急问题，最重要的就是冷静分...
使用BBED修改SCN                 …
Lixora's DB Home
01-28 682
这里记录着阿里巴巴数据库团队成员的点点滴滴 使用BBED修改SCN 作者：vogts | 分类： 大话技术 | 标签： | 日期：2012-05-09 原文：http://www.alidba.net/index.php/archives/594 下面这个错误，我想是很多DBA的痛。 @>startup ; ORACLE instance started. Total System Global
Oracle bbed 实用示例-----File Header Reset
weixin_33910385的博客
01-23 110
一.查看当前环境 1.1 当前控制文件中的SCN号 [oracle@ora10 ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 17 10:11:34 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL&gt; ...
bbed修改SCN号强制打开DB
congcai5135的博客
07-15 143
1.因断电导致数据库因SCN不一致无法启动，但其中的数据重要，需要解决。但该数据库是非归档并且无全备。 以下为模拟当时情况 SQL> select status from v$ins...
oralce bbed 如何编辑数据块
06-13
其中，DATAFILE是包含表EMP数据块的数据文件的名称，BLOCK_NUMBER是要编辑的数据块的块号。 3. 进入编辑模式。使用以下命令： edit 4. 编辑数据块。您可以使用BBED命令来修改数据块中的内容。例如，您可以使用...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值