dump 控制文件

最新推荐文章于 2021-04-12 13:01:36 发布

iqlife

最新推荐文章于 2021-04-12 13:01:36 发布

阅读量1.1k

点赞数

分类专栏： Oracle DBA 文章标签： database oracle file thread header session

Oracle DBA 专栏收录该内容

59 篇文章 0 订阅

订阅专栏

转载自：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
:。。。。。。此处省略数行。。。