通过alert仔细观查，发现实例恢复的顺序是：

1、前滚

2、open db

3、rollback（注意：SMON: Parallel transaction recovery tried

在Completed: ALTER DATABASE OPEN）之后

SMON: enabling cache recovery

Mon Jun 13 16:50:50 2011

Successfully onlined Undo Tablespace 1.

Mon Jun 13 16:50:50 2011

SMON: enabling tx recovery

Mon Jun 13 16:50:50 2011

Database Characterset is ZHS16GBK

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

QMNC started with pid=30, OS id=4588

Mon Jun 13 16:50:59 2011

Completed: ALTER DATABASE OPEN

Mon Jun 13 16:51:00 2011

SMON: Parallel transaction recovery tried

Mon Jun 13 16:51:01 2011


Shutting down instance (abort)

License high water mark = 15

Instance terminated by USER, pid = 1828

Mon Jun 13 16:50:37 2011

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on.

IMODE=BR

ILAT =24

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.1.0.

System parameters with non-default values:

processes = 200

sessions = 225

__shared_pool_size = 71303168

__large_pool_size = 4194304

__java_pool_size = 4194304

__streams_pool_size = 0

nls_language = SIMPLIFIED CHINESE

nls_territory = CHINA

sga_target = 167772160

control_files = G:ORADATATESTCONTROL01.CTL, G:ORADATATESTCONTROL02.CTL, G:ORADATATESTCONTROL03.CTL

db_block_size = 8192

__db_cache_size = 79691776

db_cache_size = 20971520

compatible = 10.2.0.1.0

db_file_multiblock_read_count= 16

db_recovery_file_dest = g:oracleproduct10.2.0flash_recovery_area

db_recovery_file_dest_size= 2147483648

undo_management = AUTO

undo_tablespace = UNDOTBS1

remote_login_passwordfile= EXCLUSIVE

db_domain =

job_queue_processes = 10

audit_file_dest = G:ORACLEPRODUCT10.2.0ADMINTESTADUMP

background_dump_dest = G:ORACLEPRODUCT10.2.0ADMINTESTBDUMP

user_dump_dest = G:ORACLEPRODUCT10.2.0ADMINTESTUDUMP

core_dump_dest = G:ORACLEPRODUCT10.2.0ADMINTESTCDUMP

db_name = test

open_cursors = 300

pga_aggregate_target = 41943040

PMON started with pid=2, OS id=5408

PSP0 started with pid=3, OS id=5780

MMAN started with pid=4, OS id=1908

DBW0 started with pid=5, OS id=4528

LGWR started with pid=6, OS id=784

CKPT started with pid=7, OS id=5960

SMON started with pid=8, OS id=5696

RECO started with pid=9, OS id=2292

CJQ0 started with pid=10, OS id=5324

MMON started with pid=11, OS id=4280

MMNL started with pid=12, OS id=5736

Mon Jun 13 16:50:37 2011

ALTER DATABASE MOUNT

Mon Jun 13 16:50:41 2011

Setting recovery target incarnation to 1

Mon Jun 13 16:50:41 2011

Successful mount of redo thread 1, with mount id 2051816925

Mon Jun 13 16:50:41 2011

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Mon Jun 13 16:50:41 2011

ALTER DATABASE OPEN

Mon Jun 13 16:50:42 2011

Beginning crash recovery of 1 threads

parallel recovery started with 7 processes

Mon Jun 13 16:50:42 2011

Started redo scan

Mon Jun 13 16:50:43 2011

Completed redo scan

148006 redo blocks read, 4677 data blocks need recovery

Mon Jun 13 16:50:44 2011

Started redo application at

Thread 1: logseq 13, block 28359

Mon Jun 13 16:50:44 2011

Recovery of Online Redo Log: Thread 1 Group 1 Seq 13 Reading mem 0

Mem# 0 errs 0: G:ORADATATESTREDO01.LOG

Mon Jun 13 16:50:45 2011

Recovery of Online Redo Log: Thread 1 Group 2 Seq 14 Reading mem 0

Mem# 0 errs 0: G:ORADATATESTREDO02.LOG

Mon Jun 13 16:50:47 2011

Buffer cache too small: 71 buffers remain in apply pass 2

Mon Jun 13 16:50:49 2011

Completed redo application

Mon Jun 13 16:50:49 2011

Completed crash recovery at

Thread 1: logseq 14, block 83964, scn 264909

4677 data blocks read, 4677 data blocks written, 148006 redo blocks read

Mon Jun 13 16:50:50 2011

Thread 1 advanced to log sequence 15

Thread 1 opened at log sequence 15

Current log# 3 seq# 15 mem# 0: G:ORADATATESTREDO03.LOG

Successful open of redo thread 1

Mon Jun 13 16:50:50 2011

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Mon Jun 13 16:50:50 2011

SMON: enabling cache recovery

Mon Jun 13 16:50:50 2011

Successfully onlined Undo Tablespace 1.

Mon Jun 13 16:50:50 2011

SMON: enabling tx recovery

Mon Jun 13 16:50:50 2011

Database Characterset is ZHS16GBK

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

QMNC started with pid=30, OS id=4588

Mon Jun 13 16:50:59 2011

Completed: ALTER DATABASE OPEN

Mon Jun 13 16:51:00 2011

SMON: Parallel transaction recovery tried

Mon Jun 13 16:51:01 2011

db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.



oracle视频教程请关注:http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html