今天看了Oracle深入浅出过于SCN那一部分的介绍, 做了做相关的实验, 遇到了如下问题:
１. 运行如下语句, 生成trc 文件
alter system set events 'immediate trace name CONTROLF level 10';
２. 查看trc文件, 发现大部分都是难以读懂的信息. 如下:
/opt/app/oracle/admin/harry/udump/harry_ora_3750.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /opt/app/oracle/product/10.2.1/db_1
System name:Linux
Node name:oracle
Release:2.6.9-40.ELsmp
Version:#1 SMP Mon Jun 26 17:40:56 EDT 2006
Machine:i686
Instance name: harry
Redo thread mounted by this instance: 1
Oracle process number: 20
Unix process pid: 3750, image: oracle@oracle (TNS V1-V3)
*** 2009-06-29 00:20:19.457
*** SERVICE NAME
SYS$USERS) 2009-06-29 00:20:19.456
*** SESSION ID
145.2865) 2009-06-29 00:20:19.456
DUMP OF CONTROL FILES, Seq # 1546 = 0x60a
V10 STYLE FILE HEADER:
Compatibility Vsn = 169869568=0xa200100
Db ID=2182833950=0x821b671e, Db Name='HARRY'
Activation ID=0=0x0
Control Seq=1546=0x60a, File size=430=0x1ae
File Number=0, Blksiz=16384, File Type=1 CONTROL
Logical block number 1 (header block)
Dump of memory from 0xB72D7E00 to 0xB72DBE00
B72D7E00 0000C215 00000001 00000000 04010000[................]
B72D7E10 0000D066 00000000 0A200100 821B671E[f......... ..g..]
B72D7E20 52524148 00000059 0000060A 000001AE[HARRY...........]
B72D7E30 00004000 00010000 00000000 00000000[.@..............]
B72D7E40 00000000 00000000 00000000 00000000[................]
Repeat 1 times
B72D7E60 8250F4CE 28F7115E 002295AE 00000000[..P.^..(..".....]
B72D7E70 292C4A2F 00000000 00000000 00000000[/J,)............]
B72D7E80 00000000 00000000 00000000 00000000[................]
Repeat 7 times
B72D7F00 00000000 00000000 00000008 00000008[................]
.........................
３. 但是把level改成１２好像就可以解决问题
alter system set events 'immediate trace name CONTROLF level 12';
查看trc文件, 结果如下:
/opt/app/oracle/admin/harry/udump/harry_ora_2690.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /opt/app/oracle/product/10.2.1/db_1
System name:Linux
Node name:oracle
Release:2.6.9-40.ELsmp
Version:#1 SMP Mon Jun 26 17:40:56 EDT 2006
Machine:i686
Instance name: harry
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 2690, image: oracle@oracle (TNS V1-V3)
*** 2009-06-29 00:06:03.142
*** SERVICE NAME
SYS$USERS) 2009-06-29 00:06:03.141
*** SESSION ID
152.526) 2009-06-29 00:06:03.141
DUMP OF CONTROL FILES, Seq # 1543 = 0x607
V10 STYLE FILE HEADER:
Compatibility Vsn = 169869568=0xa200100
Db ID=2182833950=0x821b671e, Db Name='HARRY'
Activation ID=0=0x0
Control Seq=1543=0x607, File size=430=0x1ae
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)
05/19/2009 15:14:38
DB Name "HARRY"
Database flags = 0x00404001 0x00001000
Controlfile Creation Timestamp05/19/2009 15:14:38
Incmplt recovery scn: 0x0000.00000000
Resetlogs scn: 0x0000.0006ce7b Resetlogs Timestamp05/19/2009 15:14:43
Prior resetlogs scn: 0x0000.00000001 Prior resetlogs Timestamp06/30/2005 19:09:40
Redo Version: compatible=0xa200100
#Data files = 8, #Online files = 8
Database checkpoint: Thread=1 scn: 0x0000.0022939d
............................
一直没有找到问题的原因, 不知道是否有人遇到过 ? 还是说本身有些设置不对 ? DB的version如下:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE10.2.0.1.0Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
|
