我分别在9i和10g中，分别dump control file，结果发现两者的区别非常大。不知道原因是什么？
方法:
alter session set events 'immediate trace name CONTROLF level 10';
********************************** control file ( 9i ) **********************************
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /opt/oracle/product/9.2.0
System name:Linux
Node name:localhost.localdomain
Release:2.6.9-5.EL
Version:#1 Wed Jan 5 19:22:18 EST 2005
Machine:i686
Instance name: testdb
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 8541, image: [email protected] (TNS V1-V3)
*** 2006-06-10 00:31:36.245
*** SESSION ID
10.325) 2006-06-10 00:31:36.243
DUMP OF CONTROL FILES, Seq # 248 = 0xf8
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=134217728=0x800
0000
Db ID=2375903378=0x8d9d6892, Db Name='TESTDB'
Activation ID=0=0x0
Control Seq=248=0xf8, File size=246=0xf6
File Number=0, Blksiz=8192, File Type=1 CONTROL
...
********************************* control file ( 10g ) ********************************
*** 2006-09-01 13:22:49.792
DUMP OF CONTROL FILES, Seq # 499 = 0x1f3
V10 STYLE FILE HEADER:
Compatibility Vsn = 169869568=0xa200100
Db ID=2383093601=0x8e0b1f61, Db Name='TESTDB'
Activation ID=0=0x0
Control Seq=499=0x1f3, File size=430=0x1ae
File Number=0, Blksiz=16384, File Type=1 CONTROL
Logical block number 1 (header block)
Dump of memory from 0xB7231A00 to 0xB7235A00
B7231A00 0000C215 00000001 00000000 04010000[................]
B7231A10 0000C29C 00000000 0A200100 8E0B1F61[.......... .a...]
B7231A20 54534554 00004244 000001F3 000001AE[TESTDB..........]
B7231A30 00004000 00010000 00000000 00000000[.@..............]
B7231A40 00000000 00000000 00000000 00000000[................]
Repeat 1 times
B7231A60 8E0EE5AD 23BFB1E2 000A29B0 00000000[.......#.)......]
B7231A70 23C36B52 00000000 00000000 00000000[Rk.#............]
B7231A80 00000000 00000000 00000000 00000000[................]
Repeat 7 times
B7231B00 00000000 00000000 00000008 00000008[................]
B7231B10 00000008 00000000 00000000 00000000[................]
B7231B20 00000000 00000000 00000000 00000000[................]
...
|
