1、数据库打开之后。
SQL>alter database open;
2260 redo blocks read, 337 data blocks need recovery
Started redo application at
Thread 1: logseq 24, block 50041
Recovery of Online Redo Log: Thread 1 Group 3 Seq 24 Reading mem 0
Mem# 0: F:\APP\JOHN\ORADATA\ORCL\REDO03.LOG
Completed redo application of 0.78MB
Completed crash recovery at
Thread 1: logseq 24, block 52301, scn 1177590
337 data blocks read, 337 data blocks written, 2260 redo blocks read
2、Instance Recovery = Cache Recovery + Transaction Recovery
3、两个参数的含义以及作用
fast-start on-demand rollback:在11g 产品中不包含该参数。含义:Oracle 自动允许在数据库打开之后开始新的事务,这通常只需要很短的Cache Recovery 时间 。
fast-start parallel rollback:控制并行回滚。
LOW:限制恢复进程不能超过2倍的CPU_COUNT。