dump 控制文件

转载自：http://74.207.254.129/blog_oracle/

Connected to:

Oracle Database 10g EnterpriseEdition Release 10.2.0.1.0 - Production

With thePartitioning, OLAP and Data Mining options

SQL> oradebug SETMYPID;

Statementprocessed.

SQL> oradebugdump controlf 3

Statementprocessed.

SQL> !

然后到user_dump_dest目录下看trace文件，具体看是哪个客户进程的pid就对应哪个文件

[oracle@localhost~]$ ps -ef | grep beq

oracle    7748 7747  0 17:33 ?        00:00:00 oraclegis(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

[oracle@localhostudump]$ pwd

/opt/ora10g/admin/gis/udump

[oracle@localhostudump]$ ll gis_ora_7748.trc

-rw-r----- 1oracle oinstall 91643 11-11 17:33 gis_ora_7748.trc

里面有dump出来的内容大概包括如下内容：

[oracle@localhost udump]$ less gis_ora_7748.trc 
/opt/ora10g/admin/gis/udump/gis_ora_7748.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /opt/ora10g/product/10.2.0/db_1
System name:    Linux
Node name:      localhost
Release:        2.6.18-194.el5PAE
Version:        #1 SMP Fri Apr 2 15:37:44 EDT 2010
Machine:        i686
Instance name: gis
Redo thread mounted by this instance: 1
Oracle process number: 76
Unix process pid: 7748, image: oracle@localhost (TNS V1-V3)


*** 2011-11-11 17:33:24.102
*** SERVICE NAME:(SYS$USERS) 2011-11-11 17:33:24.102
*** SESSION ID:(63.1837) 2011-11-11 17:33:24.102
DUMP OF CONTROL FILES, Seq # 7374 = 0x1cce
 V10 STYLE FILE HEADER:
        Compatibility Vsn = 169869568=0xa200100
        Db ID=3701038080=0xdc995c00, Db Name='GIS'
        Activation ID=0=0x0
        Control Seq=7374=0x1cce, File size=432=0x1b0
        File Number=0, Blksiz=16384, File Type=1 CONTROL
 
 
 
 
***************************************************************************
DATABASE ENTRY
***************************************************************************
 (size = 316, compat size = 316, section max = 1, section in-use = 1,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 1, numrecs = 1)
 08/26/2011 16:01:04
 DB Name "GIS"
 Database flags = 0x00404001 0x00001000
 Controlfile Creation Timestamp  08/26/2011 16:01:05
 Incmplt recovery scn: 0x0000.00000000
 Resetlogs scn: 0x0000.00000001 Resetlogs Timestamp  08/26/2011 16:01:04
:。。。。。。此处省略数行。。。

主要包括以下内容：

DATABASE ENTRY

02CHECKPOINT PROGRESS RECORDS

03EXTENDED DATABASE ENTRY

04REDO THREAD RECORDS

05LOG FILE RECORDS

06DATA FILE RECORDS

07TEMP FILE RECORDS

08TABLESPACE RECORDS

09RMAN CONFIGURATION RECORDS

10FLASHBACK LOGFILE RECORDS

11THREAD INSTANCE MAPPING RECORDS

12MTTR RECORDS

13STANDBY DATABASE MAP RECORDS

14RESTORE POINT RECORDS

15LOG FILE HISTORY RECORDS

16OFFLINE RANGE RECORDS

17ARCHIVED LOG RECORDS

18BACKUP SET RECORDS

19BACKUP PIECE RECORDS

20BACKUP DATAFILE RECORDS

21BACKUP LOG RECORDS

22DATAFILE COPY RECORDS

23BACKUP DATAFILE CORRUPTION RECORDS

24DATAFILE COPY CORRUPTION RECORDS

25DELETION RECORDS

26PROXY COPY RECORDS

27INCARNATION RECORDS

28RMAN STATUS RECORDS

29DATAFILE HISTORY RECORDS

30NORMAL RESTORE POINT RECORDS