12c ORACLE 의 매일 아침 점검 중 alert log 에서 당황 스러운 메세지를 발견 합니다.
Fri Sep 20 14:52:25 2019
Archived Log entry 12455 added for thread 2 sequence 4251 ID 0x24f46998 dest 1:
Fri Sep 20 19:00:28 2019
Thread 2 advanced to log sequence 4253 (LGWR switch)
Current log# 13 seq# 4253 mem# 0: +DATA/TESTDB/ONLINELOG/group_13.289.965129235
Current log# 13 seq# 4253 mem# 1: +DATA/TESTDB/ONLINELOG/group_13.290.965129235
Fri Sep 20 19:00:28 2019
Archived Log entry 12459 added for thread 2 sequence 4252 ID 0x24f46998 dest 1:
Fri Sep 20 21:59:57 2019
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Fri Sep 20 22:05:10 2019
Thread 2 advanced to log sequence 4254 (LGWR switch)
Current log# 14 seq# 4254 mem# 0: +DATA/TESTDB/ONLINELOG/group_14.291.965129235
Creating new log segment:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options.
ORACLE_HOME = /oracle/app/product/db
System name: Linux
Node name: TEST2
Release: 3.10.0-327.el7.x86_64
Version: #1 SMP Thu Oct 29 17:29:29 EDT 2015
Machine: x86_64
Using parameter settings in client-side pfile
System parameters with non-default values:
processes = 3000
event = "10555 trace name context forever, level 1"
_enable_shared_pool_durations= FALSE
use_large_pages = "ONLY"
lock_sga = FALSE
large_pool_size = 384M
java_pool_size = 384M
.
.
.
===========================================================
Dumping current patch information
===========================================================
Patch Id: 19769480
Patch Description: Database Patch Set Update : 12.1.0.2.2 (19769480)
Patch Apply Time: 2018-01-11 13:24:10 GMT+09:00
Bugs Fixed: 14643995,16359751,16870214,17835294,18250893,18288842,18354830,
18436647,18456643,18610915,18618122,18674024,18674047,18791688,18845653,
18849537,18885870,18921743,18948177,18952989,18964939,18964978,18967382,
18988834,18990693,19001359,19001390,19016730,19018206,19022470,19024808,
19028800,19044962,19048007,19050649,19052488,19054077,19058490,19065556,
19067244,19068610,19068970,19074147,19075256,19076343,19077215,19124589,
19134173,19143550,19149990,19154375,19155797,19157754,19174430,19174521,
19174942,19176223,19176326,19178851,19180770,19185876,19189317,19189525,
19195895,19197175,19248799,19279273,19280225,19289642,19303936,19304354,
19309466,19329654,19371175,19382851,19390567,19409212,19430401,19434529,
19439759,19440586,19468347,19501299,19518079,19520602,19532017,19561643,
19577410,19597439,19676905,19706965,19708632,19723336,19769480,20074391,
20284155
.
.
.
Patch Id: 26925311
Patch Description: Database Patch Set Update : 12.1.0.2.180116 (26925311)
Patch Apply Time: 2018-02-26 12:21:37 GMT+09:00
Bugs Fixed: 18419520,18849970,19211433,19370504,20324049,20382309,20470877,
20480209,20717359,21281607,21641760,21773465,22256560,22366322,22492533,
22518784,22536802,22645009,22707866,22721409,22729345,22826718,23007241,
23065323,23088803,23105538,23237313,23528412,23543183,23572982,24365589,
24385983,24401351,24415926,24461826,24509056,24570598,24624166,24718260,
24796092,24831514,24929210,25150925,25165496,25178179,25192729,25313154,
25764020,26024732,26366517,26569225,26758193,26898563
Patch Id: 26513709
Patch Description:
Patch Apply Time: 2018-11-14 21:50:29 GMT+09:00
Bugs Fixed: 26513709
===========================================================
Archived Log entry 12455 added for thread 2 sequence 4251 ID 0x24f46998 dest 1:
Fri Sep 20 19:00:28 2019
Thread 2 advanced to log sequence 4253 (LGWR switch)
Current log# 13 seq# 4253 mem# 0: +DATA/TESTDB/ONLINELOG/group_13.289.965129235
Current log# 13 seq# 4253 mem# 1: +DATA/TESTDB/ONLINELOG/group_13.290.965129235
Fri Sep 20 19:00:28 2019
Archived Log entry 12459 added for thread 2 sequence 4252 ID 0x24f46998 dest 1:
Fri Sep 20 21:59:57 2019
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Fri Sep 20 22:05:10 2019
Thread 2 advanced to log sequence 4254 (LGWR switch)
Current log# 14 seq# 4254 mem# 0: +DATA/TESTDB/ONLINELOG/group_14.291.965129235
Creating new log segment:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options.
ORACLE_HOME = /oracle/app/product/db
System name: Linux
Node name: TEST2
Release: 3.10.0-327.el7.x86_64
Version: #1 SMP Thu Oct 29 17:29:29 EDT 2015
Machine: x86_64
Using parameter settings in client-side pfile
System parameters with non-default values:
processes = 3000
event = "10555 trace name context forever, level 1"
_enable_shared_pool_durations= FALSE
use_large_pages = "ONLY"
lock_sga = FALSE
large_pool_size = 384M
java_pool_size = 384M
.
.
.
===========================================================
Dumping current patch information
===========================================================
Patch Id: 19769480
Patch Description: Database Patch Set Update : 12.1.0.2.2 (19769480)
Patch Apply Time: 2018-01-11 13:24:10 GMT+09:00
Bugs Fixed: 14643995,16359751,16870214,17835294,18250893,18288842,18354830,
18436647,18456643,18610915,18618122,18674024,18674047,18791688,18845653,
18849537,18885870,18921743,18948177,18952989,18964939,18964978,18967382,
18988834,18990693,19001359,19001390,19016730,19018206,19022470,19024808,
19028800,19044962,19048007,19050649,19052488,19054077,19058490,19065556,
19067244,19068610,19068970,19074147,19075256,19076343,19077215,19124589,
19134173,19143550,19149990,19154375,19155797,19157754,19174430,19174521,
19174942,19176223,19176326,19178851,19180770,19185876,19189317,19189525,
19195895,19197175,19248799,19279273,19280225,19289642,19303936,19304354,
19309466,19329654,19371175,19382851,19390567,19409212,19430401,19434529,
19439759,19440586,19468347,19501299,19518079,19520602,19532017,19561643,
19577410,19597439,19676905,19706965,19708632,19723336,19769480,20074391,
20284155
.
.
.
Patch Id: 26925311
Patch Description: Database Patch Set Update : 12.1.0.2.180116 (26925311)
Patch Apply Time: 2018-02-26 12:21:37 GMT+09:00
Bugs Fixed: 18419520,18849970,19211433,19370504,20324049,20382309,20470877,
20480209,20717359,21281607,21641760,21773465,22256560,22366322,22492533,
22518784,22536802,22645009,22707866,22721409,22729345,22826718,23007241,
23065323,23088803,23105538,23237313,23528412,23543183,23572982,24365589,
24385983,24401351,24415926,24461826,24509056,24570598,24624166,24718260,
24796092,24831514,24929210,25150925,25165496,25178179,25192729,25313154,
25764020,26024732,26366517,26569225,26758193,26898563
Patch Id: 26513709
Patch Description:
Patch Apply Time: 2018-11-14 21:50:29 GMT+09:00
Bugs Fixed: 26513709
===========================================================
갑자기 디비가 시작 할 때나 보이던 모습이 보입니다!! 디비가 언제 리붓 된게 아닌가 하는 혼란 스러운 생각이 들게 하는 메세지 입니다.
침착하게 보면 이 메세지는 디비가 스타트 할 때 나타내는 정보가 아닌걸 알수가 있습니다. 어디에도 startup 메세지가 안보이기 때문이죠
실제로 v$instance 에서 startup 시간을 조회 해봐도 리붓 된건 아닌걸 확인 할 수 있습니다.
메타 링크에서 해당 정보에 대한 문서를 발견 할 수 있습니다.
Dumping Current Patch Information Shows Up In Alert Log At Random Times (Doc ID 2377750.1)
원인을 보면 12.1.0.2 이상의 버전에서 log.xml 파일 10M 에 도달 했을 때 새로운 log_.xml 파일을 만들어 주면서 위 정보를 표시 하고 만들어 주는 것입니다.
alert log 를 보면 대략 22:05 분 쯤 파일이 생성 이 된것으로 보입니다.
실제 파일 생성도 22:05 인 것을 확인 할 수 있습니다.
Fri Sep 20 19:00:28 2019
Archived Log entry 12459 added for thread 2 sequence 4252 ID 0x24f46998 dest 1:
Fri Sep 20 21:59:57 2019
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Fri Sep 20 22:05:10 2019
Thread 2 advanced to log sequence 4254 (LGWR switch)
Current log# 14 seq# 4254 mem# 0: +DATA/TESTDB/ONLINELOG/group_14.291.965129235
Creating new log segment:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options.
ORACLE_HOME = /oracle/app/product/db
System name: Linux
Node name: TEST2
Release: 3.10.0-327.el7.x86_64
Archived Log entry 12459 added for thread 2 sequence 4252 ID 0x24f46998 dest 1:
Fri Sep 20 21:59:57 2019
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Fri Sep 20 22:05:10 2019
Thread 2 advanced to log sequence 4254 (LGWR switch)
Current log# 14 seq# 4254 mem# 0: +DATA/TESTDB/ONLINELOG/group_14.291.965129235
Creating new log segment:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options.
ORACLE_HOME = /oracle/app/product/db
System name: Linux
Node name: TEST2
Release: 3.10.0-327.el7.x86_64
[TEST2:oracle@TEST2] /oracle/app/diag/rdbms/TEST/TEST2/alert> ls -l
total 10348
-rw-r----- 1 oracle dba 100728 Sep 23 12:56 log.xml
-rw-r----- 1 oracle dba 10485814 Sep 20 22:05 log_1.xml
[TEST2:oracle@TEST2] /oracle/app/diag/rdbms/TEST/TEST2/alert>
total 10348
-rw-r----- 1 oracle dba 100728 Sep 23 12:56 log.xml
-rw-r----- 1 oracle dba 10485814 Sep 20 22:05 log_1.xml
[TEST2:oracle@TEST2] /oracle/app/diag/rdbms/TEST/TEST2/alert>
이 정보를 표시 하기를 원지 않으 시는 분은
_log_segment_dump_parameter=FALSE
_log_segment_dump_patch=FALSE
이 디비 파라미터를 꺼 놓으시면 될거 같습니다.