oracle10g_alter session set events 'immediate trace name controlf level 8'dump

--用alter session set events 'immediate trace name controlf level 8' --轉儲控制檔案資訊進行學習
--僅摘錄dump檔案（在udump目錄下）關鍵部分資訊

---包括有dbid,db name
DUMP OF CONTROL FILES, Seq # 673 = 0x2a1
 V10 STYLE. FILE HEADER:
 Compatibility Vsn = 169869568=0xa200100
 Db ID=1254727785=0x4ac9a069, Db Name='ORCL'
 Activation ID=0=0x0
 Control Seq=673=0x2a1, File size=430=0x1ae
 File Number=0, Blksiz=16384, File Type=1 CONTROL
 
 
 
 
---資料庫條目：db name ,建立控制檔案時間,resetlogs scn(change#),prior resetlogs scn(及對應的時間）,
--database checkpoint;這些對應資訊儲存在v$database中
***************************************************************************
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/13/2010 17:44:09
 DB Name "ORCL"
 Database flags = 0x00404000 0x00001000
 Controlfile Creation Timestamp  08/13/2010 17:44:09
 Incmplt recovery scn: 0x0000.00000000
 Resetlogs scn: 0x0000.00080634 Resetlogs Timestamp  08/13/2010 17:44:12
 Prior resetlogs scn: 0x0000.00000001 Prior resetlogs Timestamp  10/22/2005 21:44:08
 Redo Version: compatible=0xa200100
 #Data files = 4, #Online files = 3
 Database checkpoint: Thread=1 scn: 0x0000.000b6232
 Threads: #Enabled=1, #Open=1, Head=1, Tail=1
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Max log members = 3, Max data members = 1
 Arch list: Head=0, Tail=0, Force scn: 0x0000.000b0d9cscn: 0x0000.00080634
 Activation ID: 1254764649
 Controlfile Checkpointed at scn:  0x0000.000b6771 08/18/2010 12:22:42  ---controlfile checkpoint及scn
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 
 
 
 

---檢查點程式記錄資訊---low cache rba ,on disk rba,heartbeat(每三秒觸發一次）,rba(譯為redo byte address)
--ckpt程式根據rba（首次修改資料塊對應的地址）在髒佇列（檢查點佇列,fifo方式）對修改過的buffer（髒資料）進行排序
---ckpt會定期或根據相關條件從髒佇列把最早的rba髒資料寫出到資料檔案中(rba有lrba及hrba:分為low rba及high rba,是相對於高低來說的）
--disk rba是例項恢復或crash recovery要恢復的終點（也就是說日誌應用到這個點就可以了）,lrba是應用髒資料的起點（或者說ckpt程式是從
--這個地址開始寫出髒資料到資料檔案中）
***************************************************************************
CHECKPOINT PROGRESS RECORDS
***************************************************************************
 (size = 8180, compat size = 8180, section max = 11, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 2, numrecs = 11)
THREAD #1 - status:0x2 flags:0x0 dirty:46 --dirty指髒資料塊
low cache rba:(0xe.660.0) on disk rba:(0xe.69c.0)
on disk scn: 0x0000.000b677a 08/18/2010 12:22:42
resetlogs scn: 0x0000.00080634 08/13/2010 17:44:12
heartbeat: 727381360 mount id: 1255111440
THREAD #2 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #3 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #4 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #5 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #6 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #7 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #8 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
 
 
 
---擴充套件性資料庫條目,控制檔案自動備份日期
 
***************************************************************************
EXTENDED DATABASE ENTRY
***************************************************************************
 (size = 276, compat size = 276, section max = 1, section in-use = 1,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 137, numrecs = 1)
Control AutoBackup date(dd/mm/yyyy)=13/ 8/2010
Next AutoBackup sequence= 0
Database recovery target inc#:2, Last open inc#:2
flg:0x0, flag:0x0
Change tracking state=0, file index=0, checkpoint count=0
Flashback log count=0, block count=0
Oldest guarantee restore point=0
 
 
 
---重作執行緒記錄資訊--redo thread指什麼呢，我也不懂
***************************************************************************
REDO THREAD RECORDS
***************************************************************************
 (size = 256, compat size = 256, section max = 8, section in-use = 1,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 9, numrecs = 8)
THREAD #1 - status:0xf thread links forward:0 back:0
 #logs:3 first:1 last:3 current:1 last used seq#:0xe
 enabled at scn: 0x0000.00080634 08/13/2010 17:44:12
 disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
 opened at 08/18/2010 11:46:29 by instance orcl
Checkpointed at scn:  0x0000.000b6232 08/18/2010 11:46:29
 thread:1 rba:(0xe.2.10)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 log history: 13 --這裡有個日誌歷史為13
 
 
 
 

---日誌檔案記錄資訊:每個日誌檔案的詳細資訊
---size,seq,low scn,next scn
--low scn及next scn表示日誌檔案的status狀態（是否為inactive,current,active)
--next_scn如為0xffff.ffffffff,表示為current狀態，處於當前狀態，其對應資訊可檢視
---v$log
***************************************************************************
LOG FILE RECORDS
***************************************************************************
 (size = 72, compat size = 72, section max = 16, section in-use = 3,  --這部分資訊為以上詳細資訊的概述
  last-recid= 3, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 10, numrecs = 16)
LOG FILE #1:
  (name #3) /oracle/oradata/orcl/redo01.log
 Thread 1 redo log links: forward: 2 backward: 0
 siz: 0x19000 seq: 0x0000000e hws: 0x2 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1 --siz(19000)及bsz(512k)對應v$log中的bytes
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000b10e9
 Low scn: 0x0000.000b6231 08/18/2010 11:46:29  --low scn（對應v$log之FIRST_CHANGE#及fisrt_time)
 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
LOG FILE #2:
  (name #2) /oracle/oradata/orcl/redo02.log
 Thread 1 redo log links: forward: 3 backward: 1
 siz: 0x19000 seq: 0x0000000c hws: 0x3 bsz: 512 nab: 0x17dd5 flg: 0x0 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000b0bcb
 Low scn: 0x0000.000b0d9c 08/17/2010 12:01:15
 Next scn: 0x0000.000b10e9 08/17/2010 12:11:19
LOG FILE #3:
  (name #1) /oracle/oradata/orcl/redo03.log
 Thread 1 redo log links: forward: 0 backward: 2
 siz: 0x19000 seq: 0x0000000d hws: 0x4 bsz: 512 nab: 0x485c flg: 0x0 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000b0d9c
 Low scn: 0x0000.000b10e9 08/17/2010 12:11:19
 Next scn: 0x0000.000b6231 08/18/2010 11:46:29
 
 
 
 
---資料檔案記錄資訊
---creation size   checkpoint scn(change#)|time   unrecoverable scn(change#)|time
--checkpont scn offline_scn(change#)|time
---stop scn(如當前檔案則為0xffff.ffffffff),如離線offline則不為0xffff.ffffffff
***************************************************************************
DATA FILE RECORDS
***************************************************************************
 (size = 428, compat size = 428, section max = 100, section in-use = 4,
  last-recid= 116, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 11, numrecs = 100)
DATA FILE #1:
  (name #7) /oracle/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:78 scn: 0x0000.000b6232 08/18/2010 11:46:29
 Stop scn: 0xffff.ffffffff 08/17/2010 12:39:13
 Creation Checkpointed at scn:  0x0000.00000008 10/22/2005 21:44:31
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Offline scn: 0x0000.00080633 prev_range: 0
 Online Checkpointed at scn:  0x0000.00080634 08/13/2010 17:44:12
 thread:1 rba:(0x1.2.0)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED
DATA FILE #2:
  (name #6) /oracle/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:40 scn: 0x0000.000b6232 08/18/2010 11:46:29
 Stop scn: 0xffff.ffffffff 08/17/2010 12:39:13
 Creation Checkpointed at scn:  0x0000.0007fd42 10/22/2005 22:24:27
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Offline scn: 0x0000.00080633 prev_range: 0
 Online Checkpointed at scn:  0x0000.00080634 08/13/2010 17:44:12
 thread:1 rba:(0x1.2.0)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED
DATA FILE #3:
  (name #5) /oracle/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:78 scn: 0x0000.000b6232 08/18/2010 11:46:29
 Stop scn: 0xffff.ffffffff 08/17/2010 12:39:13
 Creation Checkpointed at scn:  0x0000.00001896 10/22/2005 21:44:46
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Offline scn: 0x0000.00080633 prev_range: 0
 Online Checkpointed at scn:  0x0000.00080634 08/13/2010 17:44:12
 thread:1 rba:(0x1.2.0)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED

 
 
 
 --臨時檔案記錄資訊
--creation size block size
--head tail
***************************************************************************
TEMP FILE RECORDS
***************************************************************************
 (size = 56, compat size = 56, section max = 100, section in-use = 1,
  last-recid= 1, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 89, numrecs = 100)
TEMP FILE #1: External File #201
  (name #8) /oracle/oradata/orcl/temp01.dbf
creation size=2560 block size=8192 status=0x1e head=8 tail=8 dup=1
 tablespace 3, index=5 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00080681 08/13/2010 17:44:21
 
 
 
 

---表空間記錄資訊
--
***************************************************************************
TABLESPACE RECORDS
***************************************************************************
 (size = 68, compat size = 68, section max = 100, section in-use = 5,
  last-recid= 1, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 88, numrecs = 100)
TABLESPACE #0 SYSTEM: recno=1
 First datafile link=1  Tablespace Flag=0
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #1 UNDOTBS1: recno=2
 First datafile link=2  Tablespace Flag=0
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #2 SYSAUX: recno=3
 First datafile link=3  Tablespace Flag=0
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #4 USERS: recno=4
 First datafile link=4  Tablespace Flag=0
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #3 TEMP: recno=5
 First datafile link=1  Tablespace Flag=1
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
 
 
 
 --rman配置記錄資訊
***************************************************************************
RMAN CONFIGURATION RECORDS
***************************************************************************
 (size = 1108, compat size = 1108, section max = 50, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 90, numrecs = 50)
 
 
 
 --閃回日誌檔案記錄資訊
***************************************************************************
FLASHBACK LOGFILE RECORDS
***************************************************************************
 (size = 84, compat size = 84, section max = 2048, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 139, numrecs = 2048)
 
 
 
 --執行緒例項對映記錄資訊
***************************************************************************
THREAD INSTANCE MAPPING RECORDS
***************************************************************************
 (size = 80, compat size = 80, section max = 8, section in-use = 8,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 156, numrecs = 8)
orcl recno=1
UNNAMED_INSTANCE_2 recno=2
UNNAMED_INSTANCE_3 recno=3
UNNAMED_INSTANCE_4 recno=4
UNNAMED_INSTANCE_5 recno=5
UNNAMED_INSTANCE_6 recno=6
UNNAMED_INSTANCE_7 recno=7
UNNAMED_INSTANCE_8 recno=8
 
 
 
 --mttr記錄資訊
***************************************************************************
MTTR RECORDS
***************************************************************************
 (size = 100, compat size = 100, section max = 8, section in-use = 1,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 157, numrecs = 8)
MTTR record for thread 1
MTTR statistics status: 1
Init time: Avg: 13861292 us, Times measured: 4
File open time: Avg: 296 us, Times measured: 16
Log block read time: Avg: 20 us, Times measured: 65536
Data block read/claim time: Avg: 170 us, Times measured: 1000
Data block write time: Avg: 390 us
1000 change vector apply time: Avg: 0 us, Times measured: 1
Ratio Information:
# of log blocks measured: 346997
# of data blocks measured: 756
# of change vectors measured: 4892
 
 
 
 --備用資料庫對映記錄資訊
***************************************************************************
STANDBY DATABASE MAP RECORDS
***************************************************************************
 (size = 400, compat size = 400, section max = 10, section in-use = 10,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 160, numrecs = 10)
 
 
 
 --還原點記錄資訊
***************************************************************************
RESTORE POINT RECORDS
***************************************************************************
 (size = 212, compat size = 212, section max = 2048, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 161, numrecs = 2048)
 
 
 
 --日誌檔案歷史記錄資訊
***************************************************************************
LOG FILE HISTORY RECORDS
***************************************************************************
 (size = 56, compat size = 56, section max = 292, section in-use = 13,
  last-recid= 13, old-recno = 1, last-recno = 13)
 (extent = 1, blkno = 94, numrecs = 292)
Earliest record: --最老的
 RECID #1 Recno 1 Record timestamp  08/13/10 22:02:09 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=2
  Low scn: 0x0000.00080634 08/13/10 17:44:12 Next scn: 0x0000.000876ed
Latest record: --最新的
 RECID #13 Recno 13 Record timestamp  08/18/10 11:46:29 Thread=1 Seq#=13 Link-Recid=12 kccic-Recid=2
  Low scn: 0x0000.000b10e9 08/17/10 12:11:19 Next scn: 0x0000.000b6231
 RECID #12 Recno 12 Record timestamp  08/17/10 12:11:19 Thread=1 Seq#=12 Link-Recid=11 kccic-Recid=2
  Low scn: 0x0000.000b0d9c 08/17/10 12:01:15 Next scn: 0x0000.000b10e9
 RECID #11 Recno 11 Record timestamp  08/17/10 12:01:15 Thread=1 Seq#=11 Link-Recid=10 kccic-Recid=2
  Low scn: 0x0000.000b0bcb 08/17/10 11:54:59 Next scn: 0x0000.000b0d9c
 RECID #10 Recno 10 Record timestamp  08/17/10 11:54:59 Thread=1 Seq#=10 Link-Recid=9 kccic-Recid=2
  Low scn: 0x0000.000b073c 08/17/10 11:39:58 Next scn: 0x0000.000b0bcb
 RECID #9 Recno 9 Record timestamp  08/17/10 11:39:58 Thread=1 Seq#=9 Link-Recid=8 kccic-Recid=2
  Low scn: 0x0000.000b0496 08/17/10 11:38:00 Next scn: 0x0000.000b073c
 RECID #8 Recno 8 Record timestamp  08/17/10 11:38:00 Thread=1 Seq#=8 Link-Recid=7 kccic-Recid=2
  Low scn: 0x0000.000aaea8 08/16/10 17:44:50 Next scn: 0x0000.000b0496
 RECID #7 Recno 7 Record timestamp  08/16/10 17:44:50 Thread=1 Seq#=7 Link-Recid=6 kccic-Recid=2
  Low scn: 0x0000.000a54b5 08/16/10 12:13:40 Next scn: 0x0000.000aaea8
 RECID #6 Recno 6 Record timestamp  08/16/10 12:13:40 Thread=1 Seq#=6 Link-Recid=5 kccic-Recid=2
  Low scn: 0x0000.0009fd20 08/15/10 21:17:58 Next scn: 0x0000.000a54b5
 RECID #5 Recno 5 Record timestamp  08/15/10 21:17:58 Thread=1 Seq#=5 Link-Recid=4 kccic-Recid=2
  Low scn: 0x0000.00099964 08/15/10 13:01:54 Next scn: 0x0000.0009fd20
 RECID #4 Recno 4 Record timestamp  08/15/10 13:01:54 Thread=1 Seq#=4 Link-Recid=3 kccic-Recid=2
  Low scn: 0x0000.00094000 08/14/10 22:13:45 Next scn: 0x0000.00099964
 RECID #3 Recno 3 Record timestamp  08/14/10 22:13:45 Thread=1 Seq#=3 Link-Recid=2 kccic-Recid=2
  Low scn: 0x0000.0008db7f 08/14/10 13:59:10 Next scn: 0x0000.00094000
 RECID #2 Recno 2 Record timestamp  08/14/10 13:59:10 Thread=1 Seq#=2 Link-Recid=1 kccic-Recid=2
  Low scn: 0x0000.000876ed 08/13/10 22:02:09 Next scn: 0x0000.0008db7f
 RECID #1 Recno 1 Record timestamp  08/13/10 22:02:09 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=2
  Low scn: 0x0000.00080634 08/13/10 17:44:12 Next scn: 0x0000.000876ed
 
 
 
 --離線範圍
***************************************************************************
OFFLINE RANGE RECORDS
***************************************************************************
 (size = 200, compat size = 200, section max = 163, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 95, numrecs = 163)
 
 
 
 --歸檔日誌記錄資訊
***************************************************************************
ARCHIVED LOG RECORDS
***************************************************************************
 (size = 584, compat size = 584, section max = 28, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 97, numrecs = 28)
 
 
 
 --備份集記錄資訊
***************************************************************************
BACKUP SET RECORDS
***************************************************************************
 (size = 40, compat size = 40, section max = 409, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 98, numrecs = 409)
 
 
 
 --備份片記錄資訊
***************************************************************************
BACKUP PIECE RECORDS
***************************************************************************
 (size = 736, compat size = 736, section max = 200, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 99, numrecs = 200)
 
 
 
 --備份資料檔案記錄資訊
***************************************************************************
BACKUP DATAFILE RECORDS
***************************************************************************
 (size = 116, compat size = 116, section max = 282, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 108, numrecs = 282)
 
 
 
 --備份日誌記錄資訊
***************************************************************************
BACKUP LOG RECORDS
***************************************************************************
 (size = 76, compat size = 76, section max = 215, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 110, numrecs = 215)
 
 
 
 --資料檔案映象記錄資訊
***************************************************************************
DATAFILE COPY RECORDS
***************************************************************************
 (size = 660, compat size = 660, section max = 223, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 111, numrecs = 223)
 
 
 
 --備份資料檔案損壞記錄資訊
***************************************************************************
BACKUP DATAFILE CORRUPTION RECORDS
***************************************************************************
 (size = 44, compat size = 44, section max = 371, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 120, numrecs = 371)
 
 
 
 --資料檔案映象損壞記錄資訊
***************************************************************************
DATAFILE COPY CORRUPTION RECORDS
***************************************************************************
 (size = 40, compat size = 40, section max = 409, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 121, numrecs = 409)
 
 
 
 --刪除記錄資訊
***************************************************************************
DELETION RECORDS
***************************************************************************
 (size = 20, compat size = 20, section max = 818, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 122, numrecs = 818)
 
 
 
 --代理記錄資訊
***************************************************************************
PROXY COPY RECORDS
***************************************************************************
 (size = 852, compat size = 852, section max = 249, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 123, numrecs = 249)
 
 
 
 --化身（多版本）記錄資訊
***************************************************************************
INCARNATION RECORDS
***************************************************************************
 (size = 56, compat size = 56, section max = 292, section in-use = 2,
  last-recid= 2, old-recno = 1, last-recno = 2)
 (extent = 1, blkno = 138, numrecs = 292)
Earliest record:--最早的
 RECID #1 Recno 1 Record timestamp
  Resetlogs scn and time scn: 0x0000.00000001 10/22/05 21:44:08
  Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00
 Incarnation (parent inc#, flag)=(0, 0)
Latest record:--最新的
 RECID #2 Recno 2 Record timestamp
  Resetlogs scn and time scn: 0x0000.00080634 08/13/10 17:44:12
  Previous Resetlogs scn and time scn: 0x0000.00000001 10/22/05 21:44:08
 Incarnation (parent inc#, flag)=(1, 2)
 RECID #1 Recno 1 Record timestamp
  Resetlogs scn and time scn: 0x0000.00000001 10/22/05 21:44:08
  Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00
 Incarnation (parent inc#, flag)=(0, 0)
 
 
 
 --rman狀態記錄資訊
***************************************************************************
RMAN STATUS RECORDS
***************************************************************************
 (size = 116, compat size = 116, section max = 141, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 155, numrecs = 141)
 
 
 
 --資料檔案歷史記錄資訊
***************************************************************************
DATAFILE HISTORY RECORDS
***************************************************************************
 (size = 568, compat size = 568, section max = 57, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 158, numrecs = 57)
 
 
 
 --正常還原點記錄資訊
***************************************************************************
NORMAL RESTORE POINT RECORDS
***************************************************************************
 (size = 212, compat size = 212, section max = 2083, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 188, numrecs = 2083)
*** END OF DUMP ***

 

小結

控制檔案非常重要，它儲存了dbid,db name,建立日期，資料庫checkpoint,資料檔案的相關資訊（臨時檔案）,日誌檔案的相關資訊，
                 rman備份相關資訊,表空間相關資訊

alter tablespace begin|end backup;--在資料檔案記錄資訊對應部分的checkpoint scn會有變化(也就是這個動作會觸發一次增量檢查點）