AI 助理
备案控制台
开发者社区 数据库 文章 正文

[20170406]关于文件头转储.txt

2017-04-06 781
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： [20170406]关于文件头转储.txt --//oracle 数据库文件头转储使用如下命令alter session set events 'immediate trace name file_hdrs level 12' ; --//实际上里面有一部分信息来自控制文件,在分析时注意,通过例子来说明: 1.

[20170406]关于文件头转储.txt

--//oracle 数据库文件头转储使用如下命令alter session set events 'immediate trace name file_hdrs level 12' ;
--//实际上里面有一部分信息来自控制文件,在分析时注意,通过例子来说明:

1.环境:

SYS@book> @ &r/ver
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

SYS@book> @ &r/spid

       SID    SERIAL# SPID       PID  P_SERIAL# C50
---------- ---------- ------ ------- ---------- --------------------------------------------------
        56         49 16397       29         17 alter system kill session '56,49' immediate;


$ ls -l  /proc/16397/fd
total 0
lr-x------ 1 oracle oinstall 64 2017-04-06 15:28:32 0 -> /dev/null
l-wx------ 1 oracle oinstall 64 2017-04-06 15:28:32 1 -> /dev/null
l-wx------ 1 oracle oinstall 64 2017-04-06 15:28:32 12 -> pipe:[25896412]
l-wx------ 1 oracle oinstall 64 2017-04-06 15:28:32 2 -> /dev/null
lr-x------ 1 oracle oinstall 64 2017-04-06 15:28:32 3 -> /dev/null
lr-x------ 1 oracle oinstall 64 2017-04-06 15:28:32 4 -> /u01/app/oracle/product/11.2.0.4/dbhome_1/rdbms/mesg/oraus.msb
lr-x------ 1 oracle oinstall 64 2017-04-06 15:28:32 5 -> /proc/16397/fd
lr-x------ 1 oracle oinstall 64 2017-04-06 15:28:32 6 -> /dev/zero
lrwx------ 1 oracle oinstall 64 2017-04-06 15:28:32 7 -> /u01/app/oracle/admin/book/adump/book_ora_16397_20170406152806864944143795.aud
lr-x------ 1 oracle oinstall 64 2017-04-06 15:28:32 9 -> pipe:[25896411]

--//没有控制文件.打开跟踪:
$ strace -f -p 16397   -trace=pread  -o /tmp/aa.txt

2.转储:
SYS@book> alter session set events 'immediate trace name file_hdrs level 12' ;
Session altered.

$ ls -l  /proc/16397/fd
total 0
lr-x------ 1 oracle oinstall 64 2017-04-06 15:28:32 0 -> /dev/null
l-wx------ 1 oracle oinstall 64 2017-04-06 15:28:32 1 -> /dev/null
l-wx------ 1 oracle oinstall 64 2017-04-06 15:30:44 10 -> /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_16397.trc
l-wx------ 1 oracle oinstall 64 2017-04-06 15:30:44 11 -> /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_16397.trm
l-wx------ 1 oracle oinstall 64 2017-04-06 15:28:32 12 -> pipe:[25896412]
l-wx------ 1 oracle oinstall 64 2017-04-06 15:28:32 2 -> /dev/null
lrwx------ 1 oracle oinstall 64 2017-04-06 15:30:44 256 -> /mnt/ramdisk/book/control01.ctl
lrwx------ 1 oracle oinstall 64 2017-04-06 15:30:44 257 -> /mnt/ramdisk/book/control02.ctl
lrwx------ 1 oracle oinstall 64 2017-04-06 15:30:44 258 -> /mnt/ramdisk/book/system01.dbf
lrwx------ 1 oracle oinstall 64 2017-04-06 15:30:44 259 -> /mnt/ramdisk/book/sysaux01.dbf
lrwx------ 1 oracle oinstall 64 2017-04-06 15:30:44 260 -> /mnt/ramdisk/book/undotbs01.dbf
lrwx------ 1 oracle oinstall 64 2017-04-06 15:30:44 261 -> /mnt/ramdisk/book/users01.dbf
lrwx------ 1 oracle oinstall 64 2017-04-06 15:30:44 262 -> /mnt/ramdisk/book/example01.dbf
lrwx------ 1 oracle oinstall 64 2017-04-06 15:30:44 263 -> /mnt/ramdisk/book/tea01.dbf
lrwx------ 1 oracle oinstall 64 2017-04-06 15:30:44 264 -> /mnt/ramdisk/book/temp01.dbf
lr-x------ 1 oracle oinstall 64 2017-04-06 15:28:32 3 -> /dev/null
lr-x------ 1 oracle oinstall 64 2017-04-06 15:28:32 4 -> /u01/app/oracle/product/11.2.0.4/dbhome_1/rdbms/mesg/oraus.msb
lr-x------ 1 oracle oinstall 64 2017-04-06 15:28:32 5 -> /proc/16397/fd
lr-x------ 1 oracle oinstall 64 2017-04-06 15:28:32 6 -> /dev/zero
lrwx------ 1 oracle oinstall 64 2017-04-06 15:28:32 7 -> /u01/app/oracle/admin/book/adump/book_ora_16397_20170406152806864944143795.aud
lr-x------ 1 oracle oinstall 64 2017-04-06 15:28:32 9 -> pipe:[25896411]
--//你可以发现执行完成后打开了控制文件以及数据文件.

$ grep "pread" /tmp/aa.txt
16397      0.000133 pread(256, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4$\346\0\0\0\0\0\0\0\4 \vn!\267O"..., 16384, 16384) = 16384
16397      0.000166 pread(257, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4$\346\0\0\0\0\0\0\0\4 \vn!\267O"..., 16384, 16384) = 16384
16397      0.000117 pread(256, "\25\302\0\0\17\0\0\0\302\222\0\0\377\377\1\4(!\0\0\0C\0\0\0\0\0\0\0\0\0\4"..., 16384, 245760) = 16384
16397      0.000107 pread(256, "\25\302\0\0\21\0\0\0\302\222\0\0\377\377\1\4\311n\0\0\0\0\0\0\0\0\0\0\256\36q5"..., 16384, 278528) = 16384
16397      0.000106 pread(256, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4$\346\0\0\0\0\0\0\0\4 \vn!\267O"..., 16384, 16384) = 16384
16397      0.000108 pread(257, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4$\346\0\0\0\0\0\0\0\4 \vn!\267O"..., 16384, 16384) = 16384
16397      0.000115 pread(256, "\25\302\0\0\17\0\0\0\302\222\0\0\377\377\1\4(!\0\0\0C\0\0\0\0\0\0\0\0\0\4"..., 16384, 245760) = 16384
16397      0.000104 pread(256, "\25\302\0\0\21\0\0\0\302\222\0\0\377\377\1\4\311n\0\0\0\0\0\0\0\0\0\0\256\36q5"..., 16384, 278528) = 16384
16397      0.000102 pread(256, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4$\346\0\0\0\0\0\0\0\4 \vn!\267O"..., 16384, 16384) = 16384
16397      0.000107 pread(257, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4$\346\0\0\0\0\0\0\0\4 \vn!\267O"..., 16384, 16384) = 16384
16397      0.000101 pread(256, "\25\302\0\0\17\0\0\0\302\222\0\0\377\377\1\4(!\0\0\0C\0\0\0\0\0\0\0\0\0\4"..., 16384, 245760) = 16384
16397      0.000104 pread(256, "\25\302\0\0\21\0\0\0\302\222\0\0\377\377\1\4\311n\0\0\0\0\0\0\0\0\0\0\256\36q5"..., 16384, 278528) = 16384
16397      0.000110 pread(256, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4$\346\0\0\0\0\0\0\0\4 \vn!\267O"..., 16384, 16384) = 16384
16397      0.000107 pread(257, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4$\346\0\0\0\0\0\0\0\4 \vn!\267O"..., 16384, 16384) = 16384
16397      0.000101 pread(256, "\25\302\0\0\17\0\0\0\302\222\0\0\377\377\1\4(!\0\0\0C\0\0\0\0\0\0\0\0\0\4"..., 16384, 245760) = 16384
16397      0.000105 pread(256, "\25\302\0\0\21\0\0\0\302\222\0\0\377\377\1\4\311n\0\0\0\0\0\0\0\0\0\0\256\36q5"..., 16384, 278528) = 16384
16397      0.000146 pread(256, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4$\346\0\0\0\0\0\0\0\4 \vn!\267O"..., 16384, 16384) = 16384
16397      0.000109 pread(257, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4$\346\0\0\0\0\0\0\0\4 \vn!\267O"..., 16384, 16384) = 16384
16397      0.000102 pread(256, "\25\302\0\0\17\0\0\0\302\222\0\0\377\377\1\4(!\0\0\0C\0\0\0\0\0\0\0\0\0\4"..., 16384, 245760) = 16384
16397      0.000110 pread(256, "\25\302\0\0\21\0\0\0\302\222\0\0\377\377\1\4\311n\0\0\0\0\0\0\0\0\0\0\256\36q5"..., 16384, 278528) = 16384
16397      0.000098 pread(256, "\25\302\0\0\27\0\0\0:\222\0\0\377\377\1\4w'\0\0\0\0\0\0\0 \0\0\16\0\0\0"..., 16384, 376832) = 16384
16397      0.000113 pread(256, "\25\302\0\0 \0\0\0/\222\0\0\377\377\1\4\267\7\0\0\3\0\3\0\0\0\0\0\0\0/m"..., 16384, 524288) = 16384
16397      0.000111 pread(258, "\v\242\0\0\1\0@\0\0\0\0\0\0\0\1\4=\r\0\0\0\0\0\0\0\4 \vn!\267O"..., 8192, 8192) = 8192
16397      0.000103 pread(259, "\v\242\0\0\1\0\200\0\0\0\0\0\0\0\1\4\364\342\0\0\0\0\0\0\0\4 \vn!\267O"..., 8192, 8192) = 8192
16397      0.000105 pread(260, "\v\242\0\0\1\0\300\0\0\0\0\0\0\0\1\4\325\240\0\0\0\0\0\0\0\4 \vn!\267O"..., 8192, 8192) = 8192
16397      0.000103 pread(261, "\v\242\0\0\1\0\0\1\0\0\0\0\0\0\1\0043\23\0\0\0\0\0\0\0\4 \vn!\267O"..., 8192, 8192) = 8192
16397      0.000128 pread(262, "\v\242\0\0\1\0@\1\0\0\0\0\0\0\1\4\273N\0\0\0\0\0\0\0\4 \vn!\267O"..., 8192, 8192) = 8192
16397      0.000103 pread(263, "\v\242\0\0\1\0\200\1\0\0\0\0\0\0\1\4\32\215\0\0\0\0\0\0\0\4 \vn!\267O"..., 8192, 8192) = 8192
16397      0.000089 pread(256, "\25\302\0\0\265\0\0\0|\2\0\0\377\377\1\4z\362\0\0\0\n\0\0\0 \0\0\36\0\10\0"..., 16384, 2965504) = 16384
16397      0.000102 pread(264, "\v\242\0\0\1\0@\0\0\0\0\0\0\0\1\4\312\6\0\0\0\0\0\0\0\4 \vn!\267O"..., 8192, 8192) = 8192

--//可以发现转储时也读取了控制文件后,在依次读取数据文件句柄258,259,.... ,然后在读取控制文件,在读取临时文件.句柄264.

3.通过bbed改写文件头确认里面的信息:
SYS@book> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.

SYS@book> startup mount
ORACLE instance started.
Total System Global Area    634732544 bytes
Fixed Size                    2255792 bytes
Variable Size               197133392 bytes
Database Buffers            427819008 bytes
Redo Buffers                  7524352 bytes
Database mounted.

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                             TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------- ----------------
    1        13277116630 2017-04-06 15:40:05                7            925702 ONLINE               937 NO  /mnt/ramdisk/book/system01.dbf   SYSTEM
    2        13277116630 2017-04-06 15:40:05             1834            925702 ONLINE               926 NO  /mnt/ramdisk/book/sysaux01.dbf   SYSAUX
    3        13277116630 2017-04-06 15:40:05           923328            925702 ONLINE               847 NO  /mnt/ramdisk/book/undotbs01.dbf  UNDOTBS1
    4        13277116630 2017-04-06 15:40:05            16143            925702 ONLINE               932 NO  /mnt/ramdisk/book/users01.dbf    USERS
    5        13277116630 2017-04-06 15:40:05           952916            925702 ONLINE               843 NO  /mnt/ramdisk/book/example01.dbf  EXAMPLE
    6        13277116630 2017-04-06 15:40:05      13276257767            925702 ONLINE               316 NO  /mnt/ramdisk/book/tea01.dbf      TEA
6 rows selected.

--//数据文件6 CHECKPOINT_COUNT=316,我增加到416看看.

BBED> p /d dba 6,1 kcvfh.kcvfhcpc
ub4 kcvfhcpc                                @140      316

BBED> p /d dba 6,1 kcvfh.kcvfhccc
ub4 kcvfhccc                                @148      315

--//我这两个数值增加100看看.
BBED> assign dba 6,1 kcvfh.kcvfhcpc=416
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
ub4 kcvfhcpc                                @140      0x000001a0

BBED> assign dba 6,1 kcvfh.kcvfhccc=415
ub4 kcvfhccc                                @148      0x0000019f

BBED> sum apply dba 6,1
Check value for File 6, Block 1:
current = 0x3d1b, required = 0x3d1b

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                                               TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- ------------------------------
    1        13277116630 2017-04-06 15:40:05                7            925702 ONLINE               937 NO  /mnt/ramdisk/book/system01.dbf                     SYSTEM
    2        13277116630 2017-04-06 15:40:05             1834            925702 ONLINE               926 NO  /mnt/ramdisk/book/sysaux01.dbf                     SYSAUX
    3        13277116630 2017-04-06 15:40:05           923328            925702 ONLINE               847 NO  /mnt/ramdisk/book/undotbs01.dbf                    UNDOTBS1
    4        13277116630 2017-04-06 15:40:05            16143            925702 ONLINE               932 NO  /mnt/ramdisk/book/users01.dbf                      USERS
    5        13277116630 2017-04-06 15:40:05           952916            925702 ONLINE               843 NO  /mnt/ramdisk/book/example01.dbf                    EXAMPLE
    6        13277116630 2017-04-06 15:40:05      13276257767            925702 ONLINE               416 NO  /mnt/ramdisk/book/tea01.dbf                        TEA
6 rows selected.
--//数据文件6的CHECKPOINT_COUNT=416.

4.再继续执行转储看看:
SYS@book> alter session set events 'immediate trace name file_hdrs level 12' ;
Session altered.

--//检查转储内容:
DATA FILE #6:
  name #10: /mnt/ramdisk/book/tea01.dbf
creation size=5120 block size=8192 status=0xe head=10 tail=10 dup=1
tablespace 7, index=7 krfil=6 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:316 scn: 0x0003.1760b8d6 04/06/2017 15:40:05
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Stop scn: 0x0003.1760b8d6 04/06/2017 15:40:05
Creation Checkpointed at scn:  0x0003.17539de7 02/13/2017 15:09:58
thread:1 rba:(0x1d6.48.10)
enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 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: 0x0003.175f8300 prev_range: 0
Online Checkpointed at scn:  0x0003.175f8324 04/05/2017 11:10:42
thread:1 rba:(0x2f9.195e.10)
enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
Hot Backup end marker scn: 0x0000.00000000
aux_file is NOT DEFINED
Plugged readony: NO
Plugin scnscn: 0x0000.00000000
Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
Online move state: 0

V10 STYLE FILE HEADER:
    Compatibility Vsn = 186647552=0xb200400
    Db ID=1337401710=0x4fb7216e, Db Name='BOOK'
    Activation ID=0=0x0
    Control Seq=37574=0x92c6, File size=5120=0x1400
    File Number=6, Blksiz=8192, File Type=3 DATA
Tablespace #7 - TEA  rel_fn:6
Creation   at   scn: 0x0003.17539de7 02/13/2017 15:09:58
Backup taken at scn: 0x0003.175f8350 04/05/2017 11:11:14 thread:1
reset logs count:0x35711eb0 scn: 0x0000.000e2006
prev reset logs count:0x3121c97a scn: 0x0000.00000001
recovered at 04/05/2017 11:15:13
status:0x0 root dba:0x00000000 chkpt cnt: 416 ctl cnt:415
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
begin-hot-backup file size: 5120
Checkpointed at scn:  0x0003.1760b8d6 04/06/2017 15:40:05
thread:1 rba:(0x30f.f5fb.10)
enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
Backup Checkpointed at scn:  0x0003.175f8350 04/05/2017 11:11:14
thread:1 rba:(0x2f9.1987.10)
enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 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  01/01/1988 00:00:00
Platform Information:    Creation Platform ID: 13
Current Platform ID: 13 Last Platform ID: 13
DUMP OF TEMP FILES: 1 files in database

--//注意看下划线部分
Checkpoint cnt:316 scn: 0x0003.1760b8d6 04/06/2017 15:40:05
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
status:0x0 root dba:0x00000000 chkpt cnt: 416 ctl cnt:415
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--//很明显前面部分来自控制文件.

DATA FILE #6:来自控制文件.
V10 STYLE FILE HEADER:的内容才来自数据文件头.

--//在工作中分析注意,实际上我觉得oracle应该在转储时说明 仅仅加入一段信息DATA FILE #6 from controlfile就ok了.

5.看看这样能open吗?

SYS@book> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01122: database file 6 failed verification check
ORA-01110: data file 6: '/mnt/ramdisk/book/tea01.dbf'
ORA-01207: file is more recent than control file - old control file

--//改小看看是否可行.
BBED> assign dba 6,1 kcvfh.kcvfhcpc=306
ub4 kcvfhcpc                                @140      0x00000132

BBED> assign dba 6,1 kcvfh.kcvfhccc=305
ub4 kcvfhccc                                @148      0x00000131

BBED> sum apply dba 6,1
Check value for File 6, Block 1:
current = 0x3d27, required = 0x3d27

SYS@book> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01113: file 6 needs media recovery
ORA-01110: data file 6: '/mnt/ramdisk/book/tea01.dbf'

SYS@book> recover datafile 6
Media recovery complete.

SYS@book> alter database open ;
Database altered.

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                             TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------- ----------------
    1        13277116634 2017-04-06 15:54:45                7            925702 ONLINE               938 YES /mnt/ramdisk/book/system01.dbf   SYSTEM
    2        13277116634 2017-04-06 15:54:45             1834            925702 ONLINE               927 YES /mnt/ramdisk/book/sysaux01.dbf   SYSAUX
    3        13277116634 2017-04-06 15:54:45           923328            925702 ONLINE               848 YES /mnt/ramdisk/book/undotbs01.dbf  UNDOTBS1
    4        13277116634 2017-04-06 15:54:45            16143            925702 ONLINE               933 YES /mnt/ramdisk/book/users01.dbf    USERS
    5        13277116634 2017-04-06 15:54:45           952916            925702 ONLINE               844 YES /mnt/ramdisk/book/example01.dbf  EXAMPLE
    6        13277116634 2017-04-06 15:54:45      13276257767            925702 ONLINE               318 YES /mnt/ramdisk/book/tea01.dbf      TEA
6 rows selected.

--//open后CHECKPOINT_COUNT增加2.
--//实际上我自己有补充测试1次,recover datafile 6后在控制文件的基础上+1.open后有增加1.

总之一点注意转储数据文件头时,有部分信息来自控制文件,切记!!

文章标签：
关系型数据库
Oracle
数据库
数据库管理
lfreeali
目录
相关文章
javaedge
|
安全 Java
Jprofile解析dump文件使用详解（一）
Jprofile解析dump文件使用详解（一）
javaedge
715 0
Jprofile解析dump文件使用详解（一）
热爱技术的小郑
|
3月前
|
Java
File常用的方法操作、在磁盘上创建File、获取指定目录下的所有文件、File文件的重命名、将数据写入File文件
这篇文章介绍了Java中`File`类的常用方法操作，包括文件和目录路径名的抽象表示、构造方法、常用方法以及代码实例。文章通过具体的代码示例，展示了如何在磁盘上创建文件和目录、处理目录存在的情况、文件重命名、获取指定目录下的所有文件以及将数据写入文件等操作。每个代码实例都配有测试结果截图，帮助读者更好地理解和掌握`File`类的应用。
热爱技术的小郑
59 1
File常用的方法操作、在磁盘上创建File、获取指定目录下的所有文件、File文件的重命名、将数据写入File文件
javaedge
|
开发框架 监控 Java
Jprofile解析dump文件使用详解（二）
Jprofile解析dump文件使用详解（二）
javaedge
618 0
Jprofile解析dump文件使用详解（二）
lfreeali
|
数据库管理
[20171228]关于数据块转储的问题.txt
[20171228]关于数据块转储的问题.txt --//昨天itpub上的问题,链接:http://www.itpub.net/thread-2095877-1-1.
lfreeali
924 0
技术小阿哥
|
数据库 Windows
vbs读取文件内的信息将对应数据拷贝到其他路径
技术小阿哥
1176 0
余二五
tail: 无法打开“+2” 读取数据: 没有那个文件或目录
余二五
1981 0
lfreeali
|
Oracle 关系型数据库 Linux
[20161129]转储内存的内容还原成数据块.txt
[20161129]转储内存的内容还原成数据块.txt --昨天在做1128PAGETABLE SEGMENT HEADER损坏恢复，链接http://blog.itpub.net/267265/viewspace-2129195/ --在做还原成数据块时思路很乱，当时是一边做一边想，希望能找到好的方法，今天自己在重复做一次。
lfreeali
901 0
lfreeali
|
Oracle 关系型数据库 数据格式
[20161130]11g跟踪文件位置.txt
[20161130]11g跟踪文件位置.txt --11G使用adrci管理跟踪文件，支持XML，不再像10g那样的目录管理方式。 --实际上在安装时仅仅设置参数diagnostic_dest。
lfreeali
974 0
lfreeali
|
前端开发 数据库 数据库管理
[20161111]数据库文件头的修复.txt
[20161111]数据库文件头的修复.txt --这里指文件头实际上数据文件第1块(从0算起)。 --找到一个链接，http://www.cnblogs.com/hrhguanli/p/4708273.html --要修改的信息相对较多。
lfreeali
882 0
lfreeali
|
数据库管理 关系型数据库 Oracle
[20161111]数据文件的第0块2.txt
[20161111]数据文件的第0块2.txt --如果数据文件的第0块是OS块信息，以前的测试如果rman做备份集都不会备份。 --如果这块损坏，里面讲问题不大，你甚至可以不修复，如果在线resize就ok了，当然重建控制文件就出现问题。
lfreeali
1094 0