-----------------------------------------------------------------
Oracle DB - ADR(Automatic Diagnostic Repository) ログサンプル
-----------------------------------------------------------------
▼ インスタンス開始
Starting ORACLE instance (normal) (OS id: 145697) 
2022-06-11T22:08:20.286010+09:00
************************************************************
Instance SGA_TARGET = 2336 MB and SGA_MAX_SIZE = 4096 MB
************************************************************
2022-06-11T22:08:20.286184+09:00
****************************************************
 Sys-V shared memory will be used for creating SGA 
 ****************************************************
2022-06-11T22:08:20.286927+09:00
**********************************************************************
2022-06-11T22:08:20.287093+09:00
Dump of system resources acquired for SHARED GLOBAL AREA (SGA) 

2022-06-11T22:08:20.287182+09:00
 Domain name: system.slice/sshd.service
2022-06-11T22:08:20.287228+09:00
 Per process system memlock (soft) limit = 64K
2022-06-11T22:08:20.287272+09:00
 Expected per process system memlock (soft) limit to lock
 instance MAX SHARED GLOBAL AREA (SGA) into memory: 4098M
2022-06-11T22:08:20.287364+09:00
 Available system pagesizes:
  4K, 2048K 
2022-06-11T22:08:20.287448+09:00
 Supported system pagesize(s):
2022-06-11T22:08:20.287491+09:00
  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)
2022-06-11T22:08:20.287536+09:00
        4K       Configured               7         1048583        NONE
2022-06-11T22:08:20.287615+09:00
     2048K                0            2049               0        NONE
2022-06-11T22:08:20.287660+09:00
RECOMMENDATION:
2022-06-11T22:08:20.287726+09: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-06-11T22:08:20.293035+09:00
 2. Increase per process memlock (soft) limit to at least 4098MB
 to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory
2022-06-11T22:08:20.293131+09:00
**********************************************************************
2022-06-11T22:08:23.364358+09:00
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
2022-06-11T22:08:23.395487+09:00
Initial number of CPU is 4
Number of processor cores in the system is 4
Number of processor sockets in the system is 4
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 =55
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.3.0/dbhome_1
System name:	Linux
Node name:	oracle19c
Release:	4.18.0-372.9.1.el8.x86_64
Version:	#1 SMP Fri Apr 15 22:12:19 EDT 2022
Machine:	x86_64
▼ 使用した初期化パラメータ―ファイル
Using parameter settings in server-side spfile /u01/app/oracle/product/19.3.0/dbhome_1/dbs/spfileorcl.ora
▼ デフォルト値から変更されている初期化パラメータが表示されている
System parameters with non-default values:
  processes                = 320
  sga_max_size             = 4G
  sga_target               = 2336M
  control_files            = "/u01/app/oracle/oradata/ORCL/controlfile/o1_mf_k8o187fh_.ctl"
  control_files            = "/u01/app/oracle/fast_recovery_area/ORCL/controlfile/o1_mf_k8o187hr_.ctl"
  db_block_size            = 8192
  compatible               = "19.0.0"
  db_create_file_dest      = "/u01/app/oracle/oradata"
  db_recovery_file_dest    = "/u01/app/oracle/fast_recovery_area"
  db_recovery_file_dest_size= 10G
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
  audit_file_dest          = "/u01/app/oracle/admin/orcl/adump"
  audit_trail              = "DB"
  db_name                  = "orcl"
  open_cursors             = 300
  pga_aggregate_target     = 777M
  diagnostic_dest          = "/u01/app/oracle"
▲
2022-06-11T22:08:23.624200+09:00
============================================================
NOTE: PatchLevel of this instance 0
============================================================
▼バックグラウンドプロセスがいろいろ起動
Starting background process PMON
2022-06-11T22:08:23.950909+09:00
PMON started with pid=2, OS id=145709 
Starting background process CLMN
2022-06-11T22:08:23.961603+09:00
CLMN started with pid=3, OS id=145711 
Starting background process PSP0
2022-06-11T22:08:23.971585+09:00
PSP0 started with pid=4, OS id=145713 
Starting background process VKTM
2022-06-11T22:08:24.984519+09:00
VKTM started with pid=5, OS id=145715 at elevated (RT) priority
2022-06-11T22:08:24.984560+09:00
Starting background process GEN0
2022-06-11T22:08:24.985490+09:00
VKTM running at (1)millisec precision with DBRM quantum (100)ms
2022-06-11T22:08:24.990803+09:00
GEN0 started with pid=6, OS id=145719 
Starting background process MMAN
2022-06-11T22:08:24.998508+09:00
MMAN started with pid=7, OS id=145721 
Starting background process GEN1
2022-06-11T22:08:25.018951+09:00
GEN1 started with pid=9, OS id=145725_145726 
Starting background process DIAG
2022-06-11T22:08:25.027381+09:00
DIAG started with pid=11, OS id=145728 
Starting background process OFSD
2022-06-11T22:08:25.037399+09:00
OFSD started with pid=12, OS id=145730_145731 
Starting background process DBRM
2022-06-11T22:08:25.038035+09:00
Oracle running with ofslib:'Oracle File Server Library' version=2
Starting background process VKRM
2022-06-11T22:08:25.045668+09:00
DBRM started with pid=14, OS id=145733 
2022-06-11T22:08:25.052245+09:00
VKRM started with pid=15, OS id=145735 
Starting background process SVCB
2022-06-11T22:08:25.060939+09:00
SVCB started with pid=16, OS id=145737 
Starting background process PMAN
Starting background process DIA0
2022-06-11T22:08:25.068832+09:00
PMAN started with pid=17, OS id=145739 
2022-06-11T22:08:25.078166+09:00
DIA0 started with pid=18, OS id=145741 
Starting background process DBW0
2022-06-11T22:08:25.090027+09:00
DBW0 started with pid=19, OS id=145743 
Starting background process LGWR
2022-06-11T22:08:25.098242+09:00
LGWR started with pid=20, OS id=145745 
Starting background process CKPT
2022-06-11T22:08:25.105665+09:00
CKPT started with pid=21, OS id=145747 
2022-06-11T22:08:25.114242+09:00
LGWR slave LG00 created with pid=22, OS pid=145749
Starting background process SMON
2022-06-11T22:08:25.120570+09:00
SMON started with pid=23, OS id=145751 
LGWR slave LG01 created with pid=24, OS pid=145753
Starting background process SMCO
2022-06-11T22:08:25.135428+09:00
SMCO started with pid=25, OS id=145755 
Starting background process RECO
2022-06-11T22:08:25.142140+09:00
RECO started with pid=26, OS id=145757 
Starting background process LREG
2022-06-11T22:08:25.161791+09:00
LREG started with pid=28, OS id=145761 
Starting background process PXMN
2022-06-11T22:08:25.179218+09:00
PXMN started with pid=30, OS id=145765 
Starting background process FENC
Starting background process MMON
2022-06-11T22:08:25.189295+09:00
FENC started with pid=31, OS id=145767 
2022-06-11T22:08:25.198114+09:00
MMON started with pid=32, OS id=145769 
Starting background process MMNL
2022-06-11T22:08:25.206858+09:00
MMNL started with pid=33, OS id=145771 
2022-06-11T22:08:25.206917+09:00
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Starting background process TMON
2022-06-11T22:08:25.242638+09:00
TMON started with pid=35, OS id=145777 
Setting CPU count to 4
ORACLE_BASE from environment = /u01/app/oracle
2022-06-11T22:08:25.275516+09:00
▼ DBマウント 開始
ALTER DATABASE   MOUNT
2022-06-11T22:08:28.109958+09:00
Using default pga_aggregate_limit of 2048 MB
2022-06-11T22:08:29.337011+09:00
.... (PID:145778): Redo network throttle feature is disabled at mount time
2022-06-11T22:08:29.346670+09:00
Successful mount of redo thread 1, with mount id 1634894937
2022-06-11T22:08:29.346947+09:00
Database mounted in Exclusive Mode
Lost write protection disabled
.... (PID:145778): Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST [krsd.c:18157]
Completed: ALTER DATABASE   MOUNT
▲ DBマウント 終了
2022-06-11T22:09:51.803327+09:00
ALTER DATABASE ARCHIVELOG ★
Completed: ALTER DATABASE ARCHIVELOG
2022-06-11T22:09:58.989237+09:00
TMON (PID:145777): STARTING ARCH PROCESSES
Starting background process ARC0
2022-06-11T22:09:59.004012+09:00
ARC0 started with pid=36, OS id=145803 
Starting background process ARC1
2022-06-11T22:09:59.011622+09:00
ARC1 started with pid=39, OS id=145805 
Starting background process ARC2
2022-06-11T22:09:59.019443+09:00
ARC2 started with pid=40, OS id=145807 
Starting background process ARC3
TMON (PID:145777): ARC0: Archival started
2022-06-11T22:09:59.028269+09:00
ARC3 started with pid=41, OS id=145809 
TMON (PID:145777): ARC1: Archival started
TMON (PID:145777): ARC2: Archival started
2022-06-11T22:09:59.028466+09:00
ARC2 (PID:145807): Becoming a 'no FAL' ARCH
ARC2 (PID:145807): Becoming the 'no SRL' ARCH
2022-06-11T22:09:59.038596+09:00
TMON (PID:145777): ARC3: Archival started
TMON (PID:145777): STARTING ARCH PROCESSES COMPLETE
2022-06-11T22:09:59.047159+09:00
TT00 (PID:145811): Gap Manager starting
2022-06-11T22:09:59.884221+09:00
▼ DBオープン 開始
ALTER DATABASE OPEN
2022-06-11T22:09:59.887862+09:00
Ping without log force is disabled:
  instance mounted in exclusive mode.
Endian type of dictionary set to little
2022-06-11T22:09:59.900630+09:00
Redo log for group 2, sequence 20 is not located on DAX storage
Thread 1 opened at log sequence 20
  Current log# 2 seq# 20 mem# 0: /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_k8o18b6x_.log
  Current log# 2 seq# 20 mem# 1: /u01/app/oracle/fast_recovery_area/ORCL/onlinelog/o1_mf_2_k8o18d6j_.log
Successful open of redo thread 1
2022-06-11T22:09:59.911023+09:00
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
stopping change tracking
Undo initialization recovery: err:0 start: 845387190 end: 845387192 diff: 2 ms (0.0 seconds)
[145785] Successfully onlined Undo Tablespace 2.
Undo initialization online undo segments: err:0 start: 845387192 end: 845387211 diff: 19 ms (0.0 seconds)
Undo initialization finished serial:0 start:845387190 end:845387213 diff:23 ms (0.0 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
joxcsys_required_dirobj_exists: directory object exists with required path /u01/app/oracle/product/19.3.0/dbhome_1/javavm/admin/, pid 145785 cid 0
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process AQPC
2022-06-11T22:10:00.239250+09:00
AQPC started with pid=45, OS id=145817 
Starting background process CJQ0
2022-06-11T22:10:00.343696+09:00
CJQ0 started with pid=46, OS id=145819 
Completed: ALTER DATABASE OPEN
▲ DBオープン 
2022-06-11T22:10:03.536079+09:00
Setting Resource Manager plan SCHEDULER[0x4D57]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2022-06-11T22:10:10.984416+09:00
QPI: opatch file present, opatch
QPI: qopiprep.bat file present
2022-06-11T22:10:17.231635+09:00
▼ 適用済みパッチの表示
===========================================================
Dumping current patch information
===========================================================
Patch Id: 29517242
Patch Description: Database Release Update : 19.3.0.0.190416 (29517242)
Patch Apply Time: 2019-04-18T16:21:17+09: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-18T16:21:33+09: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
===========================================================
▲ 適用済みパッチ ここまで