[收藏本方案]

解读Oracle 9201的控制文件[18]

[入库：2005年8月18日] [更新：2007年3月24日]

本文简介：选择自 lunar2000 的 blog
首页 上页 下页 尾页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] [22] [23] [24] [25] [26] [27] [28] [29] [30] [31] [32] [33] [34] [35] [36] [37] [38] [39] [40] [41] [42] [43] [44] [45] [46] [47] [48] [49] [50] [51] [52] [53] [54] [55] [56] [57] [58] [59] [60] [61] [62] [63] [64] [65] [66] [67] [68] [69] [70] [71] [72] [73] [74] [75] [76] [77] [78] [79] [80] [81] [82] [83] [84] [85] [86] [87] [88] [89] [90] [91] [92] [93] [94] [95] [96] [97]

85.  siz: 0xf000 seq: 0x0000001e hws: 0x6 bsz: 512 nab: 0x15b flg: 0x1 dup: 1

nab是日志文件中lgwr可用的下一个数据块的地址，如果这个值是无穷大，说明这个日志文件是当前（lgwr正在写入）的日志文件

 

86.  archive links: fwrd: 0 back: 0 prev scn: 0x0000.04b8b9ad

 

 

87.  low scn: 0x0000.04b93016 05/13/2004 16:31:24

日志发生切换时会分配一个低scn和一个高scn，低scn就是上一个日志的高scn的值，而高scn则设置为无穷大，直到切换到下一个日志文件时，再将当前日志的高scn设置为下一个日志文件的低scn，将下一个日志文件的高scn设置为无穷大。

 

88.  next scn: 0x0000.04b9870a 05/13/2004 19:43:45

日志发生切换后，高scn就从无穷大该为next scn（下一个scn）的值，该值将作为切换后的日志文件的低scn

 

89.log file #2:

90.  (name #4) e:\oracle\ora92\test\redo02.log

首页 上页 下页 尾页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] [22] [23] [24] [25] [26] [27] [28] [29] [30] [31] [32] [33] [34] [35] [36] [37] [38] [39] [40] [41] [42] [43] [44] [45] [46] [47] [48] [49] [50] [51] [52] [53] [54] [55] [56] [57] [58] [59] [60] [61] [62] [63] [64] [65] [66] [67] [68] [69] [70] [71] [72] [73] [74] [75] [76] [77] [78] [79] [80] [81] [82] [83] [84] [85] [86] [87] [88] [89] [90] [91] [92] [93] [94] [95] [96] [97]
本文关键：解读Oracle 9201的控制文件
　　相关方案
Google
 

本站最佳浏览方式为 分辨率 1024x768 IE 6.0（或更高版本的 IE浏览器）

go top