2.3.12 数据库异常关闭的情况

 

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。