所以此处的SCN就是:0x0000.001e6231;10进制SCN号为:1991217
RBA信息是:
struct kcvcprba, 12 bytes @500
ub4 kcrbaseq @500 0x0000006b --序号,
ub4 kcrbabno @504 0x00000002 --块号
ub2 kcrbabof @508 0x0010 --字节号
换算为十进制表示为:107号日志,2号块,16字节
与上一步DUMP数据文件信息得出的一致:
thread:1 rba:(0x6b.2.10)
--重做日志的地址0x6b.2.10---> 107号日志,第2号块,第16个字节
###################################################################
7.执行EVENT事件的语句,OPEN数据库后立刻DUMP控制文件
注意事项:要把EVENT事件的语句执行上,不然实验所需数据不连贯哈哈关于下面用到的10013/10015事件,分别是在Startup时跟踪事务恢复,在事务恢复后做Dump回退段头信息。
EVENT事件详见http://blog.csdn.net/q947817003/article/details/16359765
说明:--在这里用这两个语句不知道到底能不能DUMP出详细的REDO应用及回滚信息,从生成的TRACE文件来看有这方面信息,好像不太详细。。。
SYS@ bys3>alter session set events '10013 trace name context forever,level 1';
Session altered.
SYS@ bys3>alter session set events '10015 trace name context forever,level 1';
Session altered.
SYS@ bys3>alter database open;
Database altered.
SYS@ bys3>select value from v$diag_info where name like 'Default%';
VALUE
----------------------------------------------------------------------
/u01/diag/rdbms/bys3/bys3/trace/bys3_ora_1955.trc
另开一会话在OPEN数据库后立刻执行:
SYS@ bys3>alter session set events 'immediate trace name controlf level 12';
Session altered.
SYS@ bys3>select value from v$diag_info where name like 'Default%';
VALUE
------------------------------------------------------------------------------
/u01/diag/rdbms/bys3/bys3/trace/bys3_ora_2108.trc
##################################################################
8.分析OPEN时,通过ALERT日志查看的恢复过程--前滚
[oracle@bys3 ~]$ cat alert_bys3.logMon Dec 02 20:35:20 2013
alter database open
Started redo scan --开始扫描REDO日志
Completed redo scan --完成扫描REDO日志
read 202 KB redo, 104 data blocks need recovery --需要恢复的数据块104块,REDO日志202KB,按low cache rba--on disk rba来算是407-3=404个日志块,一个日志块大小是512字节,正好202KB。
Started redo application at
Thread 1: logseq 107, block 3 --这里可以看到,是从107号日志第3块开始应用REDO-与第3步中low cache rba:(0x6b.3.0)吻合
Recovery of Online Redo Log: Thread 1 Group 2 Seq 107 Reading mem 0
Mem# 0: /u01/oradata/bys3/redo02.log --所使用REDO日志文件,与第一步查询吻合。
Completed redo application of 0.16MB
Completed crash recovery at
Thread 1: logseq 107, block 407, scn 2011565 --完成实例恢复的位置,与第3步中on disk rba:(0x6b.197.0)吻合
104 data blocks read, 104 data blocks written, 202 redo k-bytes read --实例恢复涉及信息统计
Mon Dec 02 20:35:20 2013
LGWR: STARTING ARCH PROCESSES ----可以看到 实例恢复完成后,ARCH进程启动
Mon Dec 02 20:35:21 2013
ARC0 started with pid=19, OS id=2112
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Thread 1 advanced to log sequence 108 (thread open)
Thread 1 opened at log sequence 108
Current log# 3 seq# 108 mem# 0: /u01/oradata/bys3/redo03.log
Successful open of redo thread 1 ----可以看到 实例恢复完成后,REDO日志启动
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Dec 02 20:35:22 2013
SMON: enabling cache recovery
Mon Dec 02 20:35:22 2013
ARC1 started with pid=20, OS id=2116
Mon Dec 02 20:35:22 2013
ARC2 started with pid=21, OS id=2122
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Mon Dec 02 20:35:23 2013
ARC3 started with pid=22, OS id=2126
还有段ALERT日志涉及回滚放在下一小节
#################################