Order of Oracle Instance recoveries

With alert, the order in which the instance was recovered was found:

1. Roll forward

2, open db

3, Rollback (Note: smon:parallel Transaction recovery tried

After Completed:alter DATABASE OPEN

Smon:enabling Cache Recovery

Mon June 13 16:50:50 2011

Successfully onlined Undo tablespace 1.

Mon June 13 16:50:50 2011

smon:enabling TX Recovery

Mon June 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 June 13 16:50:59 2011

Completed:alter DATABASE OPEN

Mon June 13 16:51:00 2011

Smon:parallel Transaction Recovery tried

Mon June 13 16:51:01 2011

Shutting down instance (abort)

License High Water mark = 15

Instance terminated by USER, PID = 1828

Mon June 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 =

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

This article URL address: http://www.bianceng.cn/database/Oracle/201410/45561.htm