STARTUP PHASES IN ORACLE DATABASE

STARTUP NOMOUNT;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
kIsH@Xhydra<>startup nomount;
ORACLE instance started.

Total System Global Area 1962932432 bytes
Fixed Size                  9136336 bytes
Variable Size            1325400064 bytes
Database Buffers          620756992 bytes
Redo Buffers                7639040 bytes
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Starting ORACLE instance (normal) (OS id: 5590)
2022-07-29T22:08:40.694182+05:30
****************************************************
 /dev/shm will be used for creating SGA                        <================================== Memory segments are allocated from OS for SGA
Large pages will not be used. Only standard 4K pages will be used
****************************************************
2022-07-29T22:08:40.697628+05:30
**********************************************************************
2022-07-29T22:08:40.697688+05:30
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

2022-07-29T22:08:40.697799+05:30
 Per process system memlock (soft) limit = 128G
2022-07-29T22:08:40.697850+05:30
 Expected per process system memlock (soft) limit to lock
 instance MAX SHARED GLOBAL AREA (SGA) into memory: 1872M
2022-07-29T22:08:40.697945+05:30
 Available system pagesizes:
  4K, 2048K
2022-07-29T22:08:40.698037+05:30
 Supported system pagesize(s):
2022-07-29T22:08:40.698086+05:30
  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)
2022-07-29T22:08:40.698137+05:30
        4K       Configured          479236          479236        NONE
2022-07-29T22:08:40.698186+05:30
 Reason for not supporting certain system pagesizes:
2022-07-29T22:08:40.698273+05:30
  2048K - Dynamic allocate and free memory regions
2022-07-29T22:08:40.698329+05:30
**********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 1                       <======================================== CPU allocation
Number of processor cores in the system is 1
Number of processor sockets in the system is 1
Capability Type : Network
capabilities requested : 7 detected : 0 Simulated : 0
Capability Type : Runtime Environment
capabilities requested : 400000FF detected : 40000000 Simulated : 0
Capability Type : Engineered Systems
capabilities requested : 7 detected : 0 Simulated : 0
Capability Type : Database Test
capabilities requested : 3 detected : 0 Simulated : 0
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Using default ASM root directory ASM
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Cluster configuration type = NONE [2]
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0.
ORACLE_HOME:    /u01/app/oracle/product/19.0.0/dbhome_1
System name:    Linux
Node name:      xhydra
Release:        5.4.17-2136.304.4.1.el8uek.x86_64
Version:        #2 SMP Tue Feb 8 11:54:24 PST 2022
Machine:        x86_64
Using parameter settings in server-side spfile /u01/app/oracle/product/19.0.0/dbhome_1/dbs/spfiledb9zx.ora   <<<<<<<<===================== Server Parameter file is read
System parameters with non-default values:
  processes                = 300
  nls_language             = "AMERICAN"
  nls_territory            = "AMERICA"
  sga_target               = 0
  memory_target            = 1872M
  control_files            = "/apps01/oradata/DB9ZX/controlfile/o1_mf_k8dcj42x_.ctl"
  control_files            = "/apps01/RECO/DB9ZX/controlfile/o1_mf_k8dcj43r_.ctl"
  db_block_size            = 8192
  compatible               = "19.0.0"
  log_archive_format       = "%t_%s_%r.dbf"
  db_create_file_dest      = "/apps01/oradata"
  db_recovery_file_dest    = "/apps01/RECO"
  db_recovery_file_dest_size= 12000M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=db9zxXDB)"
  listener_networks        = "(( NAME=net1)(LOCAL_LISTENER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.99)(PORT =1521)))))"
  parallel_min_servers     = 0
  parallel_max_servers     = 10
  audit_file_dest          = "/u01/app/oracle/admin/db9zx/adump"
  audit_trail              = "DB"
  db_name                  = "db9zx"
  open_cursors             = 70
  pga_aggregate_target     = 0
  optimizer_dynamic_sampling= 0
  awr_snapshot_time_offset = 1000000
  diagnostic_dest          = "/u01/app/oracle"
  enable_pluggable_database= TRUE
2022-07-29T22:08:41.292344+05:30
============================================================
NOTE: PatchLevel of this instance 0
============================================================
Starting background process PMON                                     <======================== Mandatory Background process are started
2022-07-29T22:08:41.312897+05:30
PMON started with pid=2, OS id=5662
Starting background process CLMN
2022-07-29T22:08:41.328603+05:30
CLMN started with pid=3, OS id=5664
Starting background process PSP0
2022-07-29T22:08:41.340709+05:30
PSP0 started with pid=4, OS id=5666
Starting background process VKTM
2022-07-29T22:08:41.357011+05:30
VKTM started with pid=5, OS id=5668 at elevated (RT) priority
2022-07-29T22:08:41.358437+05:30
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Starting background process GEN0
2022-07-29T22:08:41.369135+05:30
GEN0 started with pid=6, OS id=5672
Starting background process MMAN
2022-07-29T22:08:41.421091+05:30
MMAN started with pid=8, OS id=5676
Starting background process GEN1
2022-07-29T22:08:41.480158+05:30
GEN1 started with pid=9, OS id=5678_5679
Starting background process DIAG
Starting background process OFSD
2022-07-29T22:08:41.506974+05:30
DIAG started with pid=7, OS id=5681
2022-07-29T22:08:41.520035+05:30
OFSD started with pid=11, OS id=5683_5684
2022-07-29T22:08:41.520584+05:30
Oracle running with ofslib:'Oracle File Server Library' version=2
Starting background process DBRM
2022-07-29T22:08:41.530435+05:30
DBRM started with pid=13, OS id=5686
Starting background process VKRM
2022-07-29T22:08:41.540361+05:30
VKRM started with pid=14, OS id=5688
Starting background process SVCB
2022-07-29T22:08:41.550742+05:30
SVCB started with pid=15, OS id=5690
Starting background process PMAN
2022-07-29T22:08:41.561483+05:30
PMAN started with pid=16, OS id=5692
Starting background process DIA0
2022-07-29T22:08:41.571626+05:30
DIA0 started with pid=17, OS id=5694
Starting background process DBW0
2022-07-29T22:08:41.586487+05:30
DBW0 started with pid=18, OS id=5696
Starting background process LGWR
2022-07-29T22:08:41.596437+05:30
LGWR started with pid=19, OS id=5698
Starting background process CKPT
2022-07-29T22:08:41.606259+05:30
CKPT started with pid=20, OS id=5700
Starting background process SMON
2022-07-29T22:08:41.616221+05:30
SMON started with pid=21, OS id=5702
Starting background process SMCO
2022-07-29T22:08:41.626092+05:30
SMCO started with pid=22, OS id=5704
Starting background process RECO
2022-07-29T22:08:41.645814+05:30
RECO started with pid=24, OS id=5708
Starting background process LREG
2022-07-29T22:08:41.665655+05:30
LREG started with pid=26, OS id=5712
Starting background process PXMN
2022-07-29T22:08:41.677343+05:30
PXMN started with pid=27, OS id=5714
Starting background process FENC
2022-07-29T22:08:41.687264+05:30
FENC started with pid=28, OS id=5716
2022-07-29T22:08:41.688703+05:30
Starting background process MMON
2022-07-29T22:08:41.698584+05:30
MMON started with pid=29, OS id=5718
Starting background process MMNL
2022-07-29T22:08:41.709035+05:30
MMNL started with pid=30, OS id=5720
2022-07-29T22:08:41.709977+05:30
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Starting background process TMON
2022-07-29T22:08:41.745711+05:30
TMON started with pid=28, OS id=5726
Setting CPU count to 1
ORACLE_BASE from environment = /u01/app/oracle
2022-07-29T22:08:44.588983+05:30
Using default pga_aggregate_limit of 2048 MB



STARTUP MOUNT;

kIsH@Xhydra<>alter database mount;
kIsH@Xhydra<>
alter database mount
2022-07-29T22:10:41.096490+05:30
.... (PID:5727): Redo network throttle feature is disabled at mount time
2022-07-29T22:10:41.110181+05:30
Successful mount of redo thread 1, with mount id 1017057501
2022-07-29T22:10:41.110619+05:30
Database mounted in Exclusive Mode
Lost write protection disabled
.... (PID:5727): Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST [krsd.c:18157]
Completed: alter database mount
2022-07-29T22:10:45.671983+05:30
TMON (PID:5726): STARTING ARCH PROCESSES   <================================ Archivers started
Starting background process ARC0
2022-07-29T22:10:45.700435+05:30
ARC0 started with pid=35, OS id=5832
Starting background process ARC1
2022-07-29T22:10:45.728167+05:30
ARC1 started with pid=36, OS id=5834
Starting background process ARC2
2022-07-29T22:10:45.756714+05:30
ARC2 started with pid=37, OS id=5836
Starting background process ARC3
2022-07-29T22:10:45.783478+05:30
ARC3 started with pid=38, OS id=5838
TMON (PID:5726): ARC0: Archival started
TMON (PID:5726): ARC1: Archival started
TMON (PID:5726): ARC2: Archival started
2022-07-29T22:10:45.784999+05:30
ARC0 (PID:5832): Becoming a 'no FAL' ARCH
ARC0 (PID:5832): Becoming the 'no SRL' ARCH
2022-07-29T22:10:45.794988+05:30
TMON (PID:5726): ARC3: Archival started
TMON (PID:5726): STARTING ARCH PROCESSES COMPLETE
2022-07-29T22:10:45.811369+05:30
TT00 (PID:5840): Gap Manager starting

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ALTER DATABASE OPEN;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
alter database open
2022-07-29T22:12:37.228568+05:30
Ping without log force is disabled:
  instance mounted in exclusive mode.
2022-07-29T22:12:37.241903+05:30
Crash Recovery excluding pdb 2 which was cleanly closed.   <====================== 
2022-07-29T22:12:37.241997+05:30
Crash Recovery excluding pdb 4 which was cleanly closed.
2022-07-29T22:12:37.242230+05:30
Crash Recovery excluding pdb 5 which was cleanly closed.
2022-07-29T22:12:37.242453+05:30
Crash Recovery excluding pdb 3 which was cleanly closed.
Endian type of dictionary set to little
2022-07-29T22:12:37.253185+05:30
Redo log for group 2, sequence 1016 is not located on DAX storage
Thread 1 opened at log sequence 1016
  Current log# 2 seq# 1016 mem# 0: /apps01/oradata/DB9ZX/onlinelog/o1_mf_2_k8dcj6c1_.log
  Current log# 2 seq# 1016 mem# 1: /apps01/RECO/DB9ZX/onlinelog/o1_mf_2_k8dcj6qd_.log
Successful open of redo thread 1
2022-07-29T22:12:37.268210+05:30
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
stopping change tracking
Undo initialization recovery: err:0 start: 1959604 end: 1959606 diff: 2 ms (0.0 seconds)
[5727] Successfully onlined Undo Tablespace 2.
Undo initialization online undo segments: err:0 start: 1959606 end: 1959634 diff: 28 ms (0.0 seconds)
Undo initialization finished serial:0 start:1959604 end:1959637 diff:33 ms (0.0 seconds)
Verifying minimum file header compatibility for tablespace encryption for pdb 1..
Verifying file header compatibility for tablespace encryption completed for pdb 1
Database Characterset is AL32UTF8
No Resource Manager plan active
joxcsys_required_dirobj_exists: directory object exists with required path /u01/app/oracle/product/19.0.0/dbhome_1/javavm/admin/, pid 5727 cid 1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process AQPC
2022-07-29T22:12:37.812808+05:30
AQPC started with pid=42, OS id=5891
2022-07-29T22:12:38.531274+05:30
PDB$SEED(2):Autotune of undo retention is turned on.
2022-07-29T22:12:38.537299+05:30
PDB$SEED(2):Endian type of dictionary set to little
PDB$SEED(2):Undo initialization finished serial:0 start:1960881 end:1960881 diff:0 ms (0.0 seconds)
PDB$SEED(2):Database Characterset for PDB$SEED is AL32UTF8
PDB$SEED(2):Opening pdb with no Resource Manager plan active
2022-07-29T22:12:39.769637+05:30
PDBZX2(4):Autotune of undo retention is turned on.
2022-07-29T22:12:39.775500+05:30
PDBZX1(5):Autotune of undo retention is turned on.
2022-07-29T22:12:39.883507+05:30
QPI: opatch file present, opatch
QPI: qopiprep.bat file present
2022-07-29T22:12:40.025376+05:30
PDBZX1(5):Endian type of dictionary set to little
2022-07-29T22:12:40.026410+05:30
PDBZX2(4):Endian type of dictionary set to little
2022-07-29T22:12:40.466887+05:30
PDBZX1(5):Undo initialization recovery: err:0 start: 1962720 end: 1962723 diff: 3 ms (0.0 seconds)
2022-07-29T22:12:40.468240+05:30
PDBZX2(4):Undo initialization recovery: err:0 start: 1962721 end: 1962725 diff: 4 ms (0.0 seconds)
2022-07-29T22:12:40.803586+05:30
PDBZX2(4):[5905] Successfully onlined Undo Tablespace 2.
PDBZX2(4):Undo initialization online undo segments: err:0 start: 1962725 end: 1963060 diff: 335 ms (0.3 seconds)
PDBZX2(4):Undo initialization finished serial:0 start:1962721 end:1963068 diff:347 ms (0.3 seconds)
PDBZX2(4):Database Characterset for PDBZX2 is AL32UTF8
2022-07-29T22:12:40.870909+05:30
PDBZX1(5):[5907] Successfully onlined Undo Tablespace 2.
PDBZX1(5):Undo initialization online undo segments: err:0 start: 1962724 end: 1963128 diff: 404 ms (0.4 seconds)
PDBZX1(5):Undo initialization finished serial:0 start:1962720 end:1963135 diff:415 ms (0.4 seconds)
PDBZX1(5):Database Characterset for PDBZX1 is AL32UTF8
Violations: Type: 1, Count: 2
PDBZX1(5):***************************************************************
PDBZX1(5):WARNING: Pluggable Database PDBZX1 with pdb id - 5 is
PDBZX1(5):         altered with errors or warnings. Please look into
PDBZX1(5):         PDB_PLUG_IN_VIOLATIONS view for more details.
PDBZX1(5):***************************************************************
2022-07-29T22:12:42.139534+05:30
PDBZX2(4):Opening pdb with no Resource Manager plan active
PDBZX2(4):joxcsys_required_dirobj_exists: directory object exists with required path /u01/app/oracle/product/19.0.0/dbhome_1/javavm/admin/, pid 5905 cid 4
Pluggable database PDBZX2 opened read write
2022-07-29T22:12:42.786228+05:30
PDBZX1(5):Opening pdb with no Resource Manager plan active
PDBZX1(5):joxcsys_required_dirobj_exists: directory object exists with required path /u01/app/oracle/product/19.0.0/dbhome_1/javavm/admin/, pid 5907 cid 5
Pluggable database PDBZX1 opened read write
2022-07-29T22:12:43.437754+05:30
Starting background process CJQ0
2022-07-29T22:12:43.522931+05:30
CJQ0 started with pid=54, OS id=6079
Completed: alter database open
2022-07-29T22:12:45.297633+05:30

Leave a Reply