控制文件内容

aaaaaaaa2000

版主你好：
想问一下dump出控制文件之后有一下疑惑的点
***************************************************************************
4 REDO THREAD RECORDS
***************************************************************************
(size = 256, compat size = 256, section max = 1, section in-use = 1,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 5, numrecs = 1)
THREAD #1 - status:0xbf thread links forward:0 back:0
#logs:3 first:1 last:3 current:1 last used seq#:0x4
enabled at scn: 0x0000.00099829 11/02/2008 00:58:37
disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
opened at 11/15/2008 13:15:14 by instance ora10g
Checkpointed at scn: 0x0000.000ae5a4 11/15/2008 13:15:14
thread:1 rba:(0x4.1a723.10)---------------------------------这里面的checkpoint是undo的表空间的checkpoint吗？

aaaaaaaa2000

这是在看一个回复案例的时候，说通过看redo THREAD RECORDS 中的rba与system中的rba得到undo表空间需要回复
但是为什么控制文件的 THREAD RECORDS指的是undo表空间？

Maclean Liu(刘相兵

ODM TEST:


SQL> oradebug setmypid;
Statement processed.
SQL> oradebug dump file_hdrs 3;
Statement processed.
SQL> oradebug tracefile_name;
/s01/admin/G10R21/udump/g10r21_ora_6057.trc

Tablespace #0 - SYSTEM  rel_fn:1
Creation   at   scn: 0x0000.00000008 10/22/2005 21:44:31
Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0
reset logs count:0x2e54edf3 scn: 0x0000.00e239e8 reset logs terminal rcv data:0x0 scn: 0x0000.00000000
prev reset logs count:0x2e54e476 scn: 0x0000.00e14b4d prev reset logs terminal rcv data:0x0 scn: 0x0000.00000000
recovered at 03/07/2012 17:40:51
status:0x2004 root dba:0x00400179 chkpt cnt: 2242 ctl cnt:2241
begin-hot-backup file size: 0
Checkpointed at scn:  0x0000.00e2d7ed 03/07/2012 17:40:50
thread:1 rba:(0x3.2.10)


Tablespace #1 - UNDOTBS1  rel_fn:2
Creation   at   scn: 0x0000.0007fd42 10/22/2005 22:24:27
Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0
reset logs count:0x2e54edf3 scn: 0x0000.00e239e8 reset logs terminal rcv data:0x0 scn: 0x0000.00000000
prev reset logs count:0x2e54e476 scn: 0x0000.00e14b4d prev reset logs terminal rcv data:0x0 scn: 0x0000.00000000
recovered at 03/07/2012 17:40:51
status:0x4 root dba:0x00000000 chkpt cnt: 2201 ctl cnt:2200
begin-hot-backup file size: 0
Checkpointed at scn:  0x0000.00e2d7ed 03/07/2012 17:40:50
thread:1 rba:(0x3.2.10)

***************************************************************************
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:3 last used seq#:0x3
enabled at scn: 0x0000.00e239e8 03/07/2012 17:37:55
disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
opened at 03/07/2012 17:40:50 by instance G10R21
Checkpointed at scn:  0x0000.00e2d7ed 03/07/2012 17:40:50
thread:1 rba:(0x3.2.10)

REDO THREAD中的 记录了 FULL checkpoint 对应的 rba

A “Redo Block Address” (RBA) describes a physical location within a redo log file. An RBA consists of the following:

Log sequence number
Block number within log file
Byte offset within block

The structure of the redo block address is given below :
1 – The number of the redo log.
[4 bytes]

2 – The block offset from the beginning of the redo log file.
[4 bytes]

3 – The byte offset within the block.
[2 bytes]

rba:(0x3.2.10)  即   redo log 3 block 2

Maclean Liu(刘相兵

"为什么控制文件的 THREAD RECORDS指的是undo表空间？"

不理解你的这句话