Oracle RBA(Redo Byte Address) 说明

zyifw7132i

　　
一. RBA 说明
　　之前整理了一个rdba和dba 的说明文档，参考：
　　Oracle rdba和 dba 说明
　　http://blog.csdn.net/tianlesoftware/article/details/6529346
　　
　　 在MOS的文档：Question About RBA (Redo Block Address) [ID 759966.1] 有对RBA的说明。
　　
　　A"Redo Block Address" (RBA) describes a physical location within aredo log file.
　　
　　RBA 由以下三部分组成：
　　（1）the log file sequence number (4 bytes)
　　（2）the log file block number (4 bytes)
　　（3）the byte offset into the block at which the redo record starts (2bytes)
　　
　　如：RBA[0x19.2.10] 代表 Log squence25, Block number 2 with byte offset 16.
　　注意这里的格式：都是16进行。
　　
　　Redo 与checkpoint 关系很大，当设置log_checkpoints_to_alert 参数为true后，checkpoint 发生时会写入alert log里。
　　
　　如：
　　SYS@dave2(db2)>alter system set log_checkpoints_to_alert=true scope=both;
　　System altered.
　　SYS@dave2(db2)> alter system switchlogfile;
　　System altered.
　　
　　log里的信息如下：
　　Thu Aug 18 18:46:18 2011
　　ALTER SYSTEM SETlog_checkpoints_to_alert=TRUE SCOPE=BOTH;
　　Thu Aug 18 18:48:07 2011
　　Beginning log switch checkpoint up to RBA[0xa.2.10], SCN: 2148380730
　　Thread 1 advanced to log sequence 10
　　Current log# 3 seq# 10 mem# 0: /u01/app/oracle/oradata/dave2/redo03.log
　　Thu Aug 18 18:52:54 2011
　　Completed checkpoint up to RBA [0xa.2.10],SCN: 2148380730
　　Thu Aug 18 19:08:59 2011
　　Incremental checkpoint up to RBA[0xa.736.0], current log tail at RBA [0xa.80a.0]
　　Thu Aug 18 19:39:01 2011
　　Incremental checkpoint up to RBA[0xa.c96.0], current log tail at RBA [0xa.d7c.0]
　　....
　　Fri Aug 19 07:10:00 2011
　　Incremental checkpoint up to RBA[0xa.1688a.0], current log tail at RBA [0xb.8328.0]
　　Fri Aug 19 07:11:04 2011
　　Completed checkpoint up to RBA [0xb.2.10],SCN: 2148412930
　　Fri Aug 19 07:40:02 2011
　　Incremental checkpoint up to RBA[0xb.896c.0], current log tail at RBA [0xb.89c1.0]
　　
　　
　　根据我们前面的说明，RBA 由三部分组成，第一部分是sequence number，即序列号。
　　
　　在我们贴出来的log里有2个日志序列：RBA [0xa.1688a.0] 和 RBA [0xb.896c.0]。
　　SYS@dave2(db2)> select to_number('a','xx')from dual;
　　
　　TO_NUMBER('A','XX')
　　-------------------
　　10
　　
　　SYS@dave2(db2)> selectto_number('b','xxx') from dual;
　　
　　TO_NUMBER('B','XXX')
　　--------------------
　　11
　　
　　a 对应的是日志序列10，b 对应的是日志序列11.
　　
　　SYS@dave2(db2)> select sequence# fromv$archived_log;
　　
　　SEQUENCE#
　　----------
　　1
　　2
　　3
　　4
　　5
　　6
　　7
　　8
　　9
　　10
　　
　　SYS@dave2(db2)> select sequence#,group#,status from v$log;
　　
　　SEQUENCE#GROUP# STATUS
　　---------- ---------- ----------------
　　11 1 CURRENT
　　9 2 INACTIVE
　　10 3 INACTIVE
　　
　　根据这个查询结果判断10是已经归档的，11是正在使用的current redo log file。
　　
　　第二部分就是我们对应的block：
　　SYS@dave2(db2)> selectto_number('1688a','xxxxxxxxx') from dual;
　　
　　TO_NUMBER('1688A','XXXXXXXXX')
　　------------------------------
　　92298
　　
　　在之前的blog：
　　Oracle Dump Redo Log File 说明
　　http://blog.csdn.net/tianlesoftware/article/details/6670962
　　
　　里提到，可以根据RBA 来dump redo block：
　　
　　格式如下：
　　ALTER SYSTEM DUMP LOGFILE 'filename' RBAMIN seqno .blockno RBA MAX seqno . blockno;
　　
　　示例：
　　SYS@anqing1(rac1)> alter system dumplogfile'+data/anqing/onlinelog/redo02.log' rbamin 121 10458 rba max125 10472;
　　System altered.
　　
　　这里的参数：seqno .blockno; 就是我们RBA中的前2部分。
　　
二. RBA 使用
　　RBAs are not necessarily unique within their thread, because the log file sequencenumber may be reset to 1 in all threads if a database is opened with theRESETLOGS option.
　　
RBAs are used in the following important ways.
　　With respect to a dirty block in thebuffer cache, thelow RBAis theaddress of the redo for the first change that was applied to the block since itwas last clean, and thehigh RBAis the address of the redo for the most recent change to have been applied to theblock.
　　
　　Dirty buffers are maintained on the buffer cache checkpoint queues in low RBA order. Thecheckpoint RBAis the point up to which DBWn has written buffers from thecheckpoint queues if incremental checkpointing is enabled -- otherwise it isthe RBA of last full thread checkpoint.
　　
　　 The checkpoint RBA is copied into the checkpoint progress record of the controlfile by the checkpoint heartbeat once every 3 seconds. In stance recovery, when needed, begins from the checkpoint RBA recorded in thecontrolfile.
　　
　　Thetarget RBAis the point up to which DBWnshould seek to advance the checkpoint RBA to satisfy instance recovery objectives.
　　
　　 Theon-disk RBAis the point up to which LGWR has flushed the redo thread to the online log files. DBWn may not write ablock for which the high RBA is beyond the on-disk RBA. Otherwise transactionrecovery (rollback) would not be possible, because the redo needed to undo achange is always in the same redo record as the redo for the change itself.
　　
　　The termsync RBAis sometimes used to referto the point up to which LGWR is required to sync the thread. However, this isnot a full RBA -- only a redo block number is used at this point.
　　
　　在上面提到的几种RBA 值可以通过X$BH,和 X$KCCRT 视图进行查看：
　　The low and high RBAs for dirty buffers can be seen in X$BH.(There is also arecovery RBAwhich is used to record the progress ofpartial block recovery by PMON.)
　　The incremental checkpoint RBA, the target RBA and theon-disk RBA can all be seen in X$TARGETRBA. The incremental checkpointRBA and the on-disk RBA can also be seen in X$KCCCP.
　　The full thread checkpoint RBA can be seen in X$KCCRT.
　　
　　
　　
　　
　　
　　-------------------------------------------------------------------------------------------------------
　　Blog： http://blog.csdn.net/tianlesoftware
　　Weibo: http://weibo.com/tianlesoftware
　　Email: dvd.dba@gmail.com
　　DBA1 群：62697716(满); DBA2 群：62697977(满)DBA3 群：62697850(满)
　　DBA 超级群：63306533(满); DBA4 群： 83829929(满)DBA5群： 142216823(满)
　　DBA6 群：158654907(满) 聊天 群：40132017(满) 聊天2群：69087192(满)
　　--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请