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會有變化(也就是這個動作會觸發一次增量檢查點）
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9240380/viewspace-671290/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- [20190522]How to get dump or list parameters set at session level.txtSession
- Django Mysql SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTEDDjangoMySqlSessionMIT
- Oracle session traceOracleSession
- alter system set event和set events的區別
- Laravel - Session store not set on requestLaravelSession
- Session store not set on request.Session
- [20210114]理解DBMS_SESSION.set_identifier.txtSessionIDE
- 使用dbms_monitor.session_trace_enable跟蹤一個會話Session會話
- SAP CRM One Order跟蹤和日誌工具CRMD_TRACE_SET
- set names utf8;
- [20210426]execute immediate.txt
- Oracle不同版本檢視資料庫session/system級別設定了哪些eventsOracle資料庫Session
- 使用req.session.xxx時出現 Cannot set property ‘xxxx‘ of undefinedSessionUndefined
- EXECUTE IMMEDIATE 儲存過程中 許可權不足及EXECUTE IMMEDIATE的除錯避坑儲存過程除錯
- SQL TraceSQL
- ORACLE EVENTS(轉)Oracle
- Level Up
- Oracle RAC Wait EventsOracleAI
- 7.81 DUMP
- 高通進dump和抓取解析dump log
- jacoco + ant 如何從 k8s 容器 dump 出 exec 檔案K8S
- DBMS_TRACE(zt)
- Oracle 10046 SQL TRACEOracleSQL
- Oracle Enqueues Wait Events 二OracleENQAI
- Oracle Enqueues Wait Events 一OracleENQAI
- Oracle Enqueues Wait Events 三OracleENQAI
- efcore 新特性 SaveChanges Events
- pointer-events屬性
- 記一次kafka的high level和low levelKafka
- 在k8s中收集jvm異常dump檔案到OSSK8SJVM
- WPF筆記3——x:Name 與 Name筆記
- MyISAM DEFAULT CHARACTER SET utf8 提示匯入錯誤
- Oracle修改instance_name、db_name、db_unique_name、service_namesOracle
- natas(level0-level14)通關詳細指南(一)
- Android Framework： 增加trace點AndroidFramework
- E. Level Up
- E - Level K Palindrome
- CSS LEVEL4CSS
- Random Events CodeForces - 1461Crandom