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
    评论
文件的读写基本操作
范高伦的博客
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 Oracle数据修复工具
04-06
这个工具允许用户直接操作Oracle数据文件（.dbf）中的数据块，进行读取、修改和写入操作。bbed的强大之处在于，它能帮助管理员对数据库进行低级别修复，尤其是在传统的备份和恢复方法无法解决问题时，bbed往往能成为...
bbed-修改数据文件scn
renyanjie123的博客
03-24 1317
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修改数据文件SCN
qq_22960681的博客
07-26 139
oracle极端故障恢复 BBED修复
oracle恢复指定数据文件,Oracle特殊恢复-BBED修改某个数据文件头
weixin_29164081的博客
04-08 340
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数据库危急异常
weixin_33862514的博客
04-13 103
作者：唐小丹（浙江移动数据库管理员） 周 凯（上海新炬数据库工程师） 相信很多Oracle DBA在职业生涯中或多或少都遇到过这样的情况：数据文件被误删了，存储坏了无法识别数据文件，最糟糕的是，竟然rman备份也是坏的…… 遇到问题凌乱慌张是没用的，而贸然动手也是非常危险的，当遇到紧急问题，最重要的就是冷静分...
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数据
bbed工具（三个包）+bbed安装使用方法，详细的案例恢复：oracle非归档数据库offline的数据文件恢复。做完后可掌握bbed及故障恢复。值得推荐。
08-10
bbed工具（三个包，用于linux服务器）+bbed安装使用方法，详细的案例恢复：oracle非归档数据库offline的数据文件恢复。做完后可掌握bbed及故障恢复。值得推荐。
利用 BBED 恢复非归档模式下 OFFLINE 数据文件
aaron8219's Oracle&Linux Technology Blog
09-05 1451
今天来模拟一个非归档模式下恢复OFFLINE数据文件的场景，主要有2种情况： 一种是在线日志没有被覆盖，另一种是在线日志被覆盖。 第一种情况比较简单，数据库自身就能处理，而第二种情况稍显复杂，但也并不难，下面开始整个过程： 一、在线日志没有被覆盖的场景 --切换数据库到非归档模式 SQL> archive log list Database log mode
Oracle SCN 深入研究
369540808
08-17 150
一. SCN 说明 之前也整理过几遍Oracle SCN的文章，如下： Oracle DB 服务器系统时间修改问题 与SCN 关系的深入研究 http://blog.csdn.net/tianlesoftware/article/details/6163859 Oracle Blockscn/commit scn/cleanout scn 说明 http://blog.csdn.net/t...
bbed修改SCN号强制打开DB
congcai5135的博客
07-15 144
1.因断电导致数据库因SCN不一致无法启动，但其中的数据重要，需要解决。但该数据库是非归档并且无全备。 以下为模拟当时情况 SQL> select status from v$ins...
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; ...
控制文件与数据文件头SCN不一致导致数据库无法启动故障处理 Fuzzy scn
mygodhome的专栏
10-25 1541
Reference: https://www.askmaclean.com/archives/rman-06026-absolute_fuzzy_change.html https://blog.csdn.net/songxixi/article/details/7010934 RMAN> run{ debug on; set until time "to_date('2013-08...
恢复数据库时须要关注的scn信息
adr5970的博客
05-24 223
--从controlfile读取scn信息 set linesize 140 col dummy for a140 set linesize 140 numformat 999999999999999999 prompt --系统scn select checkpoint_change# from v$database; prompt --数据文件scn se...
Oracle 10g 中 X$KCVFH 说明
数据库天地
10-30 264
一. X$表说明 之前整理了一篇有关动态性能视图的blog： Oracle 动态性能视图 http://blog.csdn.net/tianlesoftware/article/details/5863191 Oracle 参数分类 和 参数的查看方法 http://blog.csdn.net/tianlesoftware/article/details/5583655 The fi...
关于控制文件与数据文件头信息的说明（zt）
cuixie2370的博客
09-27 287
为了回答一些疑问，引出本系列文章，讨论链接参考: http://www.itpub.net/609499.html 当我们使用file_hdrs事件来转储数据文件头信息时，Oracle会转储两部分信息，一部分来自控...
Oracle BBED工具：数据文件块查看与编辑
BBED（Oracle Block Browser and Editor Tool）是一个强大的工具，它允许管理员直接操作数据库的数据文件，查看和修改其内容。这个工具虽然不被Oracle官方正式支持，但在特定的故障恢复或者数据修复场景中，BBED可以...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值