oracle dump 文件解析,8.oracle的dump理解八 dump文件头

8.oracle的dump理解八 dump文件头

在最前面的块DUMP中，是从文件中DUMP出来了。此外我们还可以DUMP文件头。

文件头本身没有很多内容，当需要查看CHECKPOINT的SCN的时候就需要DUMP文件头。

使用ORADEBUG进行DUMP文件有3个等级：

等级1：标准

等级2：增加一点关于v10类型

等级3：增加表空间信息，扩展文件信息。在等级3上可以找到root dba，在文件0的入口可以找到bootstrap表sys.bootstrap$的位置

蛤蟆先来DUMP 等级1 看看

DUMP文件头命令如下：

SQL> oradebug setmypid

SQL> oradebug tracefile_name;

SQL> oradebug dump file_hdrs 1

1     TRACE 文件

每个文件开始都是

DATA FILE #1:

蛤蟆环境中共有9个，其中3个文件已删除了，剩下有6个数据文件，查看如下：

SQL> select file#,name from v$datafile;

FILE#----------NAME

------------------------------------------------

1   F:\TOADDBDATAFILE\TOADDB\SYSTEM01.DBF

3   F:\TOADDBDATAFILE\TOADDB\SYSAUX01.DBF

5   F:\TOADDBDATAFILE\TOADDB\UNDOTBS01.DBF

6   F:\TOADDBDATAFILE\TOADDB\USERS01.DBF

7   F:\TOADDBDATAFILE\TOADDB\EXAMPLE01.DBF

8   F:\TOADDBDATAFILE\TOADDB\TOAD01.DBF

已选择 6 行。

摘取其中一段如下,主要是和红色部分相关的SCN。

DATA FILE #8:

name #10: F:\TOADDBDATAFILE\TOADDB\TOAD01.DBF

creation size=1280 block size=8192status=0xe flg=0x1 head=10 tail=10 dup=1

pdb_id 0, tablespace 6, index=7 krfil=8prev_file_in_ts=0 prev_file_in_pdb=0

unrecoverable scn: 0x0000.00000000 01/01/198800:00:00

Checkpoint cnt:17 scn: 0x0000.002919cb 04/25/2016 06:00:33

Stopscn: 0xffff.ffffffff 04/21/2016 15:58:12

Creation Checkpointed at scn: 0x0000.00255f65 04/21/2016 15:58:12

thread:1 rba:(0xc.17a2e.10)

enabled threads:  01000000 0000000000000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 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 0000000000000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000

HotBackup end marker scn: 0x0000.00000000

aux_file is NOT DEFINED

Plugged readony: NO

Plugin scnscn: 0x0000.00000000

Plugin resetlogs scn/timescn: 0x0000.0000000001/01/1988 00:00:00

Foreign creation scn/timescn: 0x0000.0000000001/01/1988 00:00:00

Foreign checkpoint scn/timescn:0x0000.00000000 01/01/1988 00:00:00

Online move state: 0

DUMP OF TEMP FILES: 1 files in database

如果进行等级2的DUMP，会增加如下内容

V10 STYLE FILE HEADER:

CompatibilityVsn = 202375680=0xc100200

DbID=60949636=0x3a20484, Db Name='TOADDB'

ActivationID=0=0x0

ControlSeq=7239=0x1c47, File size=1280=0x500

FileNumber=8, Blksiz=8192, File Type=3 DATA