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

最新推荐文章于 2024-05-04 09:38:05 发布
最新推荐文章于 2024-05-04 09:38:05 发布
阅读量114 收藏
点赞数
文章标签： 数据库

--用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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-671290/

clg10051
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
drupal使用hook_form_alter()修改表单实例
09-28
主要为大家介绍了drupal使用hook_form_alter()修改表单的实现方法,包括了修改多个表单与修改特定的表单,非常实用,需要的朋友可以参考下
alter session set events 'immediate trace name controlf level 8'
csnd32068的博客
05-04 338
控制文件的重要性不用多说，就像是数据库的神经系统，学习的过程中，深入分析控制文件很有必要，下面只是贴出dump文件，后面的部分文章会结合这部分来说明，希望大家能深入研究： SQL> select * from v$ver...
oracle限定词,ORACLE诊断事件
weixin_33971721的博客
04-03 849
ORACLE诊断事件Oracle为RDBMS提供了多种的诊断工具，诊断事件(Event)是其中一种常用、好用的方法，它使DBA可以方便的转储数据库各种结构及跟踪特定事件的发生.一、Event的通常格式及分类1、通常格式如下：EVENT=""2、Event分类诊断事件大体上可以分为四类：a．转储类事件：它们主要用于转储Oracle的一些结构，例如转储一下控制文件、数据文件头等内容。b．...
ALTER SESSION SET EVENTS 'immediate trace name controlf level 3';
疯狂的石头
11-23 1340
有些同学不知道如何查看自己的trace的相关信息，下面是我的做的相关实验的一部分！环境是win的，unix上的同样只是路径不同罢了！路径在：E:\oracle\product\10.2.0\admin\orcl\udump 内容如下： Dump file e:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_3996.trc Fri Nov 1
alter session set events语句dump REDO日志文件头信息示例
还不算晕的专栏
11-17 2295
alter session set events 'immediate trace name redohdr level 1';语句简介 1 控制文件中的redo log信息--不包含DBID信息，只是显示控制文件中各REDO LOG FILE的相关信息 2 level 1 + 文件头信息  --包含有LVEEL的信息，并包含有REDO文件头的信息-包含DBID相关信息 3 level 2
Oracle常用dump命令，记录一下备查。
01-19
1 包含PGA 2 包含SGA 4 包含UGA 8 包含indrect memory 2).Library Cache ALTER SESSION SET EVENTS ‘immediate trace name library_cache level n’; 1 library cache统计信息 2 包含hash ...
drupal之hook_link和hook_link_alter钩子函数解析
09-28
主要为大家介绍了drupal中hook_link和hook_link_alter钩子函数,实例分析了钩子函数的具体用法,具有一定的参考借鉴价值,需要的朋友可以参考下
对于oracle对session进行跟踪的分析
12-15
跟踪 session 的活动，Oracle 提供了很多种手段，不仅可以对当前连接的 session 进行跟踪...alter session set sql_trace=true/false 对任意的 session 进行跟踪及停止跟踪： exec dbms_system.set_sql_trace_in_sessi
sm4算法.rar_ALTER_SM4算法_Xilinx_sm4算法verilog_verilog sm4
07-15
verilog实现的SM4算法源码，初学者可以借鉴，在xilinx和Quartus上都可运行使用！
alter session set events 详解
jlds123的专栏
04-01 4448
一、Oracle跟踪文件     Oracle跟踪文件分为三种类型，一种是后台报警日志文件，记录数据库在启动、关闭和运行期间后台进程的活动情况,如表空间创建、回滚段创建、某些alter命令、日志切换、错误消息等。在数据库出现故障时，应首先查看该文件，但文件中的信息与任何错误状态没有必然的联系。后台报警日志文件保存BACKGROUND_DUMP_DEST参数指定的目录中，文件格式为SIDALRT.
alter system set events相关知识(转帖)
cuijue6546的博客
03-28 288
alter system set events相关知识： 格式：alter system|session set events ‘[eventnumber|immediate] trace name eventname [for...
对alter session set events语句基本意思的说明
haiross的专栏
09-12 5684
C:\Windows\System32>sqlplus / as sysdba   SQL*Plus: Release 11.2.0.1.0 Production on 星期五 4月 18 16:53:172014   Copyright (c) 1982, 2010, Oracle.  All rights reserved.     连接到: Oracle Database 1
temp ts暴涨的分析
cipo0750的博客
05-17 162
关于消除temp ts暴涨的方法经常有人问temp表空间暴涨的问题,以及如何回收临时表空间,由于版本的不同,方法显然也多种多样,但这些方法显示是治标不治本的办法,只有深刻理解temp表空间快速增加的原因,才能从根本上解决temp...
转储控制文件
Database、Code
11-10 2579
转储控制文件： 方法一： alter session set events 'immediate trace name controlf level 8'; level表示级别 --level1 仅包含文件头信息 --level2 包括文件头，数据库信息记录，检查点进程记录 --level3 所有记录类型，针对循环重用的记录类型仅保留最早及最近的记录 --level4  如上，
alter session set events语句dump 控制文件头信息示例
还不算晕的专栏
11-17 2344
alter session set events 'immediate trace name controlf level 1';中level n的意义如下： 1 控制文件中的文件头信息 2 level 1 + 文件头信息 3 level 2 + 数据文件头信息 10 level 3 更详细的alter session set events--oracle -Oracle跟踪事件简介见h
alter session set events /Oracle跟踪
congpiqu8186的博客
09-05 197
一、Oracle跟踪文件 Oracle跟踪文件分为三种类型，一种是后台报警日志文件，记录数据库在启动、关闭和运行期间后台进程的活动情况,如表空间创建、回滚段创建、某些alter命令、日志切换、错误消息等。在数据库出现故...
Redis 实战之压缩列表
最新发布
奔走的蚂蚁的博客
05-04 1016
压缩列表是一种为节约内存而开发的顺序型数据结构。压缩列表被用作列表键和哈希键的底层实现之一。压缩列表可以包含多个节点，每个节点可以保存一个字节数组或者整数值。添加新节点到压缩列表， 或者从压缩列表中删除节点， 可能会引发连锁更新操作， 但这种操作出现的几率并不高。
java线上问题排查之磁盘和网络查看分析（二）
wayne_youlu的博客
04-30 540
overflowed 标识全连接队列溢出的次数,最前面是0，标识没有队列溢出的情况，网络环境正常。来查看网络是否连接。如果出现下图内容，则证明网络已经连接。
alter session set events 'immediate trace name controlf level 1';
08-31
The command "alter session set events 'immediate trace name controlf level 1'" is an Oracle database command that generates a trace file for the current database session. The trace file contains ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值