HELP STARTUP

> help startup

STARTUP
-------

Starts an Oracle instance with several options, including mounting,
and opening a database.

STARTUP db_options | cdb_options | upgrade_options

where db_options has the following syntax:
[FORCE] [RESTRICT] [PFILE=filename] [QUIET] [ MOUNT [dbname] |
[ OPEN [open_db_options] [dbname] ] |
NOMOUNT ]

where open_db_options has the following syntax:
READ {ONLY | WRITE [RECOVER]} | RECOVER

where cdb_options has the following syntax:
root_connection_options | pdb_connection_options

where root_connection_options has the following syntax:
PLUGGABLE DATABASE pdbname
[FORCE] [RESTRICT] | [OPEN [open_pdb_options]]

where pdb_connection_options has the following syntax:
[FORCE] [RESTRICT] | [OPEN [open_pdb_options]]

where open_pdb_options has the following syntax:
READ WRITE | READ ONLY

and where upgrade_options has the following syntax:
[PFILE=filename] {UPGRADE | DOWNGRADE} [QUIET]

EXPLAIN STARTUP

###################
####### 解释
###################
> help startup

STARTUP
-------

使用多个选项启动Oracle实例,包括装载和打开数据库。

STARTUP db_options | cdb_options | upgrade_options

其中db_options具有以下语法:
[FORCE] [RESTRICT] [PFILE=filename] [QUIET] [ MOUNT [dbname] |
[ OPEN [open_db_options] [dbname] ] |
NOMOUNT ]

其中,open_db_options具有以下语法:
READ {ONLY | WRITE [RECOVER]} | RECOVER

其中cdb_options具有以下语法:
root_connection_options | pdb_connection_options

其中root_connection_options具有以下语法:
PLUGGABLE DATABASE pdbname
[FORCE] [RESTRICT] | [OPEN [open_pdb_options]]

其中pdb_connection_options具有以下语法:
[FORCE] [RESTRICT] | [OPEN [open_pdb_options]]

其中,open_pdb_options具有以下语法:
READ WRITE | READ ONLY

其中upgrade_options具有以下语法:
[PFILE=filename] {UPGRADE | DOWNGRADE} [QUIET]

EXAMPLE STARTUP

startup
startup nomount
startup mount
startup force
startup pfile=FILENAME
startup recover

实例启动过程-startup

2022-10-04T20:07:44.568572+08:00
Starting ORACLE instance (normal) (OS id: 79732)
2022-10-04T20:07:45.450024+08:00
************************************************************
Instance SGA_TARGET = 2608 MB and SGA_MAX_SIZE = 2600 MB
************************************************************
2022-10-04T20:07:45.450425+08:00
****************************************************
Sys-V shared memory will be used for creating SGA
****************************************************
2022-10-04T20:07:45.452549+08:00
**********************************************************************
2022-10-04T20:07:45.452702+08:00
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

2022-10-04T20:07:45.452904+08:00
Per process system memlock (soft) limit = 128G
2022-10-04T20:07:45.452984+08:00
Expected per process system memlock (soft) limit to lock
instance MAX SHARED GLOBAL AREA (SGA) into memory: 2610M
2022-10-04T20:07:45.453199+08:00
Available system pagesizes:
4K, 2048K
2022-10-04T20:07:45.453378+08:00
Supported system pagesize(s):
2022-10-04T20:07:45.453463+08:00
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
2022-10-04T20:07:45.453547+08:00
4K Configured 5 667653 NONE
2022-10-04T20:07:45.454615+08:00
2048K 0 1305 0 NONE
2022-10-04T20:07:45.454737+08:00
RECOMMENDATION:
2022-10-04T20:07:45.454827+08:00
1. For optimal performance, configure system with expected number
of pages for every supported system pagesize prior to the next
instance restart operation.
2022-10-04T20:07:45.480137+08:00
**********************************************************************
2022-10-04T20:07:48.899750+08:00
PGA_AGGREGATE_TARGET specified is high
Errors in file /u01/app/oracle/diag/rdbms/b19c0/b19c01/trace/b19c01_ora_79732.trc (incident=216212):
ORA-00700: soft internal error, arguments: [pga physmem limit], [1073741824], [489749094], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/b19c0/b19c01/incident/incdir_216212/b19c01_ora_79732_i216212.trc
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
2022-10-04T20:07:50.919634+08:00
Initial number of CPU is 1
Number of processor cores in the system is 1
Number of processor sockets in the system is 1
KSXRTEST ISGA: RM Channel count = 1
KSXRTEST ISGA: rcnt= 70 rmrcnt = 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
kjidomenacan initialized to 3
Autotune of undo retention is turned on.
2022-10-04T20:07:51.730198+08:00
LICENSE_MAX_USERS = 0
SYS auditing is enabled
2022-10-04T20:07:52.104222+08:00
NOTE: remote asm mode is remote (mode 0x2; from cluster type)
2022-10-04T20:07:53.355082+08:00
NOTE: remote asm mode is remote (mode 0x2; from cluster type)
NOTE: Cluster configuration type = CLUSTER [4]
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.3.0/db
System name: Linux
Node name: b19c01
Release: 3.10.0-693.el7.x86_64
Version: #1 SMP Tue Aug 22 21:09:27 UTC 2017
Machine: x86_64
Using parameter settings in server-side spfile +DATA/B19C0/PARAMETERFILE/spfile.272.1113228741
System parameters with non-default values:
processes = 300
sga_max_size = 2608M
shared_pool_size = 240M
nls_language = "AMERICAN"
nls_territory = "AMERICA"
resource_manager_plan = "DEFAULT_CDB_PLAN"
sga_target = 2608M
memory_target = 0
control_files = "+DATA/B19C0/CONTROLFILE/current.261.1113227175"
db_block_size = 8192
db_cache_size = 1888M
compatible = "19.0.0"
log_archive_dest_1 = "LOCATION=+ARCHIVE"
cluster_database = TRUE
db_create_file_dest = "+DATA"
thread = 1
undo_tablespace = "UNDOTBS1"
instance_number = 1
remote_login_passwordfile= "EXCLUSIVE"
dispatchers = "(PROTOCOL=TCP) (SERVICE=b19c0XDB)"
local_listener = "-oraagent-dummy-"
audit_file_dest = "/u01/app/oracle/admin/b19c0/adump"
audit_trail = "NONE"
db_name = "b19c0"
open_cursors = 300
pga_aggregate_target = 1G
diagnostic_dest = "/u01/app/oracle"
enable_pluggable_database= TRUE
2022-10-04T20:07:53.744147+08:00
Cluster Communication is configured to use IPs from: GPnP
IP: 169.254.1.52 Subnet: 169.254.0.0
KSIPC Loopback IP addresses(OSD):
127.0.0.1
KSIPC Available Transports: UDP:TCP
KSIPC: Client: KCL Transport: UDP
KSIPC: Client: DLM Transport: UDP
KSIPC CAPABILITIES :MGA:IPCLW:GRPAM:TOPO:DLL:STATSFW:CRTRK
KSXP: ksxpsg_ipclwtrans: 2 UDP
cluster interconnect IPC version: [IPCLW over UDP(mode 3) ]
IPC Vendor 1 proto 2
Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 6.0
============================================================
NOTE: PatchLevel of this instance 0
============================================================
Starting background process PMON
2022-10-04T20:07:54.241417+08:00
PMON started with pid=2, OS id=81492
Starting background process CLMN
2022-10-04T20:07:54.304686+08:00
CLMN started with pid=3, OS id=81494
Starting background process PSP0
2022-10-04T20:07:54.365219+08:00
PSP0 started with pid=4, OS id=81496
2022-10-04T20:07:54.365503+08:00
Starting background process IPC0
2022-10-04T20:07:55.544686+08:00
IPC0 started with pid=5, OS id=81514
2022-10-04T20:07:55.550072+08:00
Starting background process VKTM
2022-10-04T20:07:55.721261+08:00
VKTM started with pid=6, OS id=81516 at elevated (RT) priority
2022-10-04T20:07:55.724003+08:00
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Starting background process GEN0
2022-10-04T20:07:55.837579+08:00
GEN0 started with pid=7, OS id=81520
Starting background process MMAN
2022-10-04T20:07:55.971739+08:00
MMAN started with pid=8, OS id=81524
Starting background process GEN1
2022-10-04T20:07:56.303617+08:00
GEN1 started with pid=10, OS id=81537_81538
Starting background process DIAG
2022-10-04T20:07:56.432077+08:00
DIAG started with pid=12, OS id=81540
Starting background process OFSD
2022-10-04T20:07:56.541242+08:00
Dumping diagnostic data in directory=[cdmp_20221004200756], requested by (instance=1, osid=79732), summary=[incident=216212].
2022-10-04T20:07:56.563836+08:00
OFSD started with pid=13, OS id=81545_81548
2022-10-04T20:07:56.564955+08:00
Starting background process DBRM
2022-10-04T20:07:56.567840+08:00
Oracle running with ofslib:'Oracle File Server Library' version=2
Starting background process VKRM
2022-10-04T20:07:56.655678+08:00
DBRM started with pid=15, OS id=81552
2022-10-04T20:07:56.777262+08:00
VKRM started with pid=16, OS id=81556
Starting background process PING
Starting background process SVCB
2022-10-04T20:07:56.875201+08:00
PING started with pid=17, OS id=81558
2022-10-04T20:07:56.968287+08:00
SVCB started with pid=18, OS id=81564
Starting background process ACMS
2022-10-04T20:07:57.067325+08:00
ACMS started with pid=19, OS id=81566
Starting background process PMAN
Starting background process DIA0
2022-10-04T20:07:57.147074+08:00
PMAN started with pid=20, OS id=81570
2022-10-04T20:07:57.216231+08:00
DIA0 started with pid=21, OS id=81575
Starting background process LMON
2022-10-04T20:07:57.314791+08:00
LMON started with pid=22, OS id=81580
Starting background process LMD0
2022-10-04T20:07:57.389945+08:00
LMD0 started with pid=23, OS id=81585
Starting background process RMS0
2022-10-04T20:07:57.392775+08:00
* Load Monitor used for high load check
* New Low - High Load Threshold Range = [960 - 1280]
2022-10-04T20:07:57.513773+08:00
LMS0 started with pid=24, OS id=81589_81594 at elevated (RT) priority
2022-10-04T20:07:57.623655+08:00
Starting background process LMHB
2022-10-04T20:07:57.624258+08:00
RMS0 started with pid=26, OS id=81592
2022-10-04T20:07:57.716263+08:00
LMHB started with pid=28, OS id=81600
Starting background process LCK1
2022-10-04T20:07:57.810909+08:00
LCK1 started with pid=29, OS id=81605
Starting background process DBW0
2022-10-04T20:07:57.927778+08:00
DBW0 started with pid=30, OS id=81610
Starting background process LGWR
2022-10-04T20:07:58.034146+08:00
LGWR started with pid=31, OS id=81615
Starting background process CKPT
Starting background process SMON
2022-10-04T20:07:58.170993+08:00
CKPT started with pid=32, OS id=81621
2022-10-04T20:07:58.294012+08:00
SMON started with pid=33, OS id=81630
Starting background process SMCO
2022-10-04T20:07:58.434778+08:00
SMCO started with pid=34, OS id=81649
Starting background process RECO
2022-10-04T20:07:58.590096+08:00
RECO started with pid=35, OS id=81672
2022-10-04T20:07:58.781458+08:00
Starting background process LREG
2022-10-04T20:07:59.053439+08:00
LREG started with pid=37, OS id=81694
Starting background process PXMN
2022-10-04T20:07:59.459823+08:00
PXMN started with pid=39, OS id=81717
Starting background process RBAL
2022-10-04T20:07:59.641977+08:00
RBAL started with pid=40, OS id=81722
Starting background process ASMB
2022-10-04T20:08:04.900098+08:00
PGA_AGGREGATE_LIMIT specified is high
2022-10-04T20:08:04.938033+08:00
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 1024 MB.
physical memory size is 3935 MB
limit based on physical memory and SGA usage is 934 MB
SGA_TARGET is 2608 MB
Using default pga_aggregate_limit of 2048 MB
2022-10-04T20:08:05.264619+08:00
ASMB started with pid=41, OS id=81727
2022-10-04T20:08:05.661114+08:00
Starting background process FENC
2022-10-04T20:08:05.893176+08:00
FENC started with pid=43, OS id=81767
Starting background process MMON
2022-10-04T20:08:06.272486+08:00
MMON started with pid=44, OS id=81773
Starting background process MMNL
2022-10-04T20:08:06.734662+08:00
MMNL started with pid=45, OS id=81779
2022-10-04T20:08:06.748312+08:00
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
2022-10-04T20:08:55.259903+08:00
NOTE: ASMB (index:0) registering with ASM instance as Flex client 0xffffffffffffffff (reg:1057585922) (startid:1117224473) (new connection)
2022-10-04T20:08:56.025674+08:00
My CSS node number is 1
My CSS hostname is b19c01
Instance reconfiguration: current system load 19 (hiload)
lmon registered with NM - instance number 1 (internal mem no 0)
Increasing priority of 1 RS
* allocate domain 0, valid ? 0
* Setting GES domain 0
Attached to domain 0 (addr: 0x7a5b8388)
2022-10-04T20:08:57.060200+08:00
Reconfiguration started (old inc 0, new inc 16)
Dynamic remastering is disabled
List of instances (total 2) :
1 2
My inst 1 (I'm a new instance)
Global Resource Directory frozen
Switching DLM PDB isolation (kjidomena: 0 -> 3, mm: NONE -> NORM)
Enabling Dynamic Remastering: NONE->NORM switch
Communication channels reestablished
2022-10-04T20:08:57.129743+08:00
* domain 0 valid = 1 (flags x9000, pdb flags x9000) according to instance 2
* allocate domain 2, valid ? 1
* allocate domain 3, valid ? 1
2022-10-04T20:08:57.150826+08:00
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
2022-10-04T20:08:57.225031+08:00
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived, skipped 0
Set master node info
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Reconfiguration complete (total time 0.4 secs)
Decreasing priority of 1 RS
2022-10-04T20:08:57.447833+08:00
Starting background process LCK0
2022-10-04T20:08:57.474494+08:00
LCK0 started with pid=50, OS id=82061
Starting background process RSMN
2022-10-04T20:08:57.760587+08:00
RSMN started with pid=51, OS id=82063
Starting background process TMON
2022-10-04T20:08:57.874436+08:00
NOTE: ASMB (index:0) (81727) connected to ASM instance +ASM1, osid: 81770 (Flex mode; client id 0xaf3d4ea2d4437da2)
NOTE: initiating MARK startup
2022-10-04T20:08:58.028253+08:00
TMON started with pid=52, OS id=82065
Starting background process MARK
2022-10-04T20:08:58.118292+08:00
MARK started with pid=53, OS id=82067
2022-10-04T20:08:58.124870+08:00
NOTE: MARK has subscribed
2022-10-04T20:08:58.302522+08:00
Setting CPU count to 1
ORACLE_BASE from environment = /u01/app/oracle
2022-10-04T20:09:02.336470+08:00
KSXPPING: KSXP selected for Ping
2022-10-04T20:09:02.754342+08:00
ALTER DATABASE MOUNT
2022-10-04T20:09:04.923473+08:00
NOTE: ASMB mounting group 2 (DATA)
NOTE: Assigned CGID 0x10008 for group 2
NOTE: ASMB process initiating disk discovery for grp 2 (reqid:0)
2022-10-04T20:09:06.162531+08:00
NOTE: Assigning number (2,1) to disk (/dev/asm_data1)
NOTE: Assigning number (2,0) to disk (/dev/asm_data)
SUCCESS: mounted group 2 (DATA)
NOTE: grp 2 disk 1: DATA_0001 path:/dev/asm_data1
NOTE: grp 2 disk 0: DATA_0000 path:/dev/asm_data
2022-10-04T20:09:07.879500+08:00
ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.63)(PORT=1521))' SCOPE=MEMORY SID='b19c01';
2022-10-04T20:09:08.230336+08:00
NOTE: dependency between database b19c0 and diskgroup resource ora.DATA.dg is established
2022-10-04T20:09:08.348403+08:00
ALTER SYSTEM SET remote_listener=' b19c-scan:1521' SCOPE=MEMORY SID='b19c01';
2022-10-04T20:09:08.351115+08:00
ALTER SYSTEM SET listener_networks='' SCOPE=MEMORY SID='b19c01';
2022-10-04T20:09:11.822364+08:00
KRDNFY: Preserving Buffer Cache is turned off.
.... (PID:82075): Redo network throttle feature is disabled at mount time
2022-10-04T20:09:12.471977+08:00
Successful mount of redo thread 1, with mount id 3203387421
2022-10-04T20:09:12.484789+08:00
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Lost write protection disabled
.... (PID:82075): Using STANDBY_ARCHIVE_DEST parameter default value as +ARCHIVE [krsd.c:18141]
2022-10-04T20:09:12.940734+08:00
Completed: ALTER DATABASE MOUNT
2022-10-04T20:09:13.277736+08:00
ALTER DATABASE OPEN
Ping without log force is disabled:
not an Exadata system.
Picked broadcast on commit scheme to generate SCNs
Endian type of dictionary set to little
2022-10-04T20:09:14.276061+08:00
LGWR (PID:81615): STARTING ARCH PROCESSES
Starting background process ARC0
2022-10-04T20:09:14.534102+08:00
TT00 (PID:82200): Gap Manager starting
2022-10-04T20:09:14.716149+08:00
ARC0 started with pid=57, OS id=82209
2022-10-04T20:09:14.728237+08:00
LGWR (PID:81615): ARC0: Archival started
LGWR (PID:81615): STARTING ARCH PROCESSES COMPLETE
2022-10-04T20:09:14.746817+08:00
ARC0 (PID:82209): Becoming a 'no FAL' ARCH
ARC0 (PID:82209): Becoming the 'no SRL' ARCH
2022-10-04T20:09:14.758507+08:00
Redo log for group 2, sequence 98 is not located on DAX storage
Thread 1 opened at log sequence 98
Current log# 2 seq# 98 mem# 0: +DATA/B19C0/ONLINELOG/group_2.262.1113227179
Successful open of redo thread 1
2022-10-04T20:09:14.815203+08:00
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
stopping change tracking
2022-10-04T20:09:14.988345+08:00
TMON (PID:82065): STARTING ARCH PROCESSES
Starting background process ARC1
2022-10-04T20:09:15.102858+08:00
ALTER SYSTEM SET remote_listener=' b19c-scan:1521' SCOPE=MEMORY SID='b19c01';
2022-10-04T20:09:15.112977+08:00
ALTER SYSTEM SET listener_networks='' SCOPE=MEMORY SID='b19c01';
2022-10-04T20:09:15.268783+08:00
ARC1 started with pid=62, OS id=82213
Starting background process ARC2
2022-10-04T20:09:15.421486+08:00
ARC2 started with pid=60, OS id=82218
Starting background process ARC3
2022-10-04T20:09:15.613707+08:00
ARC3 started with pid=63, OS id=82220
TMON (PID:82065): ARC1: Archival started
TMON (PID:82065): ARC2: Archival started
TMON (PID:82065): ARC3: Archival started
TMON (PID:82065): STARTING ARCH PROCESSES COMPLETE
2022-10-04T20:09:16.054805+08:00
Set LMHB to elevated priority
2022-10-04T20:09:16.246031+08:00
Undo initialization recovery: err:0 start: 40344785 end: 40344806 diff: 21 ms (0.0 seconds)
2022-10-04T20:09:17.547669+08:00
[82177] Successfully onlined Undo Tablespace 2.
Undo initialization online undo segments: err:0 start: 40344808 end: 40346108 diff: 1300 ms (1.3 seconds)
Undo initialization finished serial:0 start:40344785 end:40346140 diff:1355 ms (1.4 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
Opening with Resource Manager plan: DEFAULT_CDB_PLAN
2022-10-04T20:09:21.499585+08:00
Starting background process GTX0
2022-10-04T20:09:21.562934+08:00
GTX0 started with pid=68, OS id=82328
2022-10-04T20:09:21.580544+08:00
joxcsys_required_dirobj_exists: directory object exists with required path /u01/app/oracle/product/19.3.0/db/javavm/admin/, pid 82177 cid 1
Starting background process RCBG
2022-10-04T20:09:21.882440+08:00
RCBG started with pid=69, OS id=82330
replication_dependency_tracking turned off (no async multimaster replication found)
2022-10-04T20:09:24.944503+08:00
Starting background process AQPC
2022-10-04T20:09:24.972625+08:00
AQPC started with pid=71, OS id=82349
2022-10-04T20:09:28.364585+08:00
## jox_ujs_status: classes.bin in db and executable versions match 19.0.0.0.0 1.8, returning FALSE in pid 82365
2022-10-04T20:09:32.632967+08:00
PDB$SEED(2):Autotune of undo retention is turned on.
2022-10-04T20:09:32.796477+08:00
ALTER SYSTEM SET remote_listener=' b19c-scan:1521' SCOPE=MEMORY SID='b19c01';
2022-10-04T20:09:32.817372+08:00
ALTER SYSTEM SET listener_networks='' SCOPE=MEMORY SID='b19c01';
2022-10-04T20:09:33.813925+08:00
PDB$SEED(2):queued attach DA request 0x7a658688 for pdb 2
2022-10-04T20:09:33.852299+08:00
Increasing priority of 1 RS
Domain Action Reconfiguration started (domid 2, new da inc 8, cluster inc 16)
Instance 1 is attaching to domain 2
Global Resource Directory partially frozen for domain action
Non-local Process blocks cleaned out
Set master node info
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Domain Action Reconfiguration complete (total time 0.2 secs)
Decreasing priority of 1 RS
2022-10-04T20:09:34.089160+08:00
PDB$SEED(2):Endian type of dictionary set to little
2022-10-04T20:09:34.200270+08:00
ALTER SYSTEM SET _ipddb_enable=TRUE SCOPE=MEMORY SID='b19c01';
2022-10-04T20:09:34.959818+08:00
PDB$SEED(2):Undo initialization finished serial:0 start:40363520 end:40363520 diff:0 ms (0.0 seconds)
PDB$SEED(2):Database Characterset for PDB$SEED is AL32UTF8
2022-10-04T20:09:39.563258+08:00
PDB$SEED(2):Opening pdb with no Resource Manager plan active
2022-10-04T20:09:40.936067+08:00
Starting background process CJQ0
2022-10-04T20:09:41.075819+08:00
CJQ0 started with pid=84, OS id=82441
Completed: ALTER DATABASE OPEN
2022-10-04T20:09:41.440016+08:00
QPI: opatch file present, opatch
QPI: qopiprep.bat file present
2022-10-04T20:09:42.824890+08:00
QPI: Cleaning and refreshing metadata..
2022-10-04T20:09:55.527553+08:00
===========================================================
Dumping current patch information
===========================================================
Patch Id: 29517242
Patch Description: Database Release Update : 19.3.0.0.190416 (29517242)
Patch Apply Time: 2019-04-18T15:21:17+08:00
Bugs Fixed: 14735102,19697993,20313356,21965541,25806201,25883179,25986062,
26476244,26611353,26872233,27369515,27423500,27666312,27710072,27846298,
27957203,28064977,28072567,28129791,28181021,28210681,28279456,28313275,
28350595,28371123,28379065,28431445,28463226,28489419,28502773,28513333,
28534475,28561704,28569897,28572533,28572544,28587723,28593682,28594086,
28597221,28601957,28605066,28606598,28625862,28627033,28636532,28643718,
28644549,28645570,28646200,28646939,28649388,28655209,28663782,28673945,
28692275,28694872,28696373,28705231,28710385,28710734,28714461,28718469,
28730079,28740708,28760206,28772390,28774416,28777214,28789531,28791852,
28795551,28802734,28804517,28810381,28811560,28815123,28815355,28819640,
28824482,28833912,28835937,28862532,28863432,28873575,28876253,28876639,
28884931,28888327,28892794,28897512,28899663,28901126,28905457,28907196,
28912691,28915561,28917080,28918429,28919145,28922227,28922532,28922608,
28925634,28925880,28933158,28936114,28937717,28938698,28940179,28940281,
28941901,28942455,28945421,28945994,28951533,28952168,28954762,28955606,
28957292,28957723,28962775,28965231,28966444,28974083,28977322,28983095,
28983486,28986326,28986481,28988482,28989306,28993295,28994307,28996376,
29000000,29001888,29002927,29003738,29006318,29006621,29007321,29007775,
29008035,29011936,29013475,29014076,29015118,29017265,29018655,29019121,
29021063,29021352,29024552,29026582,29026606,29027456,29027694,29027940,
29031575,29031600,29032234,29032457,29032607,29033052,29033145,29033200,
29033280,29034587,29037290,29038528,29039089,29039510,29043554,29043651,
29043725,29044763,29044954,29047850,29048289,29048498,29048605,29050560,
29050765,29051702,29052726,29053783,29056024,29056270,29056560,29059011,
29061959,29062692,29062848,29062860,29062868,29110526,29110783,29110790,
29110797,29110802,29110805,29111598,29113282,29113305,29117526,29117642,
29119077,29120223,29122224,29122254,29123297,29123432,29123482,29124368,
29125380,29126345,29127957,29128935,29129450,29129497,29129712,29130219,
29131539,29132938,29134447,29136111,29138641,29141316,29141341,29141685,
29142667,29144995,29145214,29145730,29149829,29150338,29151520,29152357,
29155099,29157389,29158680,29158899,29159909,29159936,29160174,29162095,
29163415,29163437,29163524,29163567,29167111,29167342,29167374,29167940,
29168219,29168433,29169073,29169215,29171942,29172618,29172826,29173140,
29173373,29173817,29174004,29176318,29177466,29177543,29177886,29178385,
29180313,29180455,29180559,29180893,29181153,29181231,29181620,29181743,
29181923,29182019,29183912,29184297,29184666,29185193,29186456,29189302,
29189307,29189889,29190235,29190474,29190740,29191541,29192419,29192468,
29192685,29193207,29194205,29194367,29194493,29194827,29195279,29195337,
29195758,29196725,29199635,29199733,29200316,29200700,29201494,29201539,
29202104,29202850,29203122,29203166,29203425,29203443,29203604,29205281,
29205323,29205419,29205463,29205767,29205918,29206109,29206605,29207073,
29208260,29208732,29211457,29211724,29212012,29212433,29212611,29213351,
29213775,29213850,29213879,29214561,29214960,29216746,29216984,29217294,
29217472,29217828,29217848,29218570,29219205,29219273,29220079,29221248,
29221891,29222031,29222784,29223833,29223859,29223967,29224065,29224605,
29225076,29227602,29228869,29229164,29229754,29229844,29229955,29230252,
29230565,29231133,29232117,29232154,29234123,29237538,29240307,29241345,
29242017,29242884,29243958,29245137,29245160,29246163,29247415,29247712,
29247906,29248552,29248835,29248858,29249991,29250059,29251259,29253184,
29253871,29254031,29254930,29255178,29255273,29255431,29255435,29256426,
29259119,29259320,29261906,29262512,29262887,29265448,29266248,29266899,
29267292,29268412,29269171,29270585,29273539,29273735,29273847,29274428,
29274564,29274627,29275461,29278218,29279658,29279751,29279854,29282898,
29285503,29285788,29285956,29286037,29287130,29287705,29292837,29293072,
29297863,29297915,29298220,29299049,29299082,29299844,29301566,29302963,
29303918,29304781,29311588,29312310,29312734,29312753,29313347,29313417,
29313525,29314539,29318410,29319441,29321489,29323946,29324568,29325087,
29325105,29325257,29325993,29327044,29329087,29331209,29331380,29331493,
29332771,29333500,29337310,29338315,29338453,29338780,29338913,29339155,
29341209,29343086,29346943,29347620,29348176,29350052,29351386,29351716,
29351749,29352867,29353271,29355654,29356547,29356752,29358828,29360672,
29361801,29363151,29364171,29364177,29367019,29367561,29368253,29373418,
29373588,29374179,29377986,29378029,29379978,29382784,29385652,29386502,
29386635,29386660,29387274,29388094,29388524,29388830,29389889,29390435,
29394140,29394749,29397954,29398863,29399100,29399121,29405012,29405651,
29412066,29412269,29417884,29423826,29429264,29429566,29431485,29435652,
29438736,29439522,29450421,29451386,29452576,29452953,29457807,29460252,
29462957,29486181,29507616,29515240,29521748,29530812,29531654,29557336,
29558975,29601461

Patch Id: 29585399
Patch Description: OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
Patch Apply Time: 2019-04-18T15:21:33+08:00
Bugs Fixed: 3,27222128,27572040,27604329,27760043,27877830,28302580,28470673,
28621543,28642469,28699321,28710663,28755846,28772816,28785321,28800508,
28808652,28815557,28847541,28847572,28870496,28871040,28874416,28877252,
28881191,28881848,28888083,28911140,28925250,28925460,28935956,28940472,
28942694,28951332,28963036,28968779,28980448,28995287,29003207,29003617,
29016294,29018680,29024876,29026154,29027933,29047127,29052850,29058476,
29111631,29112455,29117337,29123444,29125708,29125786,29129476,29131772,
29132456,29139727,29146157,29147849,29149170,29152603,29152752,29154631,
29154636,29154829,29159216,29159661,29160462,29161923,29169540,29169739,
29170717,29173618,29181568,29182920,29183298,29186091,29191827,29201143,
29201695,29209545,29210577,29210610,29210624,29210683,29213641,29219627,
29224294,29225861,29229839,29235934,29242906,29243749,29244495,29244766,
29244968,29248723,29249583,29251564,29255616,29260224,29261695,29271019,
29273360,29282090,29282666,29285453,29285621,29290235,29292232,29293806,
29294753,29299830,29307090,29307109,29311336,29329675,29330791,29339299,
29357821,29360467,29360775,29367971,29368725,29379299,29379381,29380527,
29381000,29382296,29391301,29393649,29402110,29411931,29413360,29457319,
29465047
===========================================================

HELP SHUTDOWN

> help shutdown

SHUTDOWN
--------

Shuts down a currently running Oracle Database instance, optionally
closing and dismounting a database.

SHUTDOWN [ABORT|IMMEDIATE|NORMAL|TRANSACTIONAL [LOCAL]]

EXPLAIN SHUTDOWN

###################
####### 解释
###################
> help shutdown

SHUTDOWN
--------

关闭当前正在运行的Oracle数据库实例,可以选择关闭和卸载数据库。

SHUTDOWN [ABORT|IMMEDIATE|NORMAL|TRANSACTIONAL [LOCAL]]

EXAMPLE SHUTDOWN

shutdown immediate
shutdown normal
shutdown abort

实例关闭过程-shutdown immediate

2022-10-04T20:03:00.905802+08:00
Process termination requested for pid 77643 [source = rdbms], [info = 2] [request issued by pid: 76371, uid: 612]
2022-10-04T20:03:03.676685+08:00
Shutting down ORACLE instance (immediate) (OS id: 77242)
2022-10-04T20:03:06.437432+08:00
Stopping background process SMCO
2022-10-04T20:03:07.478845+08:00
Shutting down instance: further logons disabled
2022-10-04T20:03:08.290478+08:00
Stopping background process CJQ0
2022-10-04T20:03:08.632086+08:00
Process termination requested for pid 77576 [source = rdbms], [info = 2] [request issued by pid: 77524, uid: 612]
2022-10-04T20:03:08.777852+08:00
Stopping background process MMNL
2022-10-04T20:03:08.779389+08:00
Process termination requested for pid 77565 [source = rdbms], [info = 2] [request issued by pid: 77528, uid: 612]
2022-10-04T20:03:09.778343+08:00
Stopping background process MMON
2022-10-04T20:03:12.873418+08:00
alter pluggable database all close immediate
Completed: alter pluggable database all close immediate
2022-10-04T20:03:12.927763+08:00
PDB$SEED(2):JIT: pid 77242 requesting stop
2022-10-04T20:03:13.983553+08:00
PDB$SEED(2):Buffer Cache flush deferred for PDB 2
2022-10-04T20:03:14.060672+08:00
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 40
2022-10-04T20:03:14.072103+08:00
NOTE: Deferred communication with ASM instance
License high water mark = 7
2022-10-04T20:03:14.325208+08:00
Dispatchers and shared servers shutdown

Data Pump shutdown on PDB: 1 in progress
2022-10-04T20:03:14.327974+08:00
Process termination requested for pid 77439 [source = rdbms], [info = 2] [request issued by pid: 77242, uid: 612]
2022-10-04T20:03:16.328761+08:00
ALTER DATABASE CLOSE NORMAL
2022-10-04T20:03:16.780361+08:00
Stopping Emon pool
alter pluggable database all close immediate
Completed: alter pluggable database all close immediate
2022-10-04T20:03:17.843192+08:00

IM on ADG: Start of Empty Journal

IM on ADG: End of Empty Journal
Stopping background process RCBG
2022-10-04T20:03:18.873184+08:00
Stopping Emon pool
stopping change tracking
2022-10-04T20:03:18.990969+08:00
Redo thread 1 internally disabled at seq 97 (LGWR)
Shutting down archive processes
2022-10-04T20:03:18.992321+08:00
TT00 (PID:77277): Gap Manager exiting
2022-10-04T20:03:19.397991+08:00
NOTE: ASMB mounting group 1 (ARCHIVE)
NOTE: Assigned CGID 0x10007 for group 1
NOTE: ASMB process initiating disk discovery for grp 1 (reqid:0)
NOTE: Assigning number (1,0) to disk (/dev/asm_archive)
SUCCESS: mounted group 1 (ARCHIVE)
NOTE: grp 1 disk 0: ARCHIVE_0000 path:/dev/asm_archive
2022-10-04T20:03:19.721189+08:00
ARC1 (PID:77290): Archiving disabled T-1.S-97
2022-10-04T20:03:19.992443+08:00
Archiving is disabled
2022-10-04T20:03:19.993468+08:00
ARC3 (PID:77296): ARCH shutting down
ARC3 (PID:77296): Archival stopped
2022-10-04T20:03:19.993840+08:00
ARC2 (PID:77294): ARCH shutting down
ARC2 (PID:77294): Archival stopped
2022-10-04T20:03:19.994502+08:00
ARC0 (PID:77279): ARCH shutting down
ARC0 (PID:77279): Archival stopped
2022-10-04T20:03:20.944516+08:00
ARC1 (PID:77290): Archived Log entry 175 added for T-1.S-97 ID 0xbeb3a524 LAD:1
ARC1 (PID:77290): ARCH shutting down
ARC1 (PID:77290): Archival stopped
2022-10-04T20:03:21.267069+08:00
NOTE: dependency between database b19c0 and diskgroup resource ora.ARCHIVE.dg is established
2022-10-04T20:03:21.995159+08:00
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 34
Thread 1 closed at log sequence 97
Successful close of redo thread 1
2022-10-04T20:03:22.108060+08:00
Buffer Cache invalidation for all PDBs started
Buffer Cache invalidation for all PDBs complete
2022-10-04T20:03:25.565688+08:00
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
2022-10-04T20:03:25.599772+08:00
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 2
Completed: ALTER DATABASE DISMOUNT
2022-10-04T20:03:25.888939+08:00
.... (PID:77242): Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
JIT: pid 77242 requesting stop
.... (PID:77242): Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
2022-10-04T20:03:25.905668+08:00
Stopping background process VKTM
2022-10-04T20:03:25.961902+08:00
JIT: pid 77242 requesting stop
2022-10-04T20:03:26.400838+08:00
NOTE: Shutting down MARK background process
2022-10-04T20:03:26.957384+08:00
NOTE: Could not deregister group num %.%
2022-10-04T20:03:28.586677+08:00
NOTE: force a map free for map id 2
2022-10-04T20:03:38.975643+08:00
NOTE: ASMB releasing group resources due to shutdown
NOTE: ASMB clearing idle groups before exit
Stopping background process RBAL
2022-10-04T20:03:49.684307+08:00
freeing rdom 3
freeing rdom 2
freeing the fusion rht of pdb 2
freeing the pdb enqueue rht
freeing rdom 0
freeing the fusion rht of pdb 0
2022-10-04T20:03:54.421707+08:00
Instance shutdown complete (OS id: 77242)