Starting Order Of Mandatory Background Process In Oracle Database 12cR2

Published by Ahmad on

Starting Order Of Mandatory Background Process In Oracle Database 12cR2-:

Starting Order Of Mandatory Background Process In Oracle Database 12cR2-:

1-PMON

2-CLMN

3-MMAN

4-PMAN

5-DBWR

6-LGWR

7-CKPT

8-SMON

9-RECO

10-LREG

11-MMON

12-MMNL

You can check the order in Alert Lg File

============================================================
Starting background process PMON----------------------PMON-1
2018-11-19T09:53:01.153343+05:30
PMON started with pid=2, OS id=4297 
Starting background process CLMN----------------------CLMN-2
2018-11-19T09:53:01.368738+05:30
CLMN started with pid=3, OS id=4299 
2018-11-19T09:53:01.390566+05:30
Starting background process PSP0
Starting background process VKTM
2018-11-19T09:53:01.614470+05:30
PSP0 started with pid=4, OS id=4301 
2018-11-19T09:53:02.929527+05:30
Starting background process GEN0
2018-11-19T09:53:02.931098+05:30
VKTM started with pid=5, OS id=4303 at elevated (RT) priority
2018-11-19T09:53:02.967465+05:30
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Starting background process MMAN---------------------MMAN-3
2018-11-19T09:53:03.142663+05:30
GEN0 started with pid=6, OS id=4307 
2018-11-19T09:53:03.351399+05:30
MMAN started with pid=7, OS id=4309 
Starting background process GEN1
2018-11-19T09:53:04.110330+05:30
Starting background process DIAG
2018-11-19T09:53:04.113454+05:30
GEN1 started with pid=9, OS id=4313_4315 
Starting background process OFSD
2018-11-19T09:53:04.470304+05:30
DIAG started with pid=11, OS id=4317 
Starting background process DBRM
2018-11-19T09:53:04.799919+05:30
OFSD started with pid=12, OS id=4319_4321 
2018-11-19T09:53:04.806236+05:30
Oracle running with ofslib:'Oracle File Server Library' version=2
Starting background process VKRM
2018-11-19T09:53:05.078024+05:30
DBRM started with pid=14, OS id=4323 
2018-11-19T09:53:05.347056+05:30
Starting background process SVCB
2018-11-19T09:53:05.351857+05:30
VKRM started with pid=15, OS id=4325 
Starting background process PMAN------------------------PMAN--4
2018-11-19T09:53:05.652679+05:30
SVCB started with pid=16, OS id=4327 
Starting background process DIA0
2018-11-19T09:53:05.946719+05:30
PMAN started with pid=17, OS id=4329 
Starting background process DBW0------------------------DBWR--5
2018-11-19T09:53:06.208841+05:30
DIA0 started with pid=18, OS id=4331 
2018-11-19T09:53:06.645028+05:30
Starting background process LGWR-------------------------LGWR--6
2018-11-19T09:53:06.651434+05:30
DBW0 started with pid=19, OS id=4333 
Starting background process CKPT-------------------------CKPT--7
2018-11-19T09:53:06.952607+05:30
LGWR started with pid=20, OS id=4335 
2018-11-19T09:53:07.224388+05:30
CKPT started with pid=21, OS id=4337 
2018-11-19T09:53:07.508454+05:30
LGWR slave LG00 created with pid=22, OS pid=4339
Starting background process SMON-------------------------SMON--8
2018-11-19T09:53:07.816204+05:30
SMON started with pid=23, OS id=4341 
2018-11-19T09:53:08.159084+05:30
Starting background process SMCO
2018-11-19T09:53:08.160502+05:30
LGWR slave LG01 created with pid=24, OS pid=4343
2018-11-19T09:53:08.214385+05:30
WARNING: pga_aggregate_limit value is too high for the
amount of physical memory on the system
PGA_AGGREGATE_LIMIT is 2048 MB
PGA_AGGREGATE_TARGET is 0 MB.
physical memory size is 2194 MB
limit based on physical memory and SGA usage is 1974 MB
MEMORY_MAX_TARGET is 1120 MB
Using default pga_aggregate_limit of 2048 MB
Starting background process RECO---------------------------RECO-9
2018-11-19T09:53:08.456505+05:30
SMCO started with pid=25, OS id=4345 
2018-11-19T09:53:08.817944+05:30
RECO started with pid=26, OS id=4347 
Starting background process LREG--------------------------LREG-10
2018-11-19T09:53:09.448334+05:30
LREG started with pid=28, OS id=4351 
2018-11-19T09:53:09.833863+05:30
Starting background process PXMN
Starting background process FENC
2018-11-19T09:53:10.246039+05:30
PXMN started with pid=30, OS id=4355 
Starting background process MMON--------------------------MMON-11
2018-11-19T09:53:10.654939+05:30
FENC started with pid=31, OS id=4357 
2018-11-19T09:53:11.102671+05:30
Starting background process MMNL-------------------------MMNL--12
2018-11-19T09:53:11.103411+05:30
MMON started with pid=32, OS id=4359 
2018-11-19T09:53:11.364196+05:30
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
2018-11-19T09:53:11.366835+05:30
MMNL started with pid=8, OS id=4361 
starting up 1 shared server(s) ...
Starting background process TMON
ORACLE_BASE from environment = /u01/app/oracle
2018-11-19T09:53:12.035123+05:30
TMON started with pid=34, OS id=4367 
2018-11-19T09:53:13.013767+05:30
ALTER DATABASE MOUNT
2018-11-19T09:53:17.270519+05:30
Network throttle feature is disabled as mount time

2018-11-19T09:53:17.317064+05:30
Successful mount of redo thread 1, with mount id 1520343177
2018-11-19T09:53:17.318368+05:30
Database mounted in Exclusive Mode
Lost write protection disabled
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
Completed: ALTER DATABASE MOUNT
2018-11-19T09:53:18.041701+05:30
ALTER DATABASE OPEN
Ping without log force is disabled:
instance mounted in exclusive mode.
2018-11-19T09:53:18.243102+05:30
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
2018-11-19T09:53:18.898657+05:30
Started redo scan
2018-11-19T09:53:19.241484+05:30
Completed redo scan
read 3 KB redo, 6 data blocks need recovery
2018-11-19T09:53:19.366373+05:30
Started redo application at
Thread 1: logseq 12, block 1889, offset 0
2018-11-19T09:53:19.367780+05:30
Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0
Mem# 0: /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_3_fxzr5vtw_.log
Mem# 1: /u01/app/oracle/fast_recovery_area/orcl/ORCL/onlinelog/o1_mf_3_fxzr6cj3_.log
2018-11-19T09:53:19.369120+05:30
Completed redo application of 0.00MB
2018-11-19T09:53:19.499708+05:30
Completed crash recovery at
Thread 1: RBA 12.1896.16, nab 1896, scn 0x000000000026c171
6 data blocks read, 6 data blocks written, 3 redo k-bytes read
Endian type of dictionary set to little
2018-11-19T09:53:19.802891+05:30
Thread 1 advanced to log sequence 13 (thread open)
2018-11-19T09:53:19.854646+05:30
TT00: Gap Manager starting (PID:4379)
2018-11-19T09:53:20.489240+05:30
Thread 1 opened at log sequence 13
Current log# 1 seq# 13 mem# 0: /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_1_fxzr5fhn_.log
Current log# 1 seq# 13 mem# 1: /u01/app/oracle/fast_recovery_area/orcl/ORCL/onlinelog/o1_mf_1_fxzr5mh8_.log
Successful open of redo thread 1
2018-11-19T09:53:20.496312+05:30
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
2018-11-19T09:53:22.713961+05:30
[4373] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:355920 end:356795 diff:875 ms (0.9 seconds)
Verifying minimum file header compatibility for tablespace encryption..
Verifying file header compatibility for tablespace encryption completed for pdb 0
Database Characterset is AL32UTF8
No Resource Manager plan active
2018-11-19T09:53:26.105885+05:30
replication_dependency_tracking turned off (no async multimaster replication found)
2018-11-19T09:53:27.446008+05:30
Starting background process AQPC
2018-11-19T09:53:27.662418+05:30
AQPC started with pid=41, OS id=4385 
2018-11-19T09:53:32.660922+05:30
Starting background process CJQ0
Completed: ALTER DATABASE OPEN
2018-11-19T09:53:32.923937+05:30
CJQ0 started with pid=49, OS id=4402 
2018-11-19T09:53:48.808496+05:30
===========================================================

Check regularly my post and give feedback & comments.

Thanks

Ahmad

(Oracle Consultant)

(OCE in 11gR2 RAC)

(OCP in 11gR2/10gR2/9iR2)


Categories: DatabaseOracle12c

4 Comments

Rashmeet · November 21, 2018 at 9:31 pm

Thanks for sharing this useful information….

Rakesh · November 28, 2018 at 7:04 am

Good one! Helped me.

Ishtiaque · December 5, 2018 at 9:05 am

Very useful info in short. Gained knowledge Thanks a lot.

Rauf · April 21, 2020 at 2:14 am

Good Article

Leave a Reply

Your email address will not be published. Required fields are marked *