启动阶段日志:
TTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Apr 09 00:38:31 2014
SMON: enabling cache recovery
Wed Apr 09 00:39:38 2014
minact-scn: Inst 2 is a slave inc#:40 mmon proc-id:10825 status:0x2
minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.00000000 gcalc-scn:0x0000.00000000
Wed Apr 09 00:40:21 2014
Incremental checkpoint up to RBA [0x7.2.0], current log tail at RBA [0x7.4.0]
Wed Apr 09 00:42:51 2014
[10904] Successfully onlined Undo Tablespace 31.
Undo initialization finished serial:0 start:2098892120 end:2099085865 diff:193745 (1937 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
Wed Apr 09 00:42:51 2014
SMON: enabling tx recovery
Database Characterset is UTF8
Wed Apr 09 00:43:19 2014
No Resource Manager plan active
Wed Apr 09 00:44:33 2014
Starting background process GTX0
Wed Apr 09 00:44:33 2014
GTX0 started with pid=40, OS id=11149
Wed Apr 09 00:44:48 2014
Starting background process RCBG
Wed Apr 09 00:44:48 2014
RCBG started with pid=41, OS id=11153
Wed Apr 09 00:45:03 2014
replication_dependency_tracking turned off (no async multimaster replication found)
Wed Apr 09 00:48:56 2014
Starting background process QMNC
Wed Apr 09 00:48:56 2014
QMNC started with pid=39, OS id=11208
Wed Apr 09 00:59:09 2014
Completed: alter database open
参考文档:
New Background Processes In 11g (Îĵµ ID 444149.1) תµ½µ×²¿
--------------------------------------------------------------------------------
ÐÞ¸Äʱ¼ä:2013-12-6ÀàÐÍ:BULLETIN
In this Document
--------------------------------------------------------------------------------
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Oct-2010***
Purpose
This article provides information on new background processes introduced in 11g.
A complete list of background processes can be found in the Oracle Documentation:
http://docs.oracle.com/cd/E11882_01/server.112/e17110/bgprocesses.htm#sthref4453
Details
*
*
*
*
*
*
FBDA is also responsible for automatically managing the flashback data archive for space, organization, and retention and keeps track of how far the archiving of tracked transactions has occurred.
*
*
*
*
*
Some additional Processes not documented in 10G :
* PZ (PQ slaves used for global Views) are RAC Parallel Server Slave processes, but they are not normal parallel slave processes, PZnn processes (starting at 99) are used to query GV$ views which is done using Parallel Execution on all instances, if more than one PZ process is needed, then PZ98, PZ97,... (in that order) are created automatically.
* O00 (ASM slave processes) A group of slave processes establish connections to the ASM instance. Through this connection pool database processes can send messages to the ASM instance. For example opening a file sends the open request to the ASM instance via a slave. However slaves are not used for long running operations such as creating a file. The use slave (pool) connections eliminate the overhead of