Total System Global Area 599785472 bytes
Fixed Size 2022600 bytes
Variable Size 230687544 bytes
Database Buffers 360710144 bytes
Redo Buffers 6365184 bytes
Database mounted.
SQL> @?/rdbms/admin/gettrace
TRACE_FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oracle1/admin/orcl/udump/orcl_ora_4132.trc
SQL> alter session set events 'immediate trace name controlf level 8';
Session altered.
完成对控制文件的转储，下面来查看一下orcl_ora_4132.trc跟踪文件内容：
a).存储在控制文件中的数据库内容：
***************************************************************************
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)
02/19/2014 14:20:20
DB Name "ORCL"
Database flags = 0x50404001 0x00001000
Controlfile Creation Timestamp 02/19/2014 14:20:21
Incmplt recovery scn: 0x0000.00000000
Resetlogs scn: 0x0000.00080634 Resetlogs Timestamp 02/19/2014 14:20:23
Prior resetlogs scn: 0x0000.00000001 Prior resetlogs Timestamp 10/22/2005 21:44:08
Redo Version: compatible=0xa200100
#Data files = 6, #Online files = 6
Database checkpoint: Thread=1 scn: 0x0000.00091eb4
Threads: #Enabled=1, #Open=0, Head=0, Tail=0
......
Max log members = 3, Max data members = 1
Arch list: Head=2, Tail=2, Force scn: 0x0000.00091e72scn: 0x0000.00091e88
Activation ID: 1367751332
Controlfile Checkpointed at scn: 0x0000.00091e88 04/16/2014 13:54:24
thread:0 rba:(0x0.0.0)
......
粗体加红表示的数据库检查点SCN号。
b).存储在控制文件中的数据文件检查点次数、SCN号和停止SCN号：
***************************************************************************
DATA FILE RECORDS
***************************************************************************
(size = 428, compat size = 428, section max = 100, section in-use = 6,
last-recid= 9, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 11, numrecs = 100)
DATA FILE #1:
(name #7) /u01/app/oracle1/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:183 scn: 0x0000.00091eb4 04/16/2014 13:54:27
Stop scn: 0x0000.00091eb4 04/16/2014 13:54:27
Creation Checkpointed at scn: 0x0000.00000008 10/22/2005 21:44:31
thread:0 rba:(0x0.0.0)
cnt表示的是检查点次数，scn表示的是数据文件检查点SCN，Stop scn表示的是数据文件停止SCN。
DATA FILE #2:
(name #6) /u01/app/oracle1/oradata/orcl/undotbs01.dbf
creation size=0 block size=8192 status=0xe head=6 tail=6 dup=1
tablespace 1, index=2 krfil=2 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:145 scn: 0x0000.00091eb4 04/16/2014 13:54:27
Stop scn: 0x0000.00091eb4 04/16/2014 13:54:27
Creation Checkpointed at scn: 0x0000.0007fd42 10/22/2005 22:24:27
thread:0 rba:(0x0.0.0)
DATA FILE #3:
(name #5) /u01/app/oracle1/oradata/orcl/sysaux01.dbf
creation size=0 block size=8192 status=0xe head=5 tail=5 dup=1
tablespace 2, index=3 krfil=3 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:183 scn: 0x0000.00091eb4 04/16/2014 13:54:27
Stop scn: 0x0000.00091eb4 04/16/2014 13:54:27
Creation Checkpointed at scn: 0x0000.00001896 10/22/2005 21:44:46
thread:0 rba:(0x0.0.0)
DATA FILE #4:
(name #4) /u01/app/oracle1/oradata/orcl/users01.dbf
creation size=0 block size=8192 status=0xe head=4 tail=4 dup=1
tablespace 4, index=4 krfil=4 prev_file=0
unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
Checkpoint cnt:182 scn: 0x0000.00091eb4 04/16/2014 13:54:27
Stop scn: 0x0000.00091eb4 04/16/2014 13:54:27
Creation Checkpointed at scn: 0x0000.000027b9 10/22/2005 21:45:00
thread:0 rba:(0x0.0.0)