对oracle datafile header进行转储

环境：
rhel5.5，x64，oracle 10.2.0.5.12

转储命令：

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

该命令摘自：
How to Find DATE and TIME of Creation of Datafile? (Doc ID 1039747.6)

[oracle@jjtest udump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Fri May 15 12:08:02 2015

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter session set events 'immediate trace name file_hdrs level 10'; 

Session altered.

SQL> exit

生成在udump目录下
[oracle@jjtest udump]$ ls -lrt
total 172
-rw-r----- 1 oracle oinstall   672 May 13 08:08 orcl_ora_5696.trc
-rw-r----- 1 oracle oinstall  1107 May 13 08:12 orcl_ora_5743.trc
-rw-r----- 1 oracle oinstall   672 May 13 08:12 orcl_ora_5745.trc
-rw-r----- 1 oracle oinstall  3032 May 13 08:14 orcl_ora_5771.trc
-rw-r----- 1 oracle oinstall  1007 May 13 08:15 orcl_ora_5811.trc
-rw-r----- 1 oracle oinstall   672 May 13 08:15 orcl_ora_5813.trc
-rw-r----- 1 oracle oinstall   916 May 13 08:15 orcl_ora_5843.trc
-rw-r----- 1 oracle oinstall  1007 May 13 09:42 orcl_ora_6322.trc
-rw-r----- 1 oracle oinstall   674 May 13 09:57 orcl_ora_14465.trc
-rw-r----- 1 oracle oinstall   918 May 13 09:57 orcl_ora_14493.trc
-rw-r----- 1 oracle oinstall   858 May 13 10:17 orcl_ora_14595.trc
-rw-r----- 1 oracle oinstall   700 May 14 05:38 orcl_ora_4833.trc
-rw-r----- 1 oracle oinstall  2369 May 14 05:39 orcl_ora_4863.trc
-rw-r----- 1 oracle oinstall   704 May 14 05:54 orcl_ora_5074.trc
-rw-r----- 1 oracle oinstall   700 May 15 08:24 orcl_ora_4319.trc
-rw-r----- 1 oracle oinstall  3910 May 15 08:42 orcl_ora_4347_10046.trc
-rw-r----- 1 oracle oinstall   820 May 15 09:12 orcl_ora_4393_controlfile.trc
-rw-r----- 1 oracle oinstall   820 May 15 09:18 orcl_ora_4463.trc
-rw-r----- 1 oracle oinstall 45745 May 15 09:28 orcl_ora_4484.trc
-rw-r----- 1 oracle oinstall   811 May 15 12:03 orcl_ora_4855.trc
-rw-r----- 1 oracle oinstall 48376 May 15 12:08 orcl_ora_4956.trc --->此文件就是datafile header进行转储得到的文件
[oracle@jjtest udump]$ date
Fri May 15 12:08:10 CST 2015

以下全文引用'orcl_ora_4956.trc'文件的内容：

/u01/app/oracle/admin/orcl/udump/orcl_ora_4956.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name:	Linux
Node name:	jjtest
Release:	2.6.18-348.el5
Version:	#1 SMP Wed Nov 28 21:22:00 EST 2012
Machine:	x86_64
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 4956, image: oracle@jjtest (TNS V1-V3)

*** ACTION NAME:() 2015-05-15 12:08:06.136
*** MODULE NAME:(sqlplus@jjtest (TNS V1-V3)) 2015-05-15 12:08:06.136
*** SERVICE NAME:() 2015-05-15 12:08:06.136
*** SESSION ID:(654.17) 2015-05-15 12:08:06.136
DUMP OF DATA FILES: 7 files in database
 
DATA FILE #1: 
  (name #7) /u01/app/oracle/oradata/orcl/system01.dbf
creation size=0 block size=8192 status=0xe head=7 tail=7 dup=1
 tablespace 0, index=1 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:58 scn: 0x0000.0006b6fe 05/14/2015 05:39:06
 Stop scn: 0xffff.ff

对oracle datafile header进行转储(一)